DBA Data[Home] [Help]

APPS.BEN_DET_ENRT_RATES dependencies on BEN_LER_F

Line 129: from ben_ler_f ler,

125: between pen.effective_start_date and pen.effective_end_date
126: and pen.effective_end_date = hr_api.g_eot
127: and -- start 4354929
128: ( EXISTS ( select null
129: from ben_ler_f ler,
130: ben_elig_per_elctbl_chc epe
131: where ler.ler_id = pen.ler_id
132: and (( ler.typ_cd = 'SCHEDDU'
133: and pen.prtt_enrt_rslt_id = epe.prtt_enrt_rslt_id

Line 322: ben_ler_f ler

318: --
319: cursor c_unrestricted is
320: select 'Y'
321: from ben_per_in_ler pil,
322: ben_ler_f ler
323: where pil.per_in_ler_id = p_per_in_ler_id
324: and pil.ler_id = ler.ler_id
325: and ler.typ_cd = 'SCHEDDU'
326: and ler.business_group_id = p_business_group_id

Line 858: from ben_ler_f ler,

854: between pen.effective_start_date and pen.effective_end_date
855: and pen.effective_end_date = hr_api.g_eot
856: and -- start 4354929
857: ( EXISTS ( select null
858: from ben_ler_f ler,
859: ben_elig_per_elctbl_chc epe
860: where ler.ler_id = pen.ler_id
861: and (
862: ( ler.typ_cd = 'SCHEDDU'

Line 959: ben_ler_f ler

955: --
956: cursor c_unrestricted is
957: select 'Y'
958: from ben_per_in_ler pil,
959: ben_ler_f ler
960: where pil.per_in_ler_id = p_per_in_ler_id
961: and pil.ler_id = ler.ler_id
962: and ler.typ_cd = 'SCHEDDU'
963: and ler.business_group_id = p_business_group_id

Line 1248: ben_ler_f ler

1244: --
1245: cursor c_unrestricted is
1246: select 'Y'
1247: from ben_per_in_ler pil,
1248: ben_ler_f ler
1249: where pil.per_in_ler_id = p_per_in_ler_id
1250: and pil.ler_id = ler.ler_id
1251: and ler.typ_cd = 'SCHEDDU'
1252: and ler.business_group_id = p_business_group_id