APPS.HRI_OPL_BEN_DIM_REFRESH dependencies on BEN_OIPLIP_F

Line 194: FROM ben_oiplip_f opp, ben_oipl_f cop, hri_cs_co_pgmh_plip_ct cppd

190: CURSOR c_oiplip IS
191: SELECT opp.oiplip_id oiplip_id, opp.oipl_id oipl_id, cop.opt_id opt_id,
192: opp.plip_id plip_id, cppd.pl_typ_id pl_typ_id,
193: cppd.ptip_id ptip_id, cppd.pl_id pl_id, cppd.pgm_id pgm_id, cop.ordr_num oipl_ordr_num
194: FROM ben_oiplip_f opp, ben_oipl_f cop, hri_cs_co_pgmh_plip_ct cppd
195: WHERE opp.plip_id = cppd.plip_id
196: AND cop.oipl_id = opp.oipl_id
197: AND l_effective_date BETWEEN opp.effective_start_date
198: AND opp.effective_end_date

Line 555: FROM ben_oiplip_f opp

551: --
552: DELETE FROM HRI_CS_COMPOBJ_CT oppd
553: WHERE oppd.oiplip_id <> -1
554: AND NOT EXISTS (SELECT 'x'
555: FROM ben_oiplip_f opp
556: WHERE opp.oiplip_id = oppd.oiplip_id);
557: --
558: -- Plan In Program Dimension (Enrol In Plan And Option - Checked)
559: --

Line 698: FROM ben_oiplip_f opp, ben_oipl_f cop, hri_cs_co_pgmh_plip_ct cppd

694: IS
695: SELECT opp.oiplip_id oiplip_id, opp.oipl_id oipl_id, cop.opt_id opt_id,
696: opp.plip_id plip_id, cppd.pl_typ_id pl_typ_id,
697: cppd.ptip_id ptip_id, cppd.pl_id pl_id, cppd.pgm_id pgm_id, cop.ordr_num oipl_ordr_num
698: FROM ben_oiplip_f opp, ben_oipl_f cop, hri_cs_co_pgmh_plip_ct cppd
699: WHERE opp.plip_id = cppd.plip_id
700: AND cop.oipl_id = opp.oipl_id
701: AND l_effective_date BETWEEN opp.effective_start_date
702: AND opp.effective_end_date