APPS.BEN_CARRY_FORWARD_ITEMS dependencies on BEN_ELIG_CVRD_DPNT_F

Line 483: from ben_elig_cvrd_dpnt_f pdp_old

479: pdp_old.PROGRAM_UPDATE_DATE,
480: pdp_old.OBJECT_VERSION_NUMBER,
481: pdp_old.elig_cvrd_dpnt_id,
482: pdp_old.EFFECTIVE_START_DATE
483: from ben_elig_cvrd_dpnt_f pdp_old
484: where
485: pdp_old.per_in_ler_id = v_per_in_ler_id
486: and pdp_old.prtt_enrt_rslt_id = v_enrt_rslt_id
487: and pdp_old.business_group_id = p_business_group_id;

Line 528: from ben_elig_cvrd_dpnt_f pdp,

524: v_prtt_enrt_rslt_id number,
525: v_dsgn_rqmt_id number ,
526: v_grp_rlshp_cd varchar2 ) is
527: select count(pdp.dpnt_person_id)
528: from ben_elig_cvrd_dpnt_f pdp,
529: ben_elig_dpnt egd ,
530: per_contact_relationships pcr
531: where pdp.business_group_id = p_business_group_id
532: and pdp.per_in_ler_id = v_per_in_ler_id

Line 579: l_elig_cvrd_dpnt_id ben_elig_cvrd_dpnt_f.elig_cvrd_dpnt_id%TYPE;

575: l_dsgn_rqmt_id number;
576: l_object_version_number number;
577: l_eff_start_date date;
578: l_eff_end_date date;
579: l_elig_cvrd_dpnt_id ben_elig_cvrd_dpnt_f.elig_cvrd_dpnt_id%TYPE;
580:
581: begin
582: --
583: hr_utility.set_location('Entering: '||l_proc,10);

Line 1162: l_elig_cvrd_dpnt_id ben_elig_cvrd_dpnt_f.elig_cvrd_dpnt_id%TYPE;

1158: l_eff_start_date date;
1159: l_eff_end_date date;
1160: l_effective_dt date;
1161: l_prev_eff_dt date;
1162: l_elig_cvrd_dpnt_id ben_elig_cvrd_dpnt_f.elig_cvrd_dpnt_id%TYPE;
1163:
1164: l_rec ben_env_object.g_global_env_rec_type;
1165: l_cryfwd_elig_dpnt_cd varchar2(30) ;
1166: l_prev_rslt_id_at number := 0 ;