DBA Data[Home] [Help]

APPS.BEN_ENROLLMENT_PROCESS dependencies on BEN_ELIG_DPNT

Line 127: from ben_elig_dpnt egd

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

Line 2390: ben_elig_dpnt_api.process_dependent(

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

Line 2425: ben_elig_dpnt_api.process_dependent(

2421: buff => ' l_egd.elig_dpnt_id '||l_egd.elig_dpnt_id);
2422: --
2423: IF l_egd.elig_dpnt_id IS NOT NULL THEN
2424: --
2425: ben_elig_dpnt_api.process_dependent(
2426: p_validate => p_validate
2427: ,p_elig_dpnt_id => l_egd.elig_dpnt_id
2428: ,p_business_group_id => p_business_group_id
2429: ,p_effective_date => p_effective_date