APPS.HRI_OPL_BEN_DIM_REFRESH dependencies on BEN_PL_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 565: FROM ben_pl_f pln

561: WHERE oppd.oiplip_id = -1
562: AND oppd.plip_id IS NOT NULL
563: AND ( NOT EXISTS (
564: SELECT 'x'
565: FROM ben_pl_f pln
566: WHERE pln.pl_id = oppd.pl_id
567: AND l_effective_date BETWEEN pln.effective_start_date
568: AND pln.effective_end_date)
569: OR EXISTS (

Line 571: FROM ben_oipl_f cop, ben_pl_f pln

567: AND l_effective_date BETWEEN pln.effective_start_date
568: AND pln.effective_end_date)
569: OR EXISTS (
570: SELECT 'x'
571: FROM ben_oipl_f cop, ben_pl_f pln
572: WHERE cop.pl_id = oppd.pl_id
573: AND cop.pl_id = pln.pl_id
574: AND l_effective_date BETWEEN pln.effective_start_date
575: AND pln.effective_end_date

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'