APPS.BEN_ACT_BUS dependencies on BEN_PERSON_ACTIONS

Line 42: ben_benefit_actions bba, ben_person_actions bpa

38: --
39: cursor csr_leg_code is
40: select bg.legislation_code
41: from per_business_groups_perf bg,
42: ben_benefit_actions bba, ben_person_actions bpa
43: where bba.benefit_action_id = bpa.benefit_action_id
44: and bba.business_group_id = bg.business_group_id
45: and bpa.person_action_id = p_person_action_id;
46: --

Line 132: ben_act_shd.constraint_error('BEN_PERSON_ACTIONS_PK');

128: <> ben_act_shd.g_old_rec.person_action_id) then
129: --
130: -- raise error as PK has changed
131: --
132: ben_act_shd.constraint_error('BEN_PERSON_ACTIONS_PK');
133: --
134: elsif not l_api_updating then
135: --
136: -- check if PK is null

Line 142: ben_act_shd.constraint_error('BEN_PERSON_ACTIONS_PK');

138: if p_person_action_id is not null then
139: --
140: -- raise error as PK is not null
141: --
142: ben_act_shd.constraint_error('BEN_PERSON_ACTIONS_PK');
143: --
144: end if;
145: --
146: end if;

Line 215: ben_act_shd.constraint_error('BEN_PERSON_ACTIONS_FK1');

211: --
212: -- raise error as FK does not relate to PK in ben_benefit_actions
213: -- table.
214: --
215: ben_act_shd.constraint_error('BEN_PERSON_ACTIONS_FK1');
216: --
217: end if;
218: --
219: close c1;