APPS.BEN_ORG_DELETE dependencies on BEN_BATCH_ELIG_INFO

Line 1002: is select 1 from BEN_BATCH_ELIG_INFO

998: is select 1 from BEN_BATCH_ELCTBL_CHC_INFO
999: where business_group_id = p_bg_id;
1000:
1001: cursor c251(p_bg_id NUMBER)
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

Line 4916: -- Testing for values in BEN_BATCH_ELIG_INFO

4912: --
4913: close c250;
4914:
4915: --
4916: -- Testing for values in BEN_BATCH_ELIG_INFO
4917: --
4918: open c251(p_bg_id);
4919: --
4920: fetch c251 into l_temp;

Line 4924: fnd_message.set_token('TABLE_NAME','BEN_BATCH_ELIG_INFO');

4920: fetch c251 into l_temp;
4921: if c251%found then
4922: close c251;
4923: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4924: fnd_message.set_token('TABLE_NAME','BEN_BATCH_ELIG_INFO');
4925: fnd_message.raise_error;
4926: end if;
4927: --
4928: close c251;

Line 6324: delete from BEN_BATCH_ELIG_INFO

6320:
6321: delete from BEN_BATCH_ELCTBL_CHC_INFO
6322: where business_group_id = p_bg_id;
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;