APPS.BEN_PPV_BUS dependencies on BEN_PRTL_MO_RT_PRTN_VAL_F

Line 59: ben_ppv_shd.constraint_error('BEN_PRTL_MO_RT_PRTN_VAL_F_PK');

55: <> ben_ppv_shd.g_old_rec.prtl_mo_rt_prtn_val_id) then
56: --
57: -- raise error as PK has changed
58: --
59: ben_ppv_shd.constraint_error('BEN_PRTL_MO_RT_PRTN_VAL_F_PK');
60: --
61: elsif not l_api_updating then
62: --
63: -- check if PK is null

Line 69: ben_ppv_shd.constraint_error('BEN_PRTL_MO_RT_PRTN_VAL_F_PK');

65: if p_prtl_mo_rt_prtn_val_id is not null then
66: --
67: -- raise error as PK is not null
68: --
69: ben_ppv_shd.constraint_error('BEN_PRTL_MO_RT_PRTN_VAL_F_PK');
70: --
71: end if;
72: --
73: end if;

Line 87: from ben_prtl_mo_rt_prtn_val_f ppv

83: is
84: --
85: cursor c1 is
86: select null
87: from ben_prtl_mo_rt_prtn_val_f ppv
88: where ppv.PRORATE_BY_DAY_TO_MON_FLAG = 'Y'
89: and ppv.acty_base_rt_id = p_acty_base_rt_id
90: and p_effective_date between ppv.effective_start_date
91: and ppv.effective_end_date;

Line 95: from ben_prtl_mo_rt_prtn_val_f ppv

91: and ppv.effective_end_date;
92: --
93: cursor c2 is
94: select null
95: from ben_prtl_mo_rt_prtn_val_f ppv
96: where ppv.PRORATE_BY_DAY_TO_MON_FLAG = 'Y'
97: and ppv.acty_base_rt_id = p_acty_base_rt_id
98: and ppv.prtl_mo_rt_prtn_val_id <> p_prtl_mo_rt_prtn_val_id
99: and p_effective_date between ppv.effective_start_date

Line 573: from ben_prtl_mo_rt_prtn_val_f

569: -- prorate on day/month basis and percent/rule defined
570: --
571: cursor chk_overlap is
572: select 'Y'
573: from ben_prtl_mo_rt_prtn_val_f
574: Where prtl_mo_rt_prtn_val_id <> nvl(p_prtl_mo_rt_prtn_val_id,-1)
575: and (acty_base_rt_id = p_acty_base_rt_id or
576: actl_prem_id = p_actl_prem_id) -- Bug 4440097
577: and prorate_by_day_to_mon_flag = 'Y'

Line 727: from ben_prtl_mo_rt_prtn_val_f

723: l_to_day number(2);
724: l_strt_r_stp_cd varchar2(5);
725: --
726: cursor c1 is select from_dy_mo_num, to_dy_mo_num
727: from ben_prtl_mo_rt_prtn_val_f
728: Where prtl_mo_rt_prtn_val_id <> nvl(p_prtl_mo_rt_prtn_val_id,-1)
729: and acty_base_rt_id = p_acty_base_rt_id
730: and strt_r_stp_cvg_cd = p_strt_r_stp_cvg_cd
731: and num_days_month = p_num_days_month -- Bug No 4366086

Line 739: from ben_prtl_mo_rt_prtn_val_f

735: and p_validation_end_date >= effective_start_date
736: and business_group_id = p_business_group_id;
737: --
738: cursor c2 is select strt_r_stp_cvg_cd
739: from ben_prtl_mo_rt_prtn_val_f
740: Where prtl_mo_rt_prtn_val_id <> nvl(p_prtl_mo_rt_prtn_val_id,-1)
741: and acty_base_rt_id = p_acty_base_rt_id
742: and num_days_month = p_num_days_month -- Bug No 4366086
743: -- and p_effective_date between effective_start_date

Line 1259: ben_prtl_mo_rt_prtn_val_f b

1255: --
1256: cursor csr_leg_code is
1257: select a.legislation_code
1258: from per_business_groups a,
1259: ben_prtl_mo_rt_prtn_val_f b
1260: where b.prtl_mo_rt_prtn_val_id = p_prtl_mo_rt_prtn_val_id
1261: and a.business_group_id = b.business_group_id;
1262: --
1263: -- Declare local variables