APPS.BEN_COMP_OBJECT_LIST dependencies on BEN_ENRT_PERD

Line 1327: ben_enrt_perd enp

1323: AND (
1324: EXISTS
1325: (SELECT NULL
1326: FROM ben_popl_enrt_typ_cycl_f pet,
1327: ben_enrt_perd enp
1328: WHERE pet.pgm_id = pgm.pgm_id
1329: AND p_effective_date BETWEEN pet.effective_start_date
1330: AND pet.effective_end_date
1331: AND pet.popl_enrt_typ_cycl_id =

Line 1336: FROM ben_enrt_perd enp1

1332: enp.popl_enrt_typ_cycl_id
1333: AND enp.asnd_lf_evt_dt = p_asnd_lf_evt_dt
1334: /* PB : 5422 AND enp.strt_dt =
1335: (SELECT enp1.strt_dt
1336: FROM ben_enrt_perd enp1
1337: WHERE enp1.enrt_perd_id =
1338: p_popl_enrt_typ_cycl_id) */
1339: AND enp.business_group_id = pet.business_group_id)
1340: OR p_asnd_lf_evt_dt IS NULL)

Line 1533: FROM ben_popl_enrt_typ_cycl_f pet, ben_enrt_perd enp

1529: OR p_eligy_prfl_id IS NULL)
1530: AND (
1531: EXISTS
1532: (SELECT NULL
1533: FROM ben_popl_enrt_typ_cycl_f pet, ben_enrt_perd enp
1534: WHERE pet.pl_id = pln.pl_id
1535: AND p_effective_date BETWEEN pet.effective_start_date
1536: AND pet.effective_end_date
1537: AND pet.popl_enrt_typ_cycl_id =

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

1923: l_tabname_set(11) := 'ben_yr_perd';
1924: l_tabname_set(12) := 'ben_rptg_grp';
1925: l_tabname_set(13) := 'ben_popl_rptg_grp';
1926: --
1927: l_tabname_set(14) := 'ben_enrt_perd_for_pl_f';
1928: l_tabname_set(15) := 'ben_enrt_perd';
1929: l_tabname_set(16) := 'ben_popl_enrt_typ_cycl_f'; --
1930: --
1931: l_tabname_set(17) := 'ben_vrbl_rt_prfl_f';

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

1924: l_tabname_set(12) := 'ben_rptg_grp';
1925: l_tabname_set(13) := 'ben_popl_rptg_grp';
1926: --
1927: l_tabname_set(14) := 'ben_enrt_perd_for_pl_f';
1928: l_tabname_set(15) := 'ben_enrt_perd';
1929: l_tabname_set(16) := 'ben_popl_enrt_typ_cycl_f'; --
1930: --
1931: l_tabname_set(17) := 'ben_vrbl_rt_prfl_f';
1932: l_tabname_set(18) := 'ben_acty_vrbl_rt_f';