APPS.BEN_BATCH_UTILS dependencies on BEN_PERSON_ACTIONS

Line 740: from ben_person_actions act

736: ,p_non_person_cd in varchar2 default null
737: ) is
738: cursor c_actions is
739: Select count(*) amount,action_status_cd
740: from ben_person_actions act
741: where act.benefit_action_id = p_benefit_action_id
742: and act.action_status_cd in ('P','E','U')
743: and nvl(act.non_person_cd,'x') = nvl(p_non_person_cd,'x')
744: group by action_status_cd

Line 1646: From ben_person_actions act

1642: cursor c_person_actions is
1643: Select act.person_action_id
1644: ,act.person_id
1645: ,act.ler_id
1646: From ben_person_actions act
1647: Where act.action_status_cd <> 'P'
1648: and nvl(act.non_person_cd,'x') = nvl(p_non_person_cd,'x')
1649: and act.benefit_action_id = p_benefit_action_id
1650: ;