DBA Data[Home] [Help]

APPS.BEN_COMP_OBJECT_LIST dependencies on BEN_POPL_ENRT_TYP_CYCL_F

Line 1326: FROM ben_popl_enrt_typ_cycl_f pet,

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

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

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