APPS.BEN_BATCH_UTILS dependencies on BEN_PERSON_ACTIONS

Line 744: from ben_person_actions act

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

Line 1656: From ben_person_actions act

1652: cursor c_person_actions is
1653: Select act.person_action_id
1654: ,act.person_id
1655: ,act.ler_id
1656: From ben_person_actions act
1657: Where act.action_status_cd <> 'P'
1658: and nvl(act.non_person_cd,'x') = nvl(p_non_person_cd,'x')
1659: and act.benefit_action_id = p_benefit_action_id
1660: ;