APPS.BEN_LF_EVT_CLPS_RESTORE dependencies on BEN_ELIG_DPNT

Line 1260: from ben_elig_dpnt epe_egd

1256: l_differ varchar2(1) := 'N';
1257: --
1258: cursor c_bckdt_epe_egd is
1259: select epe_egd.*
1260: from ben_elig_dpnt epe_egd
1261: where epe_egd.elig_per_elctbl_chc_id = p_bckdt_epe_id
1262: and epe_egd.business_group_id = p_business_group_id
1263: and epe_egd.per_in_ler_id = p_bckdt_per_in_ler_id;
1264: --

Line 1267: from ben_elig_dpnt epe_egd

1263: and epe_egd.per_in_ler_id = p_bckdt_per_in_ler_id;
1264: --
1265: cursor c_curr_epe_egd is
1266: select epe_egd.*
1267: from ben_elig_dpnt epe_egd
1268: where epe_egd.elig_per_elctbl_chc_id = p_curr_epe_id
1269: and epe_egd.business_group_id = p_business_group_id
1270: and epe_egd.per_in_ler_id = p_per_in_ler_id;
1271: --

Line 1289: from ben_elig_dpnt epe_egd

1285: --
1286: hr_utility.set_location ('Entering '||l_proc,10);
1287: --
1288: select count(*) into l_bckdt_epe_egd_count
1289: from ben_elig_dpnt epe_egd
1290: where epe_egd.elig_per_elctbl_chc_id = p_bckdt_epe_id
1291: and epe_egd.business_group_id = p_business_group_id
1292: and epe_egd.per_in_ler_id = p_bckdt_per_in_ler_id;
1293: --

Line 5029: from ben_elig_dpnt edg

5025: --
5026: --
5027: cursor c_epe_dpnt(cp_dpnt_person_id in number) is
5028: select edg.*
5029: from ben_elig_dpnt edg
5030: where edg.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
5031: and edg.business_group_id = p_business_group_id
5032: and edg.dpnt_person_id = cp_dpnt_person_id;
5033: --

Line 5119: ben_ELIG_DPNT_api.process_dependent(

5115: open c_epe_dpnt(bckdt_pen_dpnts_rec.dpnt_person_id);
5116: fetch c_epe_dpnt into l_epe_dpnt_rec;
5117: if c_epe_dpnt%found then
5118: l_pdp_cr_up_flag := TRUE;
5119: ben_ELIG_DPNT_api.process_dependent(
5120: p_elig_dpnt_id => l_epe_dpnt_rec.elig_dpnt_id,
5121: p_business_group_id => p_business_group_id,
5122: p_effective_date => p_effective_date, -- Bug : 5124 As per Jeana, data
5123: -- should be reinstated with system date

Line 5153: ben_ELIG_DPNT_api.process_dependent(

5149: open c_epe_dpnt(bckdt_pen_dpnts_rec.dpnt_person_id);
5150: fetch c_epe_dpnt into l_epe_dpnt_rec;
5151: if c_epe_dpnt%found then
5152: l_pdp_cr_up_flag := TRUE;
5153: ben_ELIG_DPNT_api.process_dependent(
5154: p_elig_dpnt_id => l_epe_dpnt_rec.elig_dpnt_id,
5155: p_business_group_id => p_business_group_id,
5156: p_effective_date => p_effective_date, -- Bug : 5124 As per Jeana, data
5157: -- should be reinstated with system date