APPS.BEN_IREC_PROCESS dependencies on BEN_ENRT_BNFT

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 108: ben_enrt_bnft enb

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
112: AND ecr.entr_val_at_enrt_flag = 'Y'

Line 143: ben_enrt_bnft enb

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
147: AND ecr.entr_val_at_enrt_flag = 'Y'

Line 242: ben_enrt_bnft_api.update_enrt_bnft

238: )
239: AND l_active_bnft_rec.val <> l_bckdt_bnft_rec.val
240: THEN
241: --
242: ben_enrt_bnft_api.update_enrt_bnft
243: (p_enrt_bnft_id => l_active_bnft_rec.enrt_bnft_id,
244: p_val => l_bckdt_bnft_rec.val,
245: p_object_version_number => l_active_bnft_rec.object_version_number,
246: p_effective_date => p_effective_date

Line 351: FROM ben_enrt_bnft enb

347: --
348: CURSOR c_dflt_enb (p_elig_per_elctbl_chc_id NUMBER)
349: IS
350: SELECT enb.*
351: FROM ben_enrt_bnft enb
352: WHERE enb.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id;
353: --
354: l_dflt_enb c_dflt_enb%ROWTYPE;
355: l_unres_dflt_enb c_dflt_enb%ROWTYPE;