APPS.BEN_COMP_OBJECT_LIST dependencies on BEN_PL_F

Line 1004: l_pl_id ben_pl_f.pl_id%TYPE;

1000: l_plninst_set ben_pln_cache.g_bgppln_cache;
1001: l_copinst_set ben_cop_cache.g_bgpcop_cache;
1002: --
1003: l_oipl_id ben_oipl_f.oipl_id%TYPE;
1004: l_pl_id ben_pl_f.pl_id%TYPE;
1005: l_pgm_id ben_pgm_f.pgm_id%TYPE;
1006: l_pgm pgm_rec;
1007: l_pln ben_pln_cache.g_bgppln_rec;
1008: l_cop ben_cop_cache.g_bgpcop_rec;

Line 1409: FROM ben_pl_f pln,

1405: ptp.opt_typ_cd,
1406: pln.drvbl_fctr_prtn_elig_flag,
1407: pln.drvbl_fctr_apls_rts_flag,
1408: pln.trk_inelig_per_flag
1409: FROM ben_pl_f pln,
1410: ben_pl_typ_f ptp
1411: -- ben_yr_perd yrp,
1412: -- ben_popl_yr_perd cpy
1413: WHERE pln.business_group_id = p_business_group_id

Line 1569: FROM ben_pl_f pln,

1565: ptp.opt_typ_cd,
1566: pln.drvbl_fctr_prtn_elig_flag,
1567: pln.drvbl_fctr_apls_rts_flag,
1568: pln.trk_inelig_per_flag
1569: FROM ben_pl_f pln,
1570: ben_pl_typ_f ptp,
1571: -- ben_popl_yr_perd cpy,
1572: -- ben_yr_perd yrp,
1573: ben_plip_f plp,

Line 1619: ,ben_pl_f pln

1615: FROM ben_oipl_f cop
1616: ,ben_opt_f opt
1617: -- ,ben_popl_yr_perd cpy
1618: -- ,ben_yr_perd yrp
1619: ,ben_pl_f pln
1620: WHERE cop.business_group_id = p_business_group_id
1621: AND p_effective_date BETWEEN cop.effective_start_date
1622: AND cop.effective_end_date
1623: AND cop.pl_id = pln.pl_id

Line 1730: from ben_pl_f

1726: l_unres_cache_only varchar2(1) ;
1727: -- # 3330283
1728: cursor c_unres_cache_plnip_only IS
1729: select distinct alws_unrstrctd_enrt_flag
1730: from ben_pl_f
1731: where pl_id in ( SELECT distinct bcocr.pl_id
1732: FROM ben_comp_obj_cache_row bcocr
1733: WHERE bcocr.comp_obj_cache_id = l_comp_obj_cache_id
1734: and bcocr.pl_nip = 'Y' )

Line 1908: l_tabname_set(3) := 'ben_pl_f';

1904: --
1905: l_tabname_set(0) := 'ben_pgm_f';
1906: l_tabname_set(1) := 'ben_ptip_f';
1907: l_tabname_set(2) := 'ben_plip_f';
1908: l_tabname_set(3) := 'ben_pl_f';
1909: l_tabname_set(4) := 'ben_opt_f';
1910: l_tabname_set(5) := 'ben_oipl_f';
1911: l_tabname_set(6) := 'ben_oiplip_f';
1912: --

Line 2914: FROM ben_pl_f pln

2910: AND p_effective_date BETWEEN ctp.effective_start_date AND ctp.effective_end_date;
2911: --
2912: CURSOR c_pln (cv_pl_id number) IS
2913: SELECT pln.drvbl_fctr_prtn_elig_flag, pln.drvbl_fctr_apls_rts_flag, pln.trk_inelig_per_flag
2914: FROM ben_pl_f pln
2915: WHERE pln.pl_id = cv_pl_id
2916: AND pln.pl_stat_cd = 'A'
2917: AND p_effective_date BETWEEN pln.effective_start_date AND pln.effective_end_date;
2918: --