APPS.BEN_COMP_OBJECT_LIST dependencies on BEN_PLIP_F

Line 1024: l_plip ben_plip_f%ROWTYPE;

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;
1024: l_plip ben_plip_f%ROWTYPE;
1025: l_ptip ben_ptip_f%ROWTYPE;
1026: l_opt ben_opt_f%ROWTYPE;
1027: l_oiplip ben_oiplip_f%ROWTYPE;
1028: l_epa ben_prtn_elig_f%ROWTYPE;

Line 1116: FROM ben_plip_f cpp

1112: user. (PLIP)*/
1113: AND (
1114: EXISTS
1115: (SELECT NULL
1116: FROM ben_plip_f cpp
1117: WHERE cpp.pgm_id = pgm.pgm_id
1118: AND cpp.pl_id = NVL(p_pl_id, cpp.pl_id)
1119: AND cpp.business_group_id = pgm.business_group_id
1120: AND cpp.plip_stat_cd = 'A'

Line 1463: FROM ben_plip_f cpp

1459: (p_mode not in ('W','M', 'P','D') and ptp.opt_typ_cd not in ('CWB','ABS', 'PERACT','ICM')) -- ICM
1460: )
1461: AND ptp.opt_typ_cd <> 'GDRLDR'
1462: AND NOT EXISTS(SELECT NULL
1463: FROM ben_plip_f cpp
1464: WHERE cpp.pl_id = pln.pl_id)
1465: /* We only want to report on these plans when pgm_id is null */
1466: AND p_pgm_id IS NULL
1467: AND pln.pl_id = NVL(p_pl_id, pln.pl_id)

Line 1588: ben_plip_f plp,

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,
1589: ben_ptip_f ctp
1590: WHERE pln.business_group_id = p_business_group_id
1591: AND pln.pl_id = plp.pl_id
1592: AND p_effective_date BETWEEN pln.effective_start_date

Line 1662: FROM ben_plip_f cpp

1658: ORDER BY cop.ordr_num;
1659: --
1660: CURSOR c_plip IS
1661: SELECT cpp.*
1662: FROM ben_plip_f cpp
1663: WHERE cpp.business_group_id = p_business_group_id
1664: AND cpp.pl_id = l_pl_id
1665: AND cpp.pgm_id = l_pgm_id
1666: AND cpp.plip_stat_cd = 'A'

Line 1925: l_tabname_set(2) := 'ben_plip_f';

1921: -- - Check comp object level changes
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';

Line 2941: FROM ben_plip_f cpp

2937: AND p_effective_date BETWEEN pln.effective_start_date AND pln.effective_end_date;
2938: --
2939: CURSOR c_plip (cv_plip_id number) IS
2940: SELECT cpp.drvbl_fctr_prtn_elig_flag, cpp.drvbl_fctr_apls_rts_flag, cpp.trk_inelig_per_flag
2941: FROM ben_plip_f cpp
2942: WHERE cpp.plip_id = cv_plip_id
2943: AND cpp.plip_stat_cd = 'A'
2944: AND p_effective_date BETWEEN cpp.effective_start_date AND cpp.effective_end_date;
2945: --