APPS.BEN_COMP_OBJECT_LIST dependencies on BEN_POPL_ENRT_TYP_CYCL_F

Line 1341: FROM ben_popl_enrt_typ_cycl_f pet,

1337: enrollment type cycle that has been specified by the user. */
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

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 1947: l_tabname_set(16) := 'ben_popl_enrt_typ_cycl_f'; --

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';
1951: l_tabname_set(19) := 'ben_acty_base_rt_f';