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 336: from ben_person_actions pac

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

Line 2435: from ben_person_actions bpa

2431: ,p_end_person_action_id in number) is
2432: --
2433: cursor c_per_actn is
2434: select *
2435: from ben_person_actions bpa
2436: where bpa.benefit_action_id = g_parm.benefit_action_id
2437: and bpa.person_action_id between p_start_person_action_id
2438: and p_end_person_action_id
2439: and bpa.action_status_cd <> 'P'

Line 2649: from ben_person_actions bpa

2645: ,p_end_person_action_id in number) is
2646: --
2647: cursor c_per_actn is
2648: select *
2649: from ben_person_actions bpa
2650: where bpa.benefit_action_id = g_parm.benefit_action_id
2651: and bpa.person_action_id between p_start_person_action_id
2652: and p_end_person_action_id
2653: and bpa.action_status_cd <> 'P'

Line 2781: from ben_person_actions bpa

2777: ,p_end_person_action_id in number) is
2778: --
2779: cursor c_per_actn is
2780: select *
2781: from ben_person_actions bpa
2782: where bpa.benefit_action_id = g_parm.benefit_action_id
2783: and bpa.person_action_id between p_start_person_action_id
2784: and p_end_person_action_id
2785: and bpa.benefit_action_id = g_parm.benefit_action_id

Line 2917: from ben_person_actions bpa

2913: ,p_end_person_action_id in number) is
2914: --
2915: cursor c_per_actn is
2916: select *
2917: from ben_person_actions bpa
2918: where bpa.benefit_action_id = g_parm.benefit_action_id
2919: and bpa.person_action_id between p_start_person_action_id
2920: and p_end_person_action_id
2921: and bpa.action_status_cd <> 'P'

Line 3401: ben_person_actions_api.create_person_actions

3397: -- above. The default (if no person selecion rule was passed in) is 'Y'.
3398: --
3399: if l_person_ok = 'Y' then
3400: --
3401: ben_person_actions_api.create_person_actions
3402: (p_validate => FALSE
3403: ,p_person_action_id => l_person_action_id
3404: ,p_person_id => p_person_id
3405: ,p_ler_id => p_ler_id