APPS.BEN_DETERMINE_COMMUNICATIONS dependencies on BEN_PERSON_ACTIONS

Line 90: ben_person_actions to drive by

86: Made changes to standard_header procedure
87: to take a substring of 80 characters
88: 115.38 11-dec-2002 hmani NoCopy changes
89: 115.39 30-dec-2003 mmudigon Bug 3232205. Modified cursors on
90: ben_person_actions to drive by
91: benefit_action_id
92: 115.40 17-Sep-2004 pabodla iRec - c_pil_enrtrmdr : modified not to consider
93: GSP/irec/comp events.
94: 115.41 27-Dec-2004 tjesumic person_type_id is validated for the communications

Line 340: from ben_person_actions pac

336: and bft.request_id = fnd_global.conc_request_id;
337: --
338: cursor c_person_actions(p_status_cd varchar2) is
339: select count(*)
340: from ben_person_actions pac
341: where pac.benefit_action_id = g_parm.benefit_action_id
342: and pac.action_status_cd = nvl(p_status_cd,pac.action_status_cd);
343: --
344: begin

Line 2489: from ben_person_actions bpa

2485: ,p_end_person_action_id in number) is
2486: --
2487: cursor c_per_actn is
2488: select *
2489: from ben_person_actions bpa
2490: where bpa.benefit_action_id = g_parm.benefit_action_id
2491: and bpa.person_action_id between p_start_person_action_id
2492: and p_end_person_action_id
2493: and bpa.action_status_cd <> 'P'

Line 2707: from ben_person_actions bpa

2703: ,p_end_person_action_id in number) is
2704: --
2705: cursor c_per_actn is
2706: select *
2707: from ben_person_actions bpa
2708: where bpa.benefit_action_id = g_parm.benefit_action_id
2709: and bpa.person_action_id between p_start_person_action_id
2710: and p_end_person_action_id
2711: and bpa.action_status_cd <> 'P'

Line 2839: from ben_person_actions bpa

2835: ,p_end_person_action_id in number) is
2836: --
2837: cursor c_per_actn is
2838: select *
2839: from ben_person_actions bpa
2840: where bpa.benefit_action_id = g_parm.benefit_action_id
2841: and bpa.person_action_id between p_start_person_action_id
2842: and p_end_person_action_id
2843: and bpa.benefit_action_id = g_parm.benefit_action_id

Line 2975: from ben_person_actions bpa

2971: ,p_end_person_action_id in number) is
2972: --
2973: cursor c_per_actn is
2974: select *
2975: from ben_person_actions bpa
2976: where bpa.benefit_action_id = g_parm.benefit_action_id
2977: and bpa.person_action_id between p_start_person_action_id
2978: and p_end_person_action_id
2979: and bpa.action_status_cd <> 'P'

Line 3459: ben_person_actions_api.create_person_actions

3455: -- above. The default (if no person selecion rule was passed in) is 'Y'.
3456: --
3457: if l_person_ok = 'Y' then
3458: --
3459: ben_person_actions_api.create_person_actions
3460: (p_validate => FALSE
3461: ,p_person_action_id => l_person_action_id
3462: ,p_person_id => p_person_id
3463: ,p_ler_id => p_ler_id