APPS.BEN_PRTT_ENRT_RESULT_API dependencies on BEN_ENRT_BNFT

Line 505: make sure the ben_enrt_prem record refers to the correct ben_enrt_bnft_f

501: instead of a fixed format-mask.
502: 115.217 07=Apr-04 tjesumic FONM changes added
503: 115.218 19-apr-04 bmanyam Bug# 3573173 : In c_prem cursor, added
504: condition NVL(ecr.enrt_bnft_id, -1) = NVL(p_enrt_bnft_id, -1) to
505: make sure the ben_enrt_prem record refers to the correct ben_enrt_bnft_f
506: record while creating ben_prtt_prem.
507: 115.219 21-Apr-04 kmahendr Bug#3568529 - ben_env_object.init is called only if the
508: object was not initialised.
509: 115.220 04-May-04 bmanyam Bug: 3574168 - In void_enrollment, delete_enrollment and

Line 5765: ,ben_enrt_bnft enb

5761: ,enb.enrt_bnft_id
5762: from ben_prtt_enrt_rslt_f pen
5763: ,ben_elig_per_elctbl_chc epe
5764: ,ben_per_in_ler pil
5765: ,ben_enrt_bnft enb
5766: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5767: and pen.prtt_enrt_rslt_id = epe.prtt_enrt_rslt_id (+)
5768: and nvl(epe.elig_per_elctbl_chc_id, -1) = enb.elig_per_elctbl_chc_id (+)
5769: and pen.business_group_id = p_business_group_id

Line 5809: ,ben_enrt_bnft enb

5805: ,epe.object_version_number epe_ovn
5806: ,enb.enrt_bnft_id
5807: from ben_elig_per_elctbl_chc epe
5808: ,ben_per_in_ler pil
5809: ,ben_enrt_bnft enb
5810: where epe.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5811: and nvl(epe.elig_per_elctbl_chc_id, -1) = enb.elig_per_elctbl_chc_id (+)
5812: and pil.per_in_ler_id=epe.per_in_ler_id
5813: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')

Line 6342: ,ben_enrt_bnft enb

6338: ,pl.imptd_incm_calc_cd
6339: from ben_prtt_enrt_rslt_f pen
6340: ,ben_elig_per_elctbl_chc epe
6341: ,ben_per_in_ler pil
6342: ,ben_enrt_bnft enb
6343: ,ben_oipl_f oipl
6344: ,ben_pl_f pl
6345: ,ben_opt_f opt
6346: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id

Line 7238: from ben_enrt_bnft bnft,

7234: mx_val ,
7235: entr_val_at_enrt_flag,
7236: cvg_mlt_cd,
7237: mx_wout_ctfn_val
7238: from ben_enrt_bnft bnft,
7239: ben_elig_per_elctbl_chc epe,
7240: ben_prtt_enrt_rslt_f pen
7241: where epe.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
7242: and epe.per_in_ler_id = c_per_in_ler_id

Line 7316: ,ben_enrt_bnft enb

7312: ) is
7313: select ecr.*
7314: ,enb.elig_per_elctbl_chc_id enb_per_elctbl_chc_id
7315: from ben_enrt_rt ecr
7316: ,ben_enrt_bnft enb
7317: where ecr.prtt_rt_val_id = p_prtt_rt_val_id
7318: and exists (select null
7319: from ben_prtt_enrt_rslt_f pen
7320: where pen.prtt_enrt_rslt_stat_cd is null

Line 7372: ,ben_enrt_bnft enb

7368: ) is
7369: select ecr.*
7370: ,enb.elig_per_elctbl_chc_id enb_per_elctbl_chc_id
7371: from ben_enrt_rt ecr
7372: ,ben_enrt_bnft enb
7373: where ecr.prtt_rt_val_id = p_prtt_rt_val_id
7374: and exists (select null
7375: from ben_prtt_enrt_rslt_f pen
7376: where pen.prtt_enrt_rslt_stat_cd is null

Line 10355: -- Clear out ben_enrt_bnft table's prtt_enrt_rslt_id

10351: end if;
10352: --
10353: end loop;
10354: --
10355: -- Clear out ben_enrt_bnft table's prtt_enrt_rslt_id
10356: --
10357: l_step := 176;
10358: --
10359: -- Do not call manage_enrt_bnft, if it is called from election_information