APPS.BEN_ORG_DELETE dependencies on BEN_BATCH_LER_INFO

Line 1006: is select 1 from BEN_BATCH_LER_INFO

1002: is select 1 from BEN_BATCH_ELIG_INFO
1003: where business_group_id = p_bg_id;
1004:
1005: cursor c252(p_bg_id NUMBER)
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

Line 4931: -- Testing for values in BEN_BATCH_LER_INFO

4927: --
4928: close c251;
4929:
4930: --
4931: -- Testing for values in BEN_BATCH_LER_INFO
4932: --
4933: open c252(p_bg_id);
4934: --
4935: fetch c252 into l_temp;

Line 4939: fnd_message.set_token('TABLE_NAME','BEN_BATCH_LER_INFO');

4935: fetch c252 into l_temp;
4936: if c252%found then
4937: close c252;
4938: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4939: fnd_message.set_token('TABLE_NAME','BEN_BATCH_LER_INFO');
4940: fnd_message.raise_error;
4941: end if;
4942: --
4943: close c252;

Line 6327: delete from BEN_BATCH_LER_INFO

6323:
6324: delete from BEN_BATCH_ELIG_INFO
6325: where business_group_id = p_bg_id;
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;