APPS.BEN_OTP_BUS dependencies on BEN_OPTIP_F

Line 65: ben_otp_shd.constraint_error('BEN_OPTIP_F_PK');

61: and nvl(p_optip_id,hr_api.g_number)
62: <> ben_otp_shd.g_old_rec.optip_id) then
63: -- raise error as PK has changed
64: --
65: ben_otp_shd.constraint_error('BEN_OPTIP_F_PK');
66: --
67: elsif not l_api_updating then
68: --
69: -- check if PK is null

Line 75: ben_otp_shd.constraint_error('BEN_OPTIP_F_PK');

71: if p_optip_id is not null then
72: --
73: -- raise error as PK is not null
74: --
75: ben_otp_shd.constraint_error('BEN_OPTIP_F_PK');
76: --
77: end if;
78: --
79: end if;

Line 124: ben_optip_f optip

120: l_dummy varchar2(1) := null ;
121: --
122: cursor c_uniq_optip is
123: select null from
124: ben_optip_f optip
125: where optip.pgm_id = p_pgm_id
126: and optip.pl_typ_id = p_pl_typ_id
127: and optip.opt_id = p_opt_id
128: and optip.effective_start_date > p_effective_date ;

Line 163: , ben_optip_f otp

159: --
160: cursor csr_sec_grp is
161: select pbg.security_group_id
162: from per_business_groups pbg
163: , ben_optip_f otp
164: where otp.optip_id = p_optip_id
165: and pbg.business_group_id = otp.business_group_id;
166: --
167: -- Declare local variables

Line 225: , ben_optip_f otp

221: --
222: cursor csr_leg_code is
223: select pbg.legislation_code
224: from per_business_groups pbg
225: , ben_optip_f otp
226: where otp.optip_id = p_optip_id
227: and pbg.business_group_id = otp.business_group_id;
228: --
229: -- Declare local variables