DBA Data[Home] [Help]

APPS.BEN_DET_ENRT_RATES dependencies on BEN_LER_F

Line 173: from ben_ler_f ler,

169: between pen.effective_start_date and pen.effective_end_date
170: and pen.effective_end_date = hr_api.g_eot
171: and -- start 4354929
172: ( EXISTS ( select null
173: from ben_ler_f ler,
174: ben_elig_per_elctbl_chc epe
175: where ler.ler_id = pen.ler_id
176: and (( ler.typ_cd = 'SCHEDDU'
177: and pen.prtt_enrt_rslt_id = epe.prtt_enrt_rslt_id

Line 366: ben_ler_f ler

362: --
363: cursor c_unrestricted is
364: select 'Y'
365: from ben_per_in_ler pil,
366: ben_ler_f ler
367: where pil.per_in_ler_id = p_per_in_ler_id
368: and pil.ler_id = ler.ler_id
369: and ler.typ_cd = 'SCHEDDU'
370: and ler.business_group_id = p_business_group_id

Line 923: from ben_ler_f ler,

919: between pen.effective_start_date and pen.effective_end_date
920: and pen.effective_end_date = hr_api.g_eot
921: and -- start 4354929
922: ( EXISTS ( select null
923: from ben_ler_f ler,
924: ben_elig_per_elctbl_chc epe
925: where ler.ler_id = pen.ler_id
926: and (
927: ( ler.typ_cd = 'SCHEDDU'

Line 1024: ben_ler_f ler

1020: --
1021: cursor c_unrestricted is
1022: select 'Y'
1023: from ben_per_in_ler pil,
1024: ben_ler_f ler
1025: where pil.per_in_ler_id = p_per_in_ler_id
1026: and pil.ler_id = ler.ler_id
1027: and ler.typ_cd = 'SCHEDDU'
1028: and ler.business_group_id = p_business_group_id

Line 1313: ben_ler_f ler

1309: --
1310: cursor c_unrestricted is
1311: select 'Y'
1312: from ben_per_in_ler pil,
1313: ben_ler_f ler
1314: where pil.per_in_ler_id = p_per_in_ler_id
1315: and pil.ler_id = ler.ler_id
1316: and ler.typ_cd = 'SCHEDDU'
1317: and ler.business_group_id = p_business_group_id