APPS.BEN_PRTT_ENRT_RESULT_API dependencies on BEN_ENRT_PREM

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 1639: from ben_enrt_prem ecr,

1635: ecr.uom,
1636: ecr.actl_prem_id,
1637: pil.lf_evt_ocrd_dt,
1638: pil.ler_id
1639: from ben_enrt_prem ecr,
1640: ben_per_in_ler pil,
1641: ben_elig_per_elctbl_chc epe
1642: where ecr.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
1643: and epe.elig_per_elctbl_chc_id = ecr.elig_per_elctbl_chc_id

Line 3033: from ben_enrt_prem ecr,

3029: ecr.actl_prem_id,
3030: pil.lf_evt_ocrd_dt,
3031: pil.ler_id,
3032: epe.elig_per_elctbl_chc_id
3033: from ben_enrt_prem ecr,
3034: ben_per_in_ler pil,
3035: ben_elig_per_elctbl_chc epe
3036: where epe.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3037: and epe.elig_per_elctbl_chc_id = ecr.elig_per_elctbl_chc_id