APPS.BEN_COMP_OBJECT_LIST dependencies on BEN_PLIP_F

Line 1009: l_plip ben_plip_f%ROWTYPE;

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;
1009: l_plip ben_plip_f%ROWTYPE;
1010: l_ptip ben_ptip_f%ROWTYPE;
1011: l_opt ben_opt_f%ROWTYPE;
1012: l_oiplip ben_oiplip_f%ROWTYPE;
1013: l_epa ben_prtn_elig_f%ROWTYPE;

Line 1101: FROM ben_plip_f cpp

1097: user. (PLIP)*/
1098: AND (
1099: EXISTS
1100: (SELECT NULL
1101: FROM ben_plip_f cpp
1102: WHERE cpp.pgm_id = pgm.pgm_id
1103: AND cpp.pl_id = NVL(p_pl_id, cpp.pl_id)
1104: AND cpp.business_group_id = pgm.business_group_id
1105: AND cpp.plip_stat_cd = 'A'

Line 1448: FROM ben_plip_f cpp

1444: (p_mode not in ('W','M', 'P','D') and ptp.opt_typ_cd not in ('CWB','ABS', 'PERACT','ICM')) -- ICM
1445: )
1446: AND ptp.opt_typ_cd <> 'GDRLDR'
1447: AND NOT EXISTS(SELECT NULL
1448: FROM ben_plip_f cpp
1449: WHERE cpp.pl_id = pln.pl_id)
1450: /* We only want to report on these plans when pgm_id is null */
1451: AND p_pgm_id IS NULL
1452: AND pln.pl_id = NVL(p_pl_id, pln.pl_id)

Line 1573: ben_plip_f plp,

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,
1574: ben_ptip_f ctp
1575: WHERE pln.business_group_id = p_business_group_id
1576: AND pln.pl_id = plp.pl_id
1577: AND p_effective_date BETWEEN pln.effective_start_date

Line 1647: FROM ben_plip_f cpp

1643: ORDER BY cop.ordr_num;
1644: --
1645: CURSOR c_plip IS
1646: SELECT cpp.*
1647: FROM ben_plip_f cpp
1648: WHERE cpp.business_group_id = p_business_group_id
1649: AND cpp.pl_id = l_pl_id
1650: AND cpp.pgm_id = l_pgm_id
1651: AND cpp.plip_stat_cd = 'A'

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

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

Line 2921: FROM ben_plip_f cpp

2917: AND p_effective_date BETWEEN pln.effective_start_date AND pln.effective_end_date;
2918: --
2919: CURSOR c_plip (cv_plip_id number) IS
2920: SELECT cpp.drvbl_fctr_prtn_elig_flag, cpp.drvbl_fctr_apls_rts_flag, cpp.trk_inelig_per_flag
2921: FROM ben_plip_f cpp
2922: WHERE cpp.plip_id = cv_plip_id
2923: AND cpp.plip_stat_cd = 'A'
2924: AND p_effective_date BETWEEN cpp.effective_start_date AND cpp.effective_end_date;
2925: --