APPS.GHR_FEHB_PLAN_DESIGN dependencies on BEN_CLPSE_LF_EVT_F

Line 77: l_clpse_lf_evt_id ben_clpse_lf_evt_f.clpse_lf_evt_id%type;

73:
74: l_proc varchar2(100) := 'create_person_type_usages';
75: l_chg_cs_ler_id number;
76: l_per_info_cs_id number;
77: l_clpse_lf_evt_id ben_clpse_lf_evt_f.clpse_lf_evt_id%type;
78: l_esd date := to_date('1951/01/01','yyyy/mm/dd');
79: l_eed date := to_date('4712/12/31','yyyy/mm/dd');
80: l_ovn number;
81: l_ler_id ben_ler_f.ler_id%type;

Line 385: l_clpse_lf_evt_id ben_clpse_lf_evt_f.clpse_lf_evt_id%type;

381: hr_utility.set_location('Leaving: '|| g_package||l_proc, 50);
382: End create_person_type_usages;
383:
384: Procedure create_collapse_rule (p_target_business_group_id in Number) is
385: l_clpse_lf_evt_id ben_clpse_lf_evt_f.clpse_lf_evt_id%type;
386: l_esd date := to_date('1951/01/01','yyyy/mm/dd');
387: l_eed date := to_date('4712/12/31','yyyy/mm/dd');
388: l_ovn number;
389: l_ler_id ben_ler_f.ler_id%type;

Line 397: l_seq ben_clpse_lf_evt_f.seq%type;

393: l_effective_date date;
394: l_le_name BEN_LER_F.name%type;
395: l_ctr number;
396: l_proc varchar2(100) := 'create_collapse_rule';
397: l_seq ben_clpse_lf_evt_f.seq%type;
398: -- Check whether an existing Collapsing rule is there between
399: -- the main life event and sub life events
400: cursor c_chk_clp is
401: select clpse_lf_evt_id

Line 402: from ben_clpse_lf_evt_f clp

398: -- Check whether an existing Collapsing rule is there between
399: -- the main life event and sub life events
400: cursor c_chk_clp is
401: select clpse_lf_evt_id
402: from ben_clpse_lf_evt_f clp
403: where clp.business_group_id = p_target_business_group_id
404: and eval_ler_id = l_ler_id
405: and ler1_id = l_ler_id1
406: and ler2_id = l_ler_id2

Line 411: from ben_clpse_lf_evt_f clp

407: and ler3_id = l_ler_id3;
408: -- Get the maximum sequence number for the given business group id
409: cursor c_get_clp_max_seq is
410: select nvl(max(seq),0) seqnum
411: from ben_clpse_lf_evt_f clp
412: where clp.business_group_id = p_target_business_group_id;
413:
414: cursor c_chk_ler is
415: select ler_id,effective_start_date from ben_ler_f