DBA Data[Home] [Help]

APPS.BEN_ELP_CACHE dependencies on BEN_ELIG_HRS_WKD_PRTE_F

Line 5362: from ben_elig_hrs_wkd_prte_f ecl,

5358: where p_effective_date
5359: between elp.effective_start_date
5360: and elp.effective_end_date
5361: and exists(select null
5362: from ben_elig_hrs_wkd_prte_f ecl,
5363: ben_hrs_wkd_in_perd_fctr clf
5364: where ecl.hrs_wkd_in_perd_fctr_id =
5365: clf.hrs_wkd_in_perd_fctr_id
5366: and ecl.business_group_id = clf.business_group_id

Line 5386: from ben_elig_hrs_wkd_prte_f ecl,

5382: clf.mx_hrs_num,
5383: clf.no_mn_hrs_wkd_flag,
5384: clf.no_mx_hrs_wkd_flag,
5385: clf.hrs_src_cd
5386: from ben_elig_hrs_wkd_prte_f ecl,
5387: ben_hrs_wkd_in_perd_fctr clf
5388: where ecl.hrs_wkd_in_perd_fctr_id = clf.hrs_wkd_in_perd_fctr_id
5389: and ecl.business_group_id = clf.business_group_id
5390: and p_effective_date