[Home] [Help]
11363: --
11364: cursor c_prtt_total_bnft_amt(p_acrs_ptip_cvg_id number) is
11365: select sum(prt.bnft_amt)
11366: from ben_prtt_enrt_rslt_f prt,
11367: ben_ptip_f ptp
11368: where prt.pgm_id = p_pgm_id
11369: and prt.person_id = p_person_id
11370: and prt.sspndd_flag = 'N' -- # 3626176
11371: and prt.prtt_enrt_rslt_stat_cd is null
11387: --
11388: cursor c_prtt_total_bnft_amt_sspndd(p_acrs_ptip_cvg_id number) is
11389: select sum(prt.bnft_amt)
11390: from ben_prtt_enrt_rslt_f prt,
11391: ben_ptip_f ptp
11392: where prt.pgm_id = p_pgm_id
11393: and prt.person_id = p_person_id
11394: and ( prt.sspndd_flag = 'Y' or (
11395: prt.sspndd_flag = 'N' and not exists (
11422: select name
11423: from ben_pl_typ_f
11424: where pl_typ_id in
11425: ( select pl_typ_id
11426: from ben_ptip_f
11427: where pgm_id = p_pgm_id
11428: and acrs_ptip_cvg_id = p_acrs_ptip_cvg_id
11429: and business_group_id = p_business_group_id)
11430: and p_lf_evt_ocrd_dt between
11817: select name
11818: from ben_pl_typ_f
11819: where pl_typ_id in
11820: ( select pl_typ_id
11821: from ben_ptip_f
11822: where pgm_id = p_pgm_id
11823: and acrs_ptip_cvg_id = p_acrs_ptip_cvg_id
11824: and business_group_id = p_business_group_id)
11825: and l_lf_evt_ocrd_dt between
11831: --
11832: cursor c_prtt_total_bnft_amt(p_acrs_ptip_cvg_id number) is
11833: select sum(prt.bnft_amt)
11834: from ben_prtt_enrt_rslt_f prt,
11835: ben_ptip_f ptp
11836: where prt.pgm_id = p_pgm_id
11837: and prt.person_id = p_person_id
11838: and prt.sspndd_flag = 'N' -- # 3626176
11839: and prt.prtt_enrt_rslt_stat_cd is null
11855: --
11856: cursor c_prtt_total_bnft_amt_sspndd(p_acrs_ptip_cvg_id number) is
11857: select sum(prt.bnft_amt)
11858: from ben_prtt_enrt_rslt_f prt,
11859: ben_ptip_f ptp
11860: where prt.pgm_id = p_pgm_id
11861: and prt.person_id = p_person_id
11862: and ( prt.sspndd_flag = 'Y' or (
11863: prt.sspndd_flag = 'N' and not exists (