APPS.BEN_PRTT_ENRT_RESULT_API dependencies on BEN_PTIP_F

Line 6217: ,ben_ptip_f ptip

6213: ,pen.enrt_cvg_strt_dt
6214: ,pen.per_in_ler_id
6215: ,pen.object_version_number
6216: from ben_prtt_enrt_rslt_f pen
6217: ,ben_ptip_f ptip
6218: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id -- 245535
6219: and pen.per_in_ler_id <> p_per_in_ler_id -- basu
6220: and pen.enrt_cvg_thru_dt > p_cvg_end_dt -- '20-jan-2008'
6221: and pen.enrt_cvg_thru_dt <> hr_api.g_eot -- '31-dec-4712'

Line 9769: ben_ptip_f ptp

9765: --
9766: cursor c_prtt_total_bnft_amt(p_acrs_ptip_cvg_id number) is
9767: select sum(prt.bnft_amt)
9768: from ben_prtt_enrt_rslt_f prt,
9769: ben_ptip_f ptp
9770: where prt.pgm_id = p_pgm_id
9771: and prt.person_id = p_person_id
9772: and prt.sspndd_flag = 'N' -- # 3626176
9773: and prt.prtt_enrt_rslt_stat_cd is null

Line 9793: ben_ptip_f ptp

9789: --
9790: cursor c_prtt_total_bnft_amt_sspndd(p_acrs_ptip_cvg_id number) is
9791: select sum(prt.bnft_amt)
9792: from ben_prtt_enrt_rslt_f prt,
9793: ben_ptip_f ptp
9794: where prt.pgm_id = p_pgm_id
9795: and prt.person_id = p_person_id
9796: and ( prt.sspndd_flag = 'Y' or (
9797: prt.sspndd_flag = 'N' and not exists (

Line 9828: from ben_ptip_f

9824: select name
9825: from ben_pl_typ_f
9826: where pl_typ_id in
9827: ( select pl_typ_id
9828: from ben_ptip_f
9829: where pgm_id = p_pgm_id
9830: and acrs_ptip_cvg_id = p_acrs_ptip_cvg_id
9831: and business_group_id = p_business_group_id)
9832: and p_lf_evt_ocrd_dt between

Line 10223: from ben_ptip_f

10219: select name
10220: from ben_pl_typ_f
10221: where pl_typ_id in
10222: ( select pl_typ_id
10223: from ben_ptip_f
10224: where pgm_id = p_pgm_id
10225: and acrs_ptip_cvg_id = p_acrs_ptip_cvg_id
10226: and business_group_id = p_business_group_id)
10227: and l_lf_evt_ocrd_dt between

Line 10237: ben_ptip_f ptp

10233: --
10234: cursor c_prtt_total_bnft_amt(p_acrs_ptip_cvg_id number) is
10235: select sum(prt.bnft_amt)
10236: from ben_prtt_enrt_rslt_f prt,
10237: ben_ptip_f ptp
10238: where prt.pgm_id = p_pgm_id
10239: and prt.person_id = p_person_id
10240: and prt.sspndd_flag = 'N' -- # 3626176
10241: and prt.prtt_enrt_rslt_stat_cd is null

Line 10261: ben_ptip_f ptp

10257: --
10258: cursor c_prtt_total_bnft_amt_sspndd(p_acrs_ptip_cvg_id number) is
10259: select sum(prt.bnft_amt)
10260: from ben_prtt_enrt_rslt_f prt,
10261: ben_ptip_f ptp
10262: where prt.pgm_id = p_pgm_id
10263: and prt.person_id = p_person_id
10264: and ( prt.sspndd_flag = 'Y' or (
10265: prt.sspndd_flag = 'N' and not exists (