BEN Benefits ACA Errors

Description
Categories: BI Publisher, Human Resources
Application: Advanced Benefits
Source: Benefits ACA Errors Report
Short Name: BENACAERR
DB package:
 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
Parameter NameSQL textValidation
Archive Version
 
Number
GRE
 
LOV Oracle
Year
 
LOV Oracle