APPS.BEN_ORG_DELETE dependencies on BEN_BATCH_ACTN_ITEM_INFO

Line 70: is select 1 from BEN_BATCH_ACTN_ITEM_INFO

66: is select 1 from BEN_ACTN_TYP
67: where business_group_id = p_bg_id;
68:
69: cursor c17(p_bg_id NUMBER)
70: is select 1 from BEN_BATCH_ACTN_ITEM_INFO
71: where business_group_id = p_bg_id;
72:
73: cursor c18(p_bg_id NUMBER)
74: is select 1 from BEN_BATCH_PARAMETER

Line 1421: -- Testing for values in BEN_BATCH_ACTN_ITEM_INFO

1417: --
1418: close c16;
1419:
1420: --
1421: -- Testing for values in BEN_BATCH_ACTN_ITEM_INFO
1422: --
1423: open c17(p_bg_id);
1424: --
1425: fetch c17 into l_temp;

Line 1429: fnd_message.set_token('TABLE_NAME','BEN_BATCH_ACTN_ITEM_INFO');

1425: fetch c17 into l_temp;
1426: if c17%found then
1427: close c17;
1428: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1429: fnd_message.set_token('TABLE_NAME','BEN_BATCH_ACTN_ITEM_INFO');
1430: fnd_message.raise_error;
1431: end if;
1432: --
1433: close c17;

Line 5625: delete from BEN_BATCH_ACTN_ITEM_INFO

5621:
5622: delete from BEN_ACTN_TYP
5623: where business_group_id = p_bg_id;
5624:
5625: delete from BEN_BATCH_ACTN_ITEM_INFO
5626: where business_group_id = p_bg_id;
5627:
5628: delete from BEN_BATCH_PARAMETER
5629: where business_group_id = p_bg_id;