APPS.BEN_MANAGE_LIFE_EVENTS dependencies on BEN_PRTT_ENRT_RSLT_F

Line 2446: from ben_prtt_enrt_rslt_f pen,

2442: --
2443: --bug#2718215
2444: cursor c_result_pgm (p_pgm_id number) is
2445: select effective_start_date
2446: from ben_prtt_enrt_rslt_f pen,
2447: ben_per_in_ler pil
2448: where pen.pgm_id = p_pgm_id
2449: and pen.person_id = pil.person_id
2450: and pil.per_in_ler_id = p_per_in_ler_id

Line 2456: from ben_prtt_enrt_rslt_f pen,

2452: and pen.effective_end_date = hr_api.g_eot;
2453: --
2454: cursor c_result_pln (p_pl_id number) is
2455: select effective_start_date
2456: from ben_prtt_enrt_rslt_f pen,
2457: ben_per_in_ler pil
2458: where pen.pl_id = p_pl_id
2459: and pen.person_id = pil.person_id
2460: and pil.per_in_ler_id = p_per_in_ler_id

Line 3906: FROM ben_prtt_enrt_rslt_f pen

3902: cv_pl_id in number,
3903: cv_pgm_id in number)
3904: IS
3905: SELECT pen.prtt_enrt_rslt_id
3906: FROM ben_prtt_enrt_rslt_f pen
3907: WHERE pen.person_id = cv_person_id
3908: AND pen.business_group_id = cv_business_group_id
3909: AND pen.sspndd_flag = 'N'
3910: AND pen.prtt_enrt_rslt_stat_cd IS NULL

Line 4421: FROM ben_prtt_enrt_rslt_f pen

4417: cv_pl_id in number,
4418: cv_pgm_id in number)
4419: IS
4420: SELECT pen.prtt_enrt_rslt_id
4421: FROM ben_prtt_enrt_rslt_f pen
4422: WHERE pen.person_id = cv_person_id
4423: AND pen.business_group_id = cv_business_group_id
4424: AND pen.sspndd_flag = 'N'
4425: AND pen.prtt_enrt_rslt_stat_cd IS NULL

Line 8447: from ben_prtt_enrt_rslt_f pen

8443: pen.pgm_id,
8444: pen.ptip_id,
8445: pen.enrt_cvg_strt_dt,
8446: pen.enrt_cvg_thru_dt
8447: from ben_prtt_enrt_rslt_f pen
8448: where pen.person_id = p_person_id
8449: and pen.business_group_id = p_business_group_id
8450: and p_effective_date
8451: between pen.enrt_cvg_strt_dt

Line 9725: ,ben_prtt_enrt_rslt_f pen

9721: -- RCHASE - wwBug1427383 - return correct date for creating dependent benefit assignment
9722: select pdp.dpnt_person_id, min(egd.elig_thru_dt) cvg_thru_dt--min(pdp.cvg_thru_dt) cvg_thru_dt
9723: from ben_elig_cvrd_dpnt_f pdp
9724: ,ben_elig_dpnt egd
9725: ,ben_prtt_enrt_rslt_f pen
9726: where pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
9727: and pen.person_id = p_person_id
9728: and pen.effective_end_date = hr_api.g_eot
9729: and pen.business_group_id = p_business_group_id

Line 9790: from ben_prtt_enrt_rslt_f pen

9786: -- Min Max enhancement.
9787: --
9788: cursor c_get_ended_enrt_rslts(p_per_in_ler_id number) is
9789: select pen.*
9790: from ben_prtt_enrt_rslt_f pen
9791: where pen.person_id = p_person_id
9792: and pen.prtt_enrt_rslt_stat_cd is null
9793: and pen.sspndd_flag = 'N'
9794: and pen.enrt_cvg_thru_dt <> hr_api.g_eot

Line 9804: from ben_prtt_enrt_rslt_f pen

9800: and pen.per_in_ler_id = p_per_in_ler_id
9801: ;
9802: cursor c_get_ptip_tot_enrd(p_ptip_id number) is
9803: select count(*)
9804: from ben_prtt_enrt_rslt_f pen
9805: where pen.person_id = p_person_id
9806: and pen.prtt_enrt_rslt_stat_cd is null
9807: and pen.sspndd_flag = 'N'
9808: and pen.ptip_id = p_ptip_id