APPS.BEN_ORG_DELETE dependencies on BEN_BATCH_RATE_INFO

Line 1010: is select 1 from BEN_BATCH_RATE_INFO

1006: is select 1 from BEN_BATCH_LER_INFO
1007: where business_group_id = p_bg_id;
1008:
1009: cursor c253(p_bg_id NUMBER)
1010: is select 1 from BEN_BATCH_RATE_INFO
1011: where business_group_id = p_bg_id;
1012:
1013: cursor c254(p_bg_id NUMBER)
1014: is select 1 from BEN_BENEFIT_ACTIONS

Line 4946: -- Testing for values in BEN_BATCH_RATE_INFO

4942: --
4943: close c252;
4944:
4945: --
4946: -- Testing for values in BEN_BATCH_RATE_INFO
4947: --
4948: open c253(p_bg_id);
4949: --
4950: fetch c253 into l_temp;

Line 4954: fnd_message.set_token('TABLE_NAME','BEN_BATCH_RATE_INFO');

4950: fetch c253 into l_temp;
4951: if c253%found then
4952: close c253;
4953: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4954: fnd_message.set_token('TABLE_NAME','BEN_BATCH_RATE_INFO');
4955: fnd_message.raise_error;
4956: end if;
4957: --
4958: close c253;

Line 6330: delete from BEN_BATCH_RATE_INFO

6326:
6327: delete from BEN_BATCH_LER_INFO
6328: where business_group_id = p_bg_id;
6329:
6330: delete from BEN_BATCH_RATE_INFO
6331: where business_group_id = p_bg_id;
6332:
6333: delete from BEN_BENEFIT_ACTIONS
6334: where business_group_id = p_bg_id;