APPS.HRI_OPL_BEN_DIM_REFRESH dependencies on BEN_PLIP_F

Line 150: FROM ben_plip_f cpp, ben_pl_f pln, hri_cs_co_pgmh_ptip_ct ctpd

146: --
147: CURSOR c_plip IS
148: SELECT cpp.plip_id plip_id, cpp.pl_id pl_id, cpp.pgm_id pgm_id,
149: ctpd.ptip_id ptip_id, ctpd.pl_typ_id pl_typ_id, cpp.ordr_num plip_ordr_num
150: FROM ben_plip_f cpp, ben_pl_f pln, hri_cs_co_pgmh_ptip_ct ctpd
151: WHERE cpp.pl_id = pln.pl_id
152: AND pln.pl_typ_id = ctpd.pl_typ_id
153: AND cpp.pgm_id = ctpd.pgm_id
154: AND pln.invk_flx_cr_pl_flag = 'N'

Line 167: FROM ben_plip_f cpp, ben_pl_f pln, hri_cs_co_pgmh_ptip_ct ctpd

163: --
164: CURSOR c_plip_ernt_pl IS
165: SELECT cpp.plip_id plip_id, cpp.pl_id pl_id, cpp.pgm_id pgm_id,
166: ctpd.ptip_id ptip_id, ctpd.pl_typ_id pl_typ_id
167: FROM ben_plip_f cpp, ben_pl_f pln, hri_cs_co_pgmh_ptip_ct ctpd
168: WHERE cpp.pl_id = pln.pl_id
169: AND pln.pl_typ_id = ctpd.pl_typ_id
170: AND cpp.pgm_id = ctpd.pgm_id
171: AND ( pln.enrt_pl_opt_flag = 'Y'

Line 239: ben_plip_f cpp,

235: IS
236: SELECT enp.enrt_perd_id, enpd.pgm_id, enp.strt_dt, enp.end_dt,
237: enp.asnd_lf_evt_dt ASND_LF_EVT_DT
238: FROM hri_cs_time_benrl_prd_ct enpd,
239: ben_plip_f cpp,
240: ben_popl_enrt_typ_cycl_f pet,
241: ben_enrt_perd enp
242: WHERE enpd.pgm_id = cpp.pgm_id
243: AND pet.pl_id = cpp.pl_id

Line 547: FROM ben_plip_f cpp

543: -- Plan In Program Dimension
544: --
545: DELETE FROM HRI_CS_CO_PGMH_PLIP_CT cppd
546: WHERE NOT EXISTS (SELECT 'x'
547: FROM ben_plip_f cpp
548: WHERE cpp.plip_id = cppd.plip_id);
549: --
550: -- Option In Plan In Program Dimension
551: --

Line 658: FROM ben_plip_f cpp, ben_pl_f pln, hri_cs_co_pgmh_ptip_ct ctpd

654: CURSOR c_plip
655: IS
656: SELECT cpp.plip_id plip_id, cpp.pl_id pl_id, cpp.pgm_id pgm_id,
657: ctpd.ptip_id ptip_id, ctpd.pl_typ_id pl_typ_id, cpp.ordr_num plip_ordr_num
658: FROM ben_plip_f cpp, ben_pl_f pln, hri_cs_co_pgmh_ptip_ct ctpd
659: WHERE cpp.pl_id = pln.pl_id
660: AND pln.pl_typ_id = ctpd.pl_typ_id
661: AND cpp.pgm_id = ctpd.pgm_id
662: AND pln.invk_flx_cr_pl_flag = 'N'

Line 674: FROM ben_plip_f cpp, ben_pl_f pln, hri_cs_co_pgmh_ptip_ct ctpd

670: CURSOR c_plip_ernt_pl
671: IS
672: SELECT cpp.plip_id plip_id, cpp.pl_id pl_id, cpp.pgm_id pgm_id,
673: ctpd.ptip_id ptip_id, ctpd.pl_typ_id pl_typ_id
674: FROM ben_plip_f cpp, ben_pl_f pln, hri_cs_co_pgmh_ptip_ct ctpd
675: WHERE cpp.pl_id = pln.pl_id
676: AND pln.pl_typ_id = ctpd.pl_typ_id
677: AND cpp.pgm_id = ctpd.pgm_id
678: AND ( pln.enrt_pl_opt_flag = 'Y'

Line 732: ben_plip_f cpp,

728: IS
729: SELECT enp.enrt_perd_id, enpd.pgm_id, enp.strt_dt, enp.end_dt,
730: enp.asnd_lf_evt_dt ASND_LF_EVT_DT
731: FROM hri_cs_time_benrl_prd_ct enpd,
732: ben_plip_f cpp,
733: ben_popl_enrt_typ_cycl_f pet,
734: ben_enrt_perd enp
735: WHERE enpd.pgm_id = cpp.pgm_id
736: AND pet.pl_id = cpp.pl_id