APPS.BEN_LF_EVT_CLPS_RESTORE dependencies on BEN_ELIG_DPNT

Line 1030: from ben_elig_dpnt epe_egd

1026: l_differ varchar2(1) := 'N';
1027: --
1028: cursor c_bckdt_epe_egd is
1029: select epe_egd.*
1030: from ben_elig_dpnt epe_egd
1031: where epe_egd.elig_per_elctbl_chc_id = p_bckdt_epe_id
1032: and epe_egd.business_group_id = p_business_group_id
1033: and epe_egd.per_in_ler_id = p_bckdt_per_in_ler_id;
1034: --

Line 1037: from ben_elig_dpnt epe_egd

1033: and epe_egd.per_in_ler_id = p_bckdt_per_in_ler_id;
1034: --
1035: cursor c_curr_epe_egd is
1036: select epe_egd.*
1037: from ben_elig_dpnt epe_egd
1038: where epe_egd.elig_per_elctbl_chc_id = p_curr_epe_id
1039: and epe_egd.business_group_id = p_business_group_id
1040: and epe_egd.per_in_ler_id = p_per_in_ler_id;
1041: --

Line 1059: from ben_elig_dpnt epe_egd

1055: --
1056: hr_utility.set_location ('Entering '||l_proc,10);
1057: --
1058: select count(*) into l_bckdt_epe_egd_count
1059: from ben_elig_dpnt epe_egd
1060: where epe_egd.elig_per_elctbl_chc_id = p_bckdt_epe_id
1061: and epe_egd.business_group_id = p_business_group_id
1062: and epe_egd.per_in_ler_id = p_bckdt_per_in_ler_id;
1063: --

Line 4778: from ben_elig_dpnt edg

4774: --
4775: --
4776: cursor c_epe_dpnt(cp_dpnt_person_id in number) is
4777: select edg.*
4778: from ben_elig_dpnt edg
4779: where edg.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
4780: and edg.business_group_id = p_business_group_id
4781: and edg.dpnt_person_id = cp_dpnt_person_id;
4782: --

Line 4868: ben_ELIG_DPNT_api.process_dependent(

4864: open c_epe_dpnt(bckdt_pen_dpnts_rec.dpnt_person_id);
4865: fetch c_epe_dpnt into l_epe_dpnt_rec;
4866: if c_epe_dpnt%found then
4867: l_pdp_cr_up_flag := TRUE;
4868: ben_ELIG_DPNT_api.process_dependent(
4869: p_elig_dpnt_id => l_epe_dpnt_rec.elig_dpnt_id,
4870: p_business_group_id => p_business_group_id,
4871: p_effective_date => p_effective_date, -- Bug : 5124 As per Jeana, data
4872: -- should be reinstated with system date

Line 4902: ben_ELIG_DPNT_api.process_dependent(

4898: open c_epe_dpnt(bckdt_pen_dpnts_rec.dpnt_person_id);
4899: fetch c_epe_dpnt into l_epe_dpnt_rec;
4900: if c_epe_dpnt%found then
4901: l_pdp_cr_up_flag := TRUE;
4902: ben_ELIG_DPNT_api.process_dependent(
4903: p_elig_dpnt_id => l_epe_dpnt_rec.elig_dpnt_id,
4904: p_business_group_id => p_business_group_id,
4905: p_effective_date => p_effective_date, -- Bug : 5124 As per Jeana, data
4906: -- should be reinstated with system date