DBA Data[Home] [Help]

APPS.BEN_COMP_OBJECT dependencies on BEN_PER_IN_LER

Line 1273: ,ben_per_in_ler pil

1269: reg.name)
1270: and exists
1271: ( select 1
1272: from ben_elig_per_f epo
1273: ,ben_per_in_ler pil
1274: where epo.pgm_id = p_pgm_id
1275: and epo.pl_id = l_env.pl_id
1276: and epo.business_group_id = l_env.business_group_id
1277: and nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date)

Line 1297: , ben_per_in_ler pil

1293: ben_plip_f cpp,
1294: ben_pl_regn_f prg,
1295: ben_regn_f reg,
1296: ben_elig_per_f epo
1297: , ben_per_in_ler pil
1298: where pln.pl_id = cpp.pl_id
1299: and pln.business_group_id = l_env.business_group_id
1300: and nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date)
1301: between pln.effective_start_date