DBA Data[Home] [Help]

APPS.PQP_GB_MANAGE_LIFE_EVENTS dependencies on BEN_BENEFIT_ACTIONS

Line 17: ,ben_benefit_actions bac

13: SELECT rep.reporting_id
14: ,rep.rep_typ_cd
15: ,rep.text
16: FROM ben_reporting rep
17: ,ben_benefit_actions bac
18: WHERE rep.person_id = p_person_id
19: AND bac.benefit_action_id = rep.benefit_action_id
20: AND bac.process_date = p_process_date
21: ORDER BY rep.creation_date DESC; -- DESC order by to get latest row