APPS.BEN_IREC_PROCESS dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 58: FROM ben_enrt_bnft enb, ben_elig_per_elctbl_chc epe

54: SELECT enb.enrt_bnft_id, enb.entr_val_at_enrt_flag, enb.dflt_val,
55: enb.val, enb.dflt_flag, enb.object_version_number,
56: enb.prtt_enrt_rslt_id, enb.cvg_mlt_cd, epe.pl_id, epe.pgm_id,
57: epe.oipl_id, enb.ordr_num
58: FROM ben_enrt_bnft enb, ben_elig_per_elctbl_chc epe
59: WHERE enb.elig_per_elctbl_chc_id = epe.elig_per_elctbl_chc_id
60: AND epe.per_in_ler_id = cp_per_in_ler_id;
61:
62: --

Line 75: FROM ben_enrt_bnft enb, ben_elig_per_elctbl_chc epe

71: SELECT enb.enrt_bnft_id, enb.entr_val_at_enrt_flag, enb.dflt_val,
72: enb.val, enb.dflt_flag, enb.object_version_number,
73: enb.prtt_enrt_rslt_id, enb.cvg_mlt_cd, epe.pl_id, epe.pgm_id,
74: epe.oipl_id, enb.ordr_num
75: FROM ben_enrt_bnft enb, ben_elig_per_elctbl_chc epe
76: WHERE enb.elig_per_elctbl_chc_id = epe.elig_per_elctbl_chc_id
77: AND epe.per_in_ler_id = cp_irec_per_in_ler_id
78: AND NVL (epe.pgm_id, -1) = NVL (cp_pgm_id, -1)
79: AND NVL (epe.pl_id, -1) = NVL (cp_pl_id, -1)

Line 97: FROM ben_enrt_rt ecr, ben_elig_per_elctbl_chc epe

93: IS
94: SELECT ecr.enrt_rt_id, ecr.dflt_val, ecr.val,
95: ecr.entr_val_at_enrt_flag, epe.pl_id, epe.pgm_id, epe.oipl_id,
96: ecr.acty_base_rt_id, ecr.ann_val
97: FROM ben_enrt_rt ecr, ben_elig_per_elctbl_chc epe
98: WHERE epe.per_in_ler_id = cp_bckdt_per_in_ler_id
99: AND ecr.elig_per_elctbl_chc_id = epe.elig_per_elctbl_chc_id
100: AND ecr.entr_val_at_enrt_flag = 'Y'
101: AND ecr.spcl_rt_enrt_rt_id IS NULL

Line 107: ben_elig_per_elctbl_chc epe,

103: SELECT ecr.enrt_rt_id, ecr.dflt_val, ecr.val,
104: ecr.entr_val_at_enrt_flag, epe.pl_id, epe.pgm_id, epe.oipl_id,
105: ecr.acty_base_rt_id, ecr.ann_val
106: FROM ben_enrt_rt ecr,
107: ben_elig_per_elctbl_chc epe,
108: ben_enrt_bnft enb
109: WHERE ecr.enrt_bnft_id = enb.enrt_bnft_id
110: AND epe.per_in_ler_id = cp_bckdt_per_in_ler_id
111: AND enb.elig_per_elctbl_chc_id = epe.elig_per_elctbl_chc_id

Line 128: FROM ben_enrt_rt ecr, ben_elig_per_elctbl_chc epe

124: IS
125: SELECT ecr.enrt_rt_id, ecr.dflt_val, ecr.val,
126: ecr.entr_val_at_enrt_flag, ecr.acty_base_rt_id, ecr.ann_val,
127: ecr.object_version_number, ecr.entr_ann_val_flag
128: FROM ben_enrt_rt ecr, ben_elig_per_elctbl_chc epe
129: WHERE epe.per_in_ler_id = cp_irec_per_in_ler_id
130: AND ecr.elig_per_elctbl_chc_id = epe.elig_per_elctbl_chc_id
131: AND ecr.entr_val_at_enrt_flag = 'Y'
132: AND ecr.spcl_rt_enrt_rt_id IS NULL

Line 142: ben_elig_per_elctbl_chc epe,

138: SELECT ecr.enrt_rt_id, ecr.dflt_val, ecr.val,
139: ecr.entr_val_at_enrt_flag, ecr.acty_base_rt_id, ecr.ann_val,
140: ecr.object_version_number, ecr.entr_ann_val_flag
141: FROM ben_enrt_rt ecr,
142: ben_elig_per_elctbl_chc epe,
143: ben_enrt_bnft enb
144: WHERE ecr.enrt_bnft_id = enb.enrt_bnft_id
145: AND epe.per_in_ler_id = cp_irec_per_in_ler_id
146: AND enb.elig_per_elctbl_chc_id = epe.elig_per_elctbl_chc_id

Line 328: FROM ben_elig_per_elctbl_chc irec_epe

324: --
325: CURSOR c_elig_per_electbl (p_irec_per_in_ler_id NUMBER)
326: IS
327: SELECT *
328: FROM ben_elig_per_elctbl_chc irec_epe
329: WHERE irec_epe.per_in_ler_id = p_irec_per_in_ler_id
330: AND irec_epe.approval_status_cd = 'IRC_BEN_A'; -- Bug 6079424
331: --
332: CURSOR c_unrstr_epe (

Line 340: FROM ben_elig_per_elctbl_chc irec_epe

336: p_oipl_id NUMBER
337: )
338: IS
339: SELECT *
340: FROM ben_elig_per_elctbl_chc irec_epe
341: WHERE per_in_ler_id = p_unrstr_per_in_ler_id
342: AND NVL (pgm_id, -1) = NVL (p_pgm_id, -1)
343: AND pl_id = p_pl_id
344: AND NVL (oipl_id, -1) = NVL (p_oipl_id, -1);