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 2046: FROM ben_prtt_enrt_rslt_f pen,

2042: SELECT pen.person_id,
2043: pln.pl_id,
2044: typ.pl_typ_id,
2045: (typ.name || ' - ' || pln.name) comp_obj_name
2046: FROM ben_prtt_enrt_rslt_f pen,
2047: ben_pl_f pln,
2048: ben_pl_typ_f typ,
2049: ben_elig_per_elctbl_chc chc
2050: WHERE chc.per_in_ler_id = p_per_in_ler_id

Line 2083: FROM ben_prtt_enrt_rslt_f pen2

2079: and nvl(crt.apls_perd_endg_dt, pen.enrt_cvg_thru_dt)
2080: )
2081: AND NOT EXISTS
2082: (SELECT 1
2083: FROM ben_prtt_enrt_rslt_f pen2
2084: where pen2.rplcs_sspndd_rslt_id = pen.prtt_enrt_rslt_id
2085: and pen2.sspndd_flag = 'Y'
2086: and pen2.prtt_enrt_rslt_stat_cd is null
2087: and p_effective_date between

Line 2220: ben_prtt_enrt_rslt_f pen,

2216: cursor c_pen is
2217: select egd.*
2218: from ben_elig_dpnt egd,
2219: ben_elig_cvrd_dpnt_f pdp,
2220: ben_prtt_enrt_rslt_f pen,
2221: ben_per_in_ler pil
2222: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2223: and pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
2224: and pdp.dpnt_person_id = p_dpnt_person_id