APPS.BEN_XCV_BUS dependencies on BEN_EXT_CRIT_TYP

Line 326: from ben_ext_crit_typ a

322: l_dummy varchar2(1);
323: --
324: cursor c1 is
325: select null
326: from ben_ext_crit_typ a
327: where a.ext_crit_typ_id = p_ext_crit_typ_id;
328: --
329: Begin
330: --

Line 342: -- check if ext_crit_typ_id value exists in ben_ext_crit_typ table

338: and nvl(p_ext_crit_typ_id,hr_api.g_number)
339: <> nvl(ben_xcv_shd.g_old_rec.ext_crit_typ_id,hr_api.g_number)
340: or not l_api_updating) then
341: --
342: -- check if ext_crit_typ_id value exists in ben_ext_crit_typ table
343: --
344: open c1;
345: --
346: fetch c1 into l_dummy;

Line 351: -- raise error as FK does not relate to PK in ben_ext_crit_typ

347: if c1%notfound then
348: --
349: close c1;
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: --

Line 386: ben_ext_crit_typ ect

382:
383: cursor c2 is
384: select ecp.ext_global_flag
385: from ben_ext_crit_prfl ecp ,
386: ben_ext_crit_typ ect
387: where ect.ext_crit_typ_id = p_ext_crit_typ_id
388: and ect.ext_crit_prfl_id = ecp.ext_crit_prfl_id
389: ;
390: --

Line 404: -- check if ext_crit_typ_id value exists in ben_ext_crit_typ table

400: and nvl(p_ext_crit_bg_id,hr_api.g_number)
401: <> nvl(ben_xcv_shd.g_old_rec.ext_crit_bg_id,hr_api.g_number)
402: or not l_api_updating) then
403: --
404: -- check if ext_crit_typ_id value exists in ben_ext_crit_typ table
405: --
406: if p_ext_crit_bg_id is not null and p_ext_crit_bg_id <> p_business_group_id then
407: open c1;
408: --

Line 414: -- raise error as FK does not relate to PK in ben_ext_crit_typ

410: if c1%notfound then
411: --
412: close c1;
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: --

Line 487: from ben_ext_crit_typ a

483: l_number number;
484: --
485: cursor c1 is
486: select a.crit_typ_cd
487: from ben_ext_crit_typ a
488: where a.ext_crit_typ_id = p_ext_crit_typ_id;
489: --
490: cursor c2 (p_business_group_id number) is
491: select null

Line 556: from ben_ext_crit_typ a,

552: -- need to somehow add legislation code to this cursor.
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;

Line 905: from ben_ext_crit_typ a

901: l_crit_typ_cd varchar2(30);
902: --
903: cursor c1 is
904: select a.crit_typ_cd
905: from ben_ext_crit_typ a
906: where a.ext_crit_typ_id = p_ext_crit_typ_id;
907: --
908: cursor c2 is
909: select null

Line 910: from ben_ext_crit_typ a,

906: where a.ext_crit_typ_id = p_ext_crit_typ_id;
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;

Line 918: from ben_ext_crit_typ a,

914: and b.val_2 = p_val_2;
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

Line 1018: from ben_ext_crit_typ a

1014: --
1015: l_crit_typ_cd varchar2(30);
1016: cursor c1 is
1017: select a.crit_typ_cd
1018: from ben_ext_crit_typ a
1019: where a.ext_crit_typ_id = p_ext_crit_typ_id;
1020: --
1021: Begin
1022: --