APPS.BEN_COMP_OBJECT_LIST dependencies on BEN_PL_F

Line 1019: l_pl_id ben_pl_f.pl_id%TYPE;

1015: l_plninst_set ben_pln_cache.g_bgppln_cache;
1016: l_copinst_set ben_cop_cache.g_bgpcop_cache;
1017: --
1018: l_oipl_id ben_oipl_f.oipl_id%TYPE;
1019: l_pl_id ben_pl_f.pl_id%TYPE;
1020: l_pgm_id ben_pgm_f.pgm_id%TYPE;
1021: l_pgm pgm_rec;
1022: l_pln ben_pln_cache.g_bgppln_rec;
1023: l_cop ben_cop_cache.g_bgpcop_rec;

Line 1424: FROM ben_pl_f pln,

1420: ptp.opt_typ_cd,
1421: pln.drvbl_fctr_prtn_elig_flag,
1422: pln.drvbl_fctr_apls_rts_flag,
1423: pln.trk_inelig_per_flag
1424: FROM ben_pl_f pln,
1425: ben_pl_typ_f ptp
1426: -- ben_yr_perd yrp,
1427: -- ben_popl_yr_perd cpy
1428: WHERE pln.business_group_id = p_business_group_id

Line 1584: FROM ben_pl_f pln,

1580: ptp.opt_typ_cd,
1581: pln.drvbl_fctr_prtn_elig_flag,
1582: pln.drvbl_fctr_apls_rts_flag,
1583: pln.trk_inelig_per_flag
1584: FROM ben_pl_f pln,
1585: ben_pl_typ_f ptp,
1586: -- ben_popl_yr_perd cpy,
1587: -- ben_yr_perd yrp,
1588: ben_plip_f plp,

Line 1634: ,ben_pl_f pln

1630: FROM ben_oipl_f cop
1631: ,ben_opt_f opt
1632: -- ,ben_popl_yr_perd cpy
1633: -- ,ben_yr_perd yrp
1634: ,ben_pl_f pln
1635: WHERE cop.business_group_id = p_business_group_id
1636: AND p_effective_date BETWEEN cop.effective_start_date
1637: AND cop.effective_end_date
1638: AND cop.pl_id = pln.pl_id

Line 1747: from ben_pl_f

1743: l_unres_cache_only varchar2(1) ;
1744: -- # 3330283
1745: cursor c_unres_cache_plnip_only IS
1746: select distinct alws_unrstrctd_enrt_flag
1747: from ben_pl_f
1748: where pl_id in ( SELECT distinct bcocr.pl_id
1749: FROM ben_comp_obj_cache_row bcocr
1750: WHERE bcocr.comp_obj_cache_id = l_comp_obj_cache_id
1751: and bcocr.pl_nip = 'Y' )

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

1922: --
1923: l_tabname_set(0) := 'ben_pgm_f';
1924: l_tabname_set(1) := 'ben_ptip_f';
1925: l_tabname_set(2) := 'ben_plip_f';
1926: l_tabname_set(3) := 'ben_pl_f';
1927: l_tabname_set(4) := 'ben_opt_f';
1928: l_tabname_set(5) := 'ben_oipl_f';
1929: l_tabname_set(6) := 'ben_oiplip_f';
1930: --

Line 2934: FROM ben_pl_f pln

2930: AND p_effective_date BETWEEN ctp.effective_start_date AND ctp.effective_end_date;
2931: --
2932: CURSOR c_pln (cv_pl_id number) IS
2933: SELECT pln.drvbl_fctr_prtn_elig_flag, pln.drvbl_fctr_apls_rts_flag, pln.trk_inelig_per_flag
2934: FROM ben_pl_f pln
2935: WHERE pln.pl_id = cv_pl_id
2936: AND pln.pl_stat_cd = 'A'
2937: AND p_effective_date BETWEEN pln.effective_start_date AND pln.effective_end_date;
2938: --