APPS.BEN_MNG_DPNT_BNF dependencies on BEN_PRTT_ENRT_RSLT_F

Line 75: l_old_prtt_enrt_rslt_id ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%type; -- Bug 9888746

71: l_ttl_no_max_flag varchar2(30);
72: l_grp_rlshp_cd ben_dsgn_rqmt_f.grp_rlshp_cd%type ;
73: l_dsgn_rqmt_id number;
74: --
75: l_old_prtt_enrt_rslt_id ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%type; -- Bug 9888746
76: --
77: --
78: -- total designation requirement (new comp object):
79: --

Line 164: (select '1' from ben_prtt_enrt_rslt_f pen1

160: and not exists(
161: select '1' from dual where
162: (
163: ('Y' = (select 'Y' from dual where exists
164: (select '1' from ben_prtt_enrt_rslt_f pen1
165: where pen1.prtt_enrt_rslt_id = p_old_prtt_enrt_rslt_id
166: and pen1.prtt_enrt_rslt_stat_cd is NULL
167: and pen1.effective_end_date = hr_api.g_eot
168: and pen1.enrt_cvg_thru_dt = hr_api.g_eot)

Line 207: ,ben_prtt_enrt_rslt_f pen5

203: or (l_old_prtt_enrt_rslt_id <> p_new_prtt_enrt_rslt_id
204: and ('1' = (select '1' from dual where
205: exists
206: (select '1' from ben_le_clsn_n_rstr pdp_old
207: ,ben_prtt_enrt_rslt_f pen5
208: where pdp_old.per_in_ler_id = ben_manage_life_events.g_bckdt_per_in_ler_id
209: and pdp_old.prtt_enrt_rslt_id <> l_old_prtt_enrt_rslt_id
210: and pdp_old.business_group_id = p_business_group_id
211: and pdp_old.dpnt_person_id = old.dpnt_person_id

Line 222: ,ben_prtt_enrt_rslt_f pen5

218: and pen5.pl_typ_id in (select pl_typ_id from ben_elig_per_elctbl_chc
219: where elig_per_elctbl_chc_id = p_new_elig_per_elctbl_chc_id)
220: union
221: select '1' from ben_elig_cvrd_dpnt_f pdp_old
222: ,ben_prtt_enrt_rslt_f pen5
223: where pdp_old.per_in_ler_id = ben_manage_life_events.g_bckdt_per_in_ler_id
224: and pdp_old.prtt_enrt_rslt_id <> l_old_prtt_enrt_rslt_id
225: and pdp_old.business_group_id = p_business_group_id
226: and pdp_old.dpnt_person_id = old.dpnt_person_id

Line 438: from ben_prtt_enrt_rslt_f old_pen, ben_prtt_enrt_rslt_f new_pen

434: -- Getting the Pen_id of the comp object of the previous Per_in_ler
435:
436: CURSOR c_check_old_pen IS
437: SELECT old_pen.prtt_enrt_rslt_id
438: from ben_prtt_enrt_rslt_f old_pen, ben_prtt_enrt_rslt_f new_pen
439: where old_pen.pgm_id = new_pen.pgm_id
440: -- and old_pen.pl_id = new_pen.pl_id
441: and old_pen.ptip_id = new_pen.ptip_id --Bug 14740884
442: -- and nvl(old_pen.oipl_id,1) = nvl(new_pen.oipl_id,1)

Line 837: from ben_prtt_enrt_rslt_f

833: is
834: select ptip.dpnt_cvg_no_ctfn_rqd_flag
835: from ben_ptip_f ptip
836: where ptip.ptip_id = (select ptip_id
837: from ben_prtt_enrt_rslt_f
838: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
839: and business_group_id =p_business_group_id
840: and prtt_enrt_rslt_stat_cd is null
841: and p_effective_date between effective_start_date