DBA Data[Home] [Help]

APPS.BEN_ENROLLMENT_PROCESS dependencies on BEN_ELIG_DPNT

Line 124: from ben_elig_dpnt egd

120: p_dpnt_person_id number) is
121: select egd.elig_dpnt_id,
122: egd.elig_strt_dt,
123: egd.elig_thru_dt
124: from ben_elig_dpnt egd
125: where egd.per_in_ler_id = p_per_in_ler_id
126: and egd.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
127: and egd.dpnt_person_id = p_dpnt_person_id ;
128: --

Line 2357: ben_elig_dpnt_api.process_dependent(

2353: buff => ' l_egd.elig_dpnt_id '||l_egd.elig_dpnt_id);
2354: --
2355: IF l_egd.elig_dpnt_id IS NOT NULL THEN
2356: --
2357: ben_elig_dpnt_api.process_dependent(
2358: p_validate => p_validate
2359: ,p_elig_dpnt_id => l_egd.elig_dpnt_id
2360: ,p_business_group_id => p_business_group_id
2361: ,p_effective_date => p_effective_date

Line 2392: ben_elig_dpnt_api.process_dependent(

2388: buff => ' l_egd.elig_dpnt_id '||l_egd.elig_dpnt_id);
2389: --
2390: IF l_egd.elig_dpnt_id IS NOT NULL THEN
2391: --
2392: ben_elig_dpnt_api.process_dependent(
2393: p_validate => p_validate
2394: ,p_elig_dpnt_id => l_egd.elig_dpnt_id
2395: ,p_business_group_id => p_business_group_id
2396: ,p_effective_date => p_effective_date