APPS.BEN_ORG_DELETE dependencies on BEN_BATCH_PARAMETER

Line 74: is select 1 from BEN_BATCH_PARAMETER

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
75: where business_group_id = p_bg_id;
76:
77: cursor c19(p_bg_id NUMBER)
78: is select 1 from BEN_BNFTS_BAL_F

Line 1436: -- Testing for values in BEN_BATCH_PARAMETER

1432: --
1433: close c17;
1434:
1435: --
1436: -- Testing for values in BEN_BATCH_PARAMETER
1437: --
1438: open c18(p_bg_id);
1439: --
1440: fetch c18 into l_temp;

Line 1444: fnd_message.set_token('TABLE_NAME','BEN_BATCH_PARAMETER');

1440: fetch c18 into l_temp;
1441: if c18%found then
1442: close c18;
1443: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1444: fnd_message.set_token('TABLE_NAME','BEN_BATCH_PARAMETER');
1445: fnd_message.raise_error;
1446: end if;
1447: --
1448: close c18;

Line 5628: delete from BEN_BATCH_PARAMETER

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;
5630:
5631: delete from BEN_BNFTS_BAL_F
5632: where business_group_id = p_bg_id;