BEN Benefits ACA Errors

➜ Back to Library
XMLXML import file

Description

Categories
BI Publisher
Application
Advanced Benefits
Source
Benefits ACA Errors Report
Short Name
BENACAERR
Imported from BI Publisher
DB package:

SQL 12 lines

 SELECT rar.ben_attribute1||decode(rar.ben_attribute2,NULL,'',' '||rar.ben_attribute2)||' '||rar.ben_attribute3 person_name, rar.person_id, rpa.rep_file_id
FROM ben_rep_person_actions rpa, ben_rep_actions ra, ben_rep_archive rar
WHERE ra.gre_id = rpa.gre_id
AND rar.rep_action_id = ra.rep_action_id
AND ra.locking_rep_action_id = rpa.rep_action_id
AND rpa.person_id = rar.person_id
AND rpa.rec_submission_status = 'E'
AND rar.ben_attribute_category = 'PERSONINFO1'
AND rpa.gre_id = :P_GRE_ID
AND rpa.rep_action_id = :L_REP_ACTION_ID
ORDER BY person_name

Parameters 2

ParameterTypeList of values SQL
YearLOV Oracle
GRELOV Oracle