APPS.BEN_MANAGE_LIFE_EVENTS dependencies on BEN_PERSON_ACTIONS

Line 5085: l_ler_id ben_person_actions.ler_id%type;

5081: p_gsp_eval_elig_flag in varchar2 default null, /* GSP Rate Sync */
5082: p_lf_evt_oper_cd in varchar2 default null /* GSP Rate Sync */
5083: ) is
5084: --
5085: l_ler_id ben_person_actions.ler_id%type;
5086: l_person_id ben_person_actions.person_id%type;
5087: l_person_action_id ben_person_actions.person_action_id%type;
5088: l_object_version_number ben_person_actions.object_version_number%type;
5089: l_ptnl_ler_for_per_id ben_ptnl_ler_for_per.ptnl_ler_for_per_id%type;

Line 5086: l_person_id ben_person_actions.person_id%type;

5082: p_lf_evt_oper_cd in varchar2 default null /* GSP Rate Sync */
5083: ) is
5084: --
5085: l_ler_id ben_person_actions.ler_id%type;
5086: l_person_id ben_person_actions.person_id%type;
5087: l_person_action_id ben_person_actions.person_action_id%type;
5088: l_object_version_number ben_person_actions.object_version_number%type;
5089: l_ptnl_ler_for_per_id ben_ptnl_ler_for_per.ptnl_ler_for_per_id%type;
5090: l_effective_start_date date;

Line 5087: l_person_action_id ben_person_actions.person_action_id%type;

5083: ) is
5084: --
5085: l_ler_id ben_person_actions.ler_id%type;
5086: l_person_id ben_person_actions.person_id%type;
5087: l_person_action_id ben_person_actions.person_action_id%type;
5088: l_object_version_number ben_person_actions.object_version_number%type;
5089: l_ptnl_ler_for_per_id ben_ptnl_ler_for_per.ptnl_ler_for_per_id%type;
5090: l_effective_start_date date;
5091: l_effective_end_date date;

Line 5088: l_object_version_number ben_person_actions.object_version_number%type;

5084: --
5085: l_ler_id ben_person_actions.ler_id%type;
5086: l_person_id ben_person_actions.person_id%type;
5087: l_person_action_id ben_person_actions.person_action_id%type;
5088: l_object_version_number ben_person_actions.object_version_number%type;
5089: l_ptnl_ler_for_per_id ben_ptnl_ler_for_per.ptnl_ler_for_per_id%type;
5090: l_effective_start_date date;
5091: l_effective_end_date date;
5092: l_dummy varchar2(1);

Line 5110: from ben_person_actions ben

5106: select ben.person_id,
5107: ben.person_action_id,
5108: ben.object_version_number,
5109: ben.ler_id
5110: from ben_person_actions ben
5111: where ben.benefit_action_id = p_benefit_action_id
5112: and ben.action_status_cd <> 'P'
5113: and ben.person_action_id
5114: between p_start_person_action_id

Line 7429: from ben_person_actions

7425: --
7426: l_person_id per_all_people_f.person_id%type;
7427: cursor c_person_info is
7428: select person_id
7429: from ben_person_actions
7430: where benefit_action_id = p_benefit_action_id
7431: and action_status_cd = 'P';
7432:
7433: cursor c_pln is

Line 7935: ben_person_actions_api.create_person_actions

7931: -- A bit of a hack to force the creation of a person action as we
7932: -- don't have a potential life event at this point and we want to be
7933: -- able to safely roll the person back should an error occur.
7934: --
7935: ben_person_actions_api.create_person_actions
7936: (p_validate => false,
7937: p_person_action_id => l_person_action_id,
7938: p_person_id => p_person_id,
7939: p_ler_id => l_ler_rec.ler_id,

Line 12973: from ben_person_actions pac

12969: l_proc varchar2(80);
12970: --
12971: cursor c_person_actions(p_status_cd varchar2) is
12972: select count(*)
12973: from ben_person_actions pac
12974: where pac.benefit_action_id = p_benefit_action_id
12975: and pac.action_status_cd = nvl(p_status_cd,pac.action_status_cd);
12976: --
12977: begin