APPS.BEN_COMP_OBJECT_LIST dependencies on BEN_ENRT_PERD

Line 1342: ben_enrt_perd enp

1338: AND (
1339: EXISTS
1340: (SELECT NULL
1341: FROM ben_popl_enrt_typ_cycl_f pet,
1342: ben_enrt_perd enp
1343: WHERE pet.pgm_id = pgm.pgm_id
1344: AND p_effective_date BETWEEN pet.effective_start_date
1345: AND pet.effective_end_date
1346: AND pet.popl_enrt_typ_cycl_id =

Line 1351: FROM ben_enrt_perd enp1

1347: enp.popl_enrt_typ_cycl_id
1348: AND enp.asnd_lf_evt_dt = p_asnd_lf_evt_dt
1349: /* PB : 5422 AND enp.strt_dt =
1350: (SELECT enp1.strt_dt
1351: FROM ben_enrt_perd enp1
1352: WHERE enp1.enrt_perd_id =
1353: p_popl_enrt_typ_cycl_id) */
1354: AND enp.business_group_id = pet.business_group_id)
1355: OR p_asnd_lf_evt_dt IS NULL)

Line 1548: FROM ben_popl_enrt_typ_cycl_f pet, ben_enrt_perd enp

1544: OR p_eligy_prfl_id IS NULL)
1545: AND (
1546: EXISTS
1547: (SELECT NULL
1548: FROM ben_popl_enrt_typ_cycl_f pet, ben_enrt_perd enp
1549: WHERE pet.pl_id = pln.pl_id
1550: AND p_effective_date BETWEEN pet.effective_start_date
1551: AND pet.effective_end_date
1552: AND pet.popl_enrt_typ_cycl_id =

Line 1945: l_tabname_set(14) := 'ben_enrt_perd_for_pl_f';

1941: l_tabname_set(11) := 'ben_yr_perd';
1942: l_tabname_set(12) := 'ben_rptg_grp';
1943: l_tabname_set(13) := 'ben_popl_rptg_grp';
1944: --
1945: l_tabname_set(14) := 'ben_enrt_perd_for_pl_f';
1946: l_tabname_set(15) := 'ben_enrt_perd';
1947: l_tabname_set(16) := 'ben_popl_enrt_typ_cycl_f'; --
1948: --
1949: l_tabname_set(17) := 'ben_vrbl_rt_prfl_f';

Line 1946: l_tabname_set(15) := 'ben_enrt_perd';

1942: l_tabname_set(12) := 'ben_rptg_grp';
1943: l_tabname_set(13) := 'ben_popl_rptg_grp';
1944: --
1945: l_tabname_set(14) := 'ben_enrt_perd_for_pl_f';
1946: l_tabname_set(15) := 'ben_enrt_perd';
1947: l_tabname_set(16) := 'ben_popl_enrt_typ_cycl_f'; --
1948: --
1949: l_tabname_set(17) := 'ben_vrbl_rt_prfl_f';
1950: l_tabname_set(18) := 'ben_acty_vrbl_rt_f';