APPS.BEN_ELIG_CVRD_DPNT_API dependencies on BEN_PRTT_ENRT_RSLT_F

Line 79: FROM ben_prtt_enrt_rslt_f pen

75: cursor c_chg_info (p_prtt_enrt_rslt_id number) is
76: SELECT pen.pl_id,
77: pen.oipl_id,
78: pen.person_id
79: FROM ben_prtt_enrt_rslt_f pen
80: WHERE pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
81: AND pen.prtt_enrt_rslt_stat_cd is null
82: AND p_effective_date between pen.effective_start_date and pen.effective_end_date;
83: --

Line 502: l_prtt_enrt_rslt_id ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE;

498: l_proc varchar2(72) := g_package||'update_ELIG_CVRD_DPNT';
499: l_object_version_number ben_elig_cvrd_dpnt_f.object_version_number%TYPE;
500: l_effective_start_date ben_elig_cvrd_dpnt_f.effective_start_date%TYPE;
501: l_effective_end_date ben_elig_cvrd_dpnt_f.effective_end_date%TYPE;
502: l_prtt_enrt_rslt_id ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE;
503: --
504: l2_object_version_number ben_cvrd_dpnt_ctfn_prvdd_f.object_version_number%TYPE;
505: l2_effective_start_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_start_date%TYPE;
506: l2_effective_end_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_end_date%TYPE;

Line 537: FROM ben_prtt_enrt_rslt_f pen,

533: pdp.dpnt_person_id,
534: pen.pl_id,
535: pen.oipl_id,
536: pen.person_id
537: FROM ben_prtt_enrt_rslt_f pen,
538: ben_elig_cvrd_dpnt_f pdp
539: WHERE pdp.elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
540: AND pen.prtt_enrt_rslt_stat_cd is null
541: and p_effective_date between pdp.effective_start_date and pdp.effective_end_date

Line 1297: ben_prtt_enrt_rslt_f pen

1293: pea.effective_end_date,
1294: pea.object_version_number,
1295: pen.object_version_number rslt_object_version_number
1296: from ben_prtt_enrt_actn_f pea,
1297: ben_prtt_enrt_rslt_f pen
1298: where pea.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1299: and pea.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
1300: and pen.prtt_enrt_rslt_stat_cd is null
1301: and p_effective_date between pea.effective_start_date

Line 1441: FROM ben_prtt_enrt_rslt_f pen

1437: cursor c_chg_info (p_prtt_enrt_rslt_id number) is
1438: SELECT pen.pl_id,
1439: pen.oipl_id,
1440: pen.person_id
1441: FROM ben_prtt_enrt_rslt_f pen
1442: WHERE pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1443: and pen.prtt_enrt_rslt_stat_cd is null
1444: and p_effective_date between pen.effective_start_date and pen.effective_end_date;
1445: --

Line 1860: FROM ben_prtt_enrt_rslt_f pen

1856: cursor c_chg_info (p_prtt_enrt_rslt_id number) is
1857: SELECT pen.pl_id,
1858: pen.oipl_id,
1859: pen.person_id
1860: FROM ben_prtt_enrt_rslt_f pen
1861: WHERE pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1862: and pen.prtt_enrt_rslt_stat_cd is null
1863: and p_effective_date between pen.effective_start_date and pen.effective_end_date;
1864: --

Line 2293: from ben_prtt_enrt_rslt_f

2289: --
2290: cursor get_rslt_ovn_c is
2291: select object_version_number,
2292: sspndd_flag
2293: from ben_prtt_enrt_rslt_f
2294: where prtt_enrt_rslt_id = l_prtt_enrt_rslt_id
2295: and business_group_id = l_business_group_id
2296: and prtt_enrt_rslt_stat_cd is null
2297: and p_effective_date between effective_start_date and effective_end_date

Line 2719: from ben_prtt_enrt_rslt_f r,

2715: ,r.oipl_id
2716: ,o.opt_id
2717: ,egd.cvg_strt_dt
2718: ,egd.cvg_thru_dt
2719: from ben_prtt_enrt_rslt_f r,
2720: ben_elig_cvrd_dpnt_f egd,
2721: ben_oipl_f o ,
2722: ben_per_in_ler pil
2723: where r.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id

Line 2893: ben_prtt_enrt_rslt_f en

2889: select p.name pl_name, o.name opt_name
2890: from ben_pl_f p,
2891: ben_opt_f o,
2892: ben_oipl_f op,
2893: ben_prtt_enrt_rslt_f en
2894: where en.prtt_enrt_rslt_id=p_prtt_enrt_rslt_id
2895: and p.pl_id=en.pl_id
2896: and en.oipl_id = op.oipl_id(+)
2897: and op.opt_id=o.opt_id(+)