APPS.BEN_REINSTATE_EPE_CACHE dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 163: FROM ben_elig_per_elctbl_chc epe

159: ,epe.spcl_rt_oipl_id
160: ,epe.spcl_rt_pl_id
161: ,epe.ws_mgr_id
162: ,epe.yr_perd_id
163: FROM ben_elig_per_elctbl_chc epe
164: WHERE epe.per_in_ler_id = c_per_in_ler_id
165: order by epe.PTIP_ORDR_NUM,
166: epe.PLIP_ORDR_NUM,
167: decode(PL_ORDR_NUM, null, OIPL_ORDR_NUM, PL_ORDR_NUM),

Line 476: FROM ben_elig_per_elctbl_chc epe

472: ,epe.spcl_rt_oipl_id
473: ,epe.spcl_rt_pl_id
474: ,epe.ws_mgr_id
475: ,epe.yr_perd_id
476: FROM ben_elig_per_elctbl_chc epe
477: WHERE epe.per_in_ler_id = c_per_in_ler_id
478: order by epe.PTIP_ORDR_NUM,
479: epe.PLIP_ORDR_NUM,
480: decode(epe.PL_ORDR_NUM, null, epe.OIPL_ORDR_NUM, epe.PL_ORDR_NUM),

Line 751: FROM ben_elig_per_elctbl_chc epe

747: ,c_oipl_id number
748: )
749: is
750: SELECT epe.elig_per_elctbl_chc_id
751: FROM ben_elig_per_elctbl_chc epe
752: WHERE epe.oipl_id = c_oipl_id
753: AND epe.pgm_id = c_pgm_id
754: AND epe.per_in_ler_id = c_per_in_ler_id;
755: --

Line 762: FROM ben_elig_per_elctbl_chc epe

758: ,c_oipl_id number
759: )
760: is
761: SELECT epe.elig_per_elctbl_chc_id
762: FROM ben_elig_per_elctbl_chc epe
763: WHERE epe.oipl_id = c_oipl_id
764: AND epe.pgm_id IS NULL
765: AND epe.per_in_ler_id = c_per_in_ler_id;
766: --

Line 774: FROM ben_elig_per_elctbl_chc epe

770: ,c_pl_id number
771: )
772: is
773: SELECT epe.elig_per_elctbl_chc_id
774: FROM ben_elig_per_elctbl_chc epe
775: WHERE epe.pl_id = c_pl_id
776: AND epe.oipl_id IS NULL
777: AND epe.pgm_id = c_pgm_id
778: AND epe.per_in_ler_id = c_per_in_ler_id;

Line 786: FROM ben_elig_per_elctbl_chc epe

782: ,c_pl_id number
783: )
784: is
785: SELECT epe.elig_per_elctbl_chc_id
786: FROM ben_elig_per_elctbl_chc epe
787: WHERE epe.pl_id = c_pl_id
788: AND epe.oipl_id IS NULL
789: AND epe.pgm_id IS NULL
790: AND epe.per_in_ler_id = c_per_in_ler_id;