APPS.BEN_VEP_BUS dependencies on BEN_VRBL_RT_ELIG_PRFL_F

Line 64: ben_vep_shd.constraint_error('BEN_VRBL_RT_ELIG_PRFL_F_PK');

60: and nvl(p_vrbl_rt_elig_prfl_id,hr_api.g_number)
61: <> ben_vep_shd.g_old_rec.vrbl_rt_elig_prfl_id) then
62: -- raise error as PK has changed
63: --
64: ben_vep_shd.constraint_error('BEN_VRBL_RT_ELIG_PRFL_F_PK');
65: --
66: elsif not l_api_updating then
67: --
68: -- check if PK is null

Line 74: ben_vep_shd.constraint_error('BEN_VRBL_RT_ELIG_PRFL_F_PK');

70: if p_vrbl_rt_elig_prfl_id is not null then
71: --
72: -- raise error as PK is not null
73: --
74: ben_vep_shd.constraint_error('BEN_VRBL_RT_ELIG_PRFL_F_PK');
75: --
76: end if;
77: --
78: end if;

Line 190: BEN_VRBL_RT_ELIG_PRFL_f vep

186: l_dummy varchar2(1) := null ;
187: --
188: cursor c_vrbl_rt_elig_prfl is
189: select null from
190: BEN_VRBL_RT_ELIG_PRFL_f vep
191: where
192: vep.vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
193: and p_effective_date between effective_start_date
194: and effective_end_date;

Line 255: BEN_VRBL_RT_ELIG_PRFL_f vep

251: l_dummy varchar2(1) := null ;
252: --
253: cursor c_uniq_vrbl_rt_elig_prfl is
254: select null from
255: BEN_VRBL_RT_ELIG_PRFL_f vep
256: where
257: vep.eligy_prfl_id = p_eligy_prfl_id
258: and vep.vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
259: and vep.effective_start_date > p_effective_date

Line 420: , BEN_VRBL_RT_ELIG_PRFL_f vep

416: --
417: cursor csr_sec_grp is
418: select pbg.security_group_id
419: from per_business_groups pbg
420: , BEN_VRBL_RT_ELIG_PRFL_f vep
421: where vep.vrbl_rt_elig_prfl_id = p_vrbl_rt_elig_prfl_id
422: and pbg.business_group_id = vep.business_group_id;
423: --
424: -- Declare local variables

Line 480: , BEN_VRBL_RT_ELIG_PRFL_f vep

476: --
477: cursor csr_leg_code is
478: select pbg.legislation_code
479: from per_business_groups pbg
480: , BEN_VRBL_RT_ELIG_PRFL_f vep
481: where vep.vrbl_rt_elig_prfl_id = p_vrbl_rt_elig_prfl_id
482: and pbg.business_group_id = vep.business_group_id;
483: --
484: -- Declare local variables

Line 812: from ben_vrbl_rt_elig_prfl_f

808: (select null
809: from ben_elig_ttl_prtt_prte_f
810: where eligy_prfl_id in
811: (select eligy_prfl_id
812: from ben_vrbl_rt_elig_prfl_f
813: where vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
814: and business_group_id = p_business_group_id
815: and p_effective_date between effective_start_date and effective_end_date)
816: or eligy_prfl_id = p_eligy_prfl_id);

Line 827: from ben_vrbl_rt_elig_prfl_f

823: (select null
824: from ben_elig_ttl_cvg_vol_prte_f
825: where eligy_prfl_id in
826: (select eligy_prfl_id
827: from ben_vrbl_rt_elig_prfl_f
828: where vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
829: and business_group_id = p_business_group_id
830: and p_effective_date between effective_start_date and effective_end_date)
831: or eligy_prfl_id = p_eligy_prfl_id);