APPS.BEN_XCV_BUS dependencies on BEN_EXT_CRIT_VAL

Line 178: , ben_ext_crit_val xcv

174: --
175: cursor csr_sec_grp is
176: select pbg.security_group_id
177: from per_business_groups_perf pbg
178: , ben_ext_crit_val xcv
179: where xcv.ext_crit_val_id = p_ext_crit_val_id
180: and pbg.business_group_id = xcv.business_group_id;
181: --
182: -- Declare local variables

Line 271: ben_xcv_shd.constraint_error('BEN_EXT_CRIT_VAL_PK');

267: <> ben_xcv_shd.g_old_rec.ext_crit_val_id) then
268: --
269: -- raise error as PK has changed
270: --
271: ben_xcv_shd.constraint_error('BEN_EXT_CRIT_VAL_PK');
272: --
273: elsif not l_api_updating then
274: --
275: -- check if PK is null

Line 281: ben_xcv_shd.constraint_error('BEN_EXT_CRIT_VAL_PK');

277: if p_ext_crit_val_id is not null then
278: --
279: -- raise error as PK is not null
280: --
281: ben_xcv_shd.constraint_error('BEN_EXT_CRIT_VAL_PK');
282: --
283: end if;
284: --
285: end if;

Line 354: ben_xcv_shd.constraint_error('BEN_EXT_CRIT_VAL_FK1');

350: --
351: -- raise error as FK does not relate to PK in ben_ext_crit_typ
352: -- table.
353: --
354: ben_xcv_shd.constraint_error('BEN_EXT_CRIT_VAL_FK1');
355: --
356: end if;
357: --
358: close c1;

Line 417: ben_xcv_shd.constraint_error('BEN_EXT_CRIT_VAL_FK3');

413: --
414: -- raise error as FK does not relate to PK in ben_ext_crit_typ
415: -- table.
416: --
417: ben_xcv_shd.constraint_error('BEN_EXT_CRIT_VAL_FK3');
418: --
419: end if;
420: --
421: close c1;

Line 557: ben_ext_crit_val b

553: --
554: cursor c9 is
555: select null
556: from ben_ext_crit_typ a,
557: ben_ext_crit_val b
558: where a.ext_crit_typ_id = b.ext_crit_typ_id
559: and a.ext_crit_typ_id = p_ext_crit_typ_id
560: and b.val_1 = p_val_1;
561:

Line 911: ben_ext_crit_val b

907: --
908: cursor c2 is
909: select null
910: from ben_ext_crit_typ a,
911: ben_ext_crit_val b
912: where a.ext_crit_typ_id = b.ext_crit_typ_id
913: and a.ext_crit_typ_id = p_ext_crit_typ_id
914: and b.val_2 = p_val_2;
915: --

Line 919: ben_ext_crit_val b

915: --
916: cursor c3 is
917: select null
918: from ben_ext_crit_typ a,
919: ben_ext_crit_val b
920: where a.ext_crit_typ_id = b.ext_crit_typ_id
921: and a.ext_crit_typ_id = p_ext_crit_typ_id
922: and b.val_1 = p_val_1
923: and b.val_2 = p_val_2;

Line 1231: ben_ext_crit_val b

1227: --
1228: cursor csr_leg_code is
1229: select a.legislation_code
1230: from per_business_groups_perf a,
1231: ben_ext_crit_val b
1232: where b.ext_crit_val_id = p_ext_crit_val_id
1233: and a.business_group_id(+) = b.business_group_id;
1234: --
1235: -- Declare local variables