APPS.BEN_MANAGE_LIFE_EVENTS dependencies on BEN_PERSON_ACTIONS

Line 5477: l_ler_id ben_person_actions.ler_id%type;

5473: p_gsp_eval_elig_flag in varchar2 default null, /* GSP Rate Sync */
5474: p_lf_evt_oper_cd in varchar2 default null /* GSP Rate Sync */
5475: ) is
5476: --
5477: l_ler_id ben_person_actions.ler_id%type;
5478: l_person_id ben_person_actions.person_id%type;
5479: l_person_action_id ben_person_actions.person_action_id%type;
5480: l_object_version_number ben_person_actions.object_version_number%type;
5481: l_ptnl_ler_for_per_id ben_ptnl_ler_for_per.ptnl_ler_for_per_id%type;

Line 5478: l_person_id ben_person_actions.person_id%type;

5474: p_lf_evt_oper_cd in varchar2 default null /* GSP Rate Sync */
5475: ) is
5476: --
5477: l_ler_id ben_person_actions.ler_id%type;
5478: l_person_id ben_person_actions.person_id%type;
5479: l_person_action_id ben_person_actions.person_action_id%type;
5480: l_object_version_number ben_person_actions.object_version_number%type;
5481: l_ptnl_ler_for_per_id ben_ptnl_ler_for_per.ptnl_ler_for_per_id%type;
5482: l_effective_start_date date;

Line 5479: l_person_action_id ben_person_actions.person_action_id%type;

5475: ) is
5476: --
5477: l_ler_id ben_person_actions.ler_id%type;
5478: l_person_id ben_person_actions.person_id%type;
5479: l_person_action_id ben_person_actions.person_action_id%type;
5480: l_object_version_number ben_person_actions.object_version_number%type;
5481: l_ptnl_ler_for_per_id ben_ptnl_ler_for_per.ptnl_ler_for_per_id%type;
5482: l_effective_start_date date;
5483: l_effective_end_date date;

Line 5480: l_object_version_number ben_person_actions.object_version_number%type;

5476: --
5477: l_ler_id ben_person_actions.ler_id%type;
5478: l_person_id ben_person_actions.person_id%type;
5479: l_person_action_id ben_person_actions.person_action_id%type;
5480: l_object_version_number ben_person_actions.object_version_number%type;
5481: l_ptnl_ler_for_per_id ben_ptnl_ler_for_per.ptnl_ler_for_per_id%type;
5482: l_effective_start_date date;
5483: l_effective_end_date date;
5484: l_dummy varchar2(1);

Line 5502: from ben_person_actions ben

5498: select ben.person_id,
5499: ben.person_action_id,
5500: ben.object_version_number,
5501: ben.ler_id
5502: from ben_person_actions ben
5503: where ben.benefit_action_id = p_benefit_action_id
5504: and ben.action_status_cd <> 'P'
5505: and ben.person_action_id
5506: between p_start_person_action_id

Line 7835: from ben_person_actions

7831: --
7832: l_person_id per_all_people_f.person_id%type;
7833: cursor c_person_info is
7834: select person_id
7835: from ben_person_actions
7836: where benefit_action_id = p_benefit_action_id
7837: and action_status_cd = 'P';
7838:
7839: cursor c_pln is

Line 8343: ben_person_actions_api.create_person_actions

8339: -- A bit of a hack to force the creation of a person action as we
8340: -- don't have a potential life event at this point and we want to be
8341: -- able to safely roll the person back should an error occur.
8342: --
8343: ben_person_actions_api.create_person_actions
8344: (p_validate => false,
8345: p_person_action_id => l_person_action_id,
8346: p_person_id => p_person_id,
8347: p_ler_id => l_ler_rec.ler_id,

Line 13622: from ben_person_actions pac

13618: l_proc varchar2(80);
13619: --
13620: cursor c_person_actions(p_status_cd varchar2) is
13621: select count(*)
13622: from ben_person_actions pac
13623: where pac.benefit_action_id = p_benefit_action_id
13624: and pac.action_status_cd = nvl(p_status_cd,pac.action_status_cd);
13625: --
13626: begin