APPS.BEN_AUTOMATIC_ENROLLMENTS dependencies on BEN_ELIG_CVRD_DPNT_F

Line 191: from ben_elig_cvrd_dpnt_f pdp_old

187: pdp_old.PROGRAM_UPDATE_DATE,
188: pdp_old.OBJECT_VERSION_NUMBER,
189: pdp_old.elig_cvrd_dpnt_id,
190: pdp_old.EFFECTIVE_START_DATE
191: from ben_elig_cvrd_dpnt_f pdp_old
192: where
193: pdp_old.per_in_ler_id = v_per_in_ler_id
194: and pdp_old.prtt_enrt_rslt_id = v_enrt_rslt_id
195: and pdp_old.business_group_id = p_business_group_id;

Line 236: from ben_elig_cvrd_dpnt_f pdp,

232: v_prtt_enrt_rslt_id number,
233: v_dsgn_rqmt_id number ,
234: v_grp_rlshp_cd varchar2 ) is
235: select count(pdp.dpnt_person_id)
236: from ben_elig_cvrd_dpnt_f pdp,
237: ben_elig_dpnt egd ,
238: per_contact_relationships pcr
239: where pdp.business_group_id = p_business_group_id
240: and pdp.per_in_ler_id = v_per_in_ler_id

Line 287: l_elig_cvrd_dpnt_id ben_elig_cvrd_dpnt_f.elig_cvrd_dpnt_id%TYPE;

283: l_dsgn_rqmt_id number;
284: l_object_version_number number;
285: l_eff_start_date date;
286: l_eff_end_date date;
287: l_elig_cvrd_dpnt_id ben_elig_cvrd_dpnt_f.elig_cvrd_dpnt_id%TYPE;
288:
289: begin
290: --
291: hr_utility.set_location('Entering: '||l_proc,10);

Line 794: l_elig_cvrd_dpnt_id ben_elig_cvrd_dpnt_f.elig_cvrd_dpnt_id%TYPE;

790: l_eff_start_date date;
791: l_eff_end_date date;
792: l_effective_dt date;
793: l_prev_eff_dt date;
794: l_elig_cvrd_dpnt_id ben_elig_cvrd_dpnt_f.elig_cvrd_dpnt_id%TYPE;
795:
796: l_rec ben_env_object.g_global_env_rec_type;
797: l_cryfwd_elig_dpnt_cd varchar2(30) ;
798: l_prev_rslt_id_at number := 0 ;