APPS.BEN_ELIG_DPNT_API dependencies on BEN_PRTT_ENRT_RSLT_F

Line 1334: FROM ben_prtt_enrt_rslt_f sspndd, ben_prtt_enrt_rslt_f inter

1330: CURSOR c_is_pen_interim (cv_prtt_enrt_rslt_id NUMBER,
1331: cv_effective_date DATE )
1332: IS
1333: SELECT sspndd.prtt_enrt_rslt_id
1334: FROM ben_prtt_enrt_rslt_f sspndd, ben_prtt_enrt_rslt_f inter
1335: WHERE inter.prtt_enrt_rslt_id = cv_prtt_enrt_rslt_id
1336: AND sspndd.rplcs_sspndd_rslt_id = inter.prtt_enrt_rslt_id
1337: AND sspndd.pl_id = inter.pl_id
1338: AND NVL (sspndd.pgm_id, -1) = NVL (inter.pgm_id, -1)

Line 2053: FROM ben_prtt_enrt_rslt_f pen,

2049: SELECT pen.person_id,
2050: pln.pl_id,
2051: typ.pl_typ_id,
2052: (typ.name || ' - ' || pln.name) comp_obj_name
2053: FROM ben_prtt_enrt_rslt_f pen,
2054: ben_pl_f pln,
2055: ben_pl_typ_f typ,
2056: ben_elig_per_elctbl_chc chc
2057: WHERE chc.per_in_ler_id = p_per_in_ler_id

Line 2090: FROM ben_prtt_enrt_rslt_f pen2

2086: and nvl(crt.apls_perd_endg_dt, pen.enrt_cvg_thru_dt)
2087: )
2088: AND NOT EXISTS
2089: (SELECT 1
2090: FROM ben_prtt_enrt_rslt_f pen2
2091: where pen2.rplcs_sspndd_rslt_id = pen.prtt_enrt_rslt_id
2092: and pen2.sspndd_flag = 'Y'
2093: and pen2.prtt_enrt_rslt_stat_cd is null
2094: and p_effective_date between

Line 2227: ben_prtt_enrt_rslt_f pen,

2223: cursor c_pen is
2224: select egd.*
2225: from ben_elig_dpnt egd,
2226: ben_elig_cvrd_dpnt_f pdp,
2227: ben_prtt_enrt_rslt_f pen,
2228: ben_per_in_ler pil
2229: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2230: and pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
2231: and pdp.dpnt_person_id = p_dpnt_person_id

Line 2673: ben_prtt_enrt_rslt_f pen,

2669: ) is
2670:
2671: cursor c_chk_enrt (c_rltp_start_date date,c_rltp_end_date date) is
2672: select 'Y' from ben_elig_cvrd_dpnt_f ecd,
2673: ben_prtt_enrt_rslt_f pen,
2674: ben_per_in_ler pil
2675: where ecd.dpnt_person_id = p_dpnt_person_id
2676: and ecd.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
2677: and pen.prtt_enrt_rslt_stat_cd is null