APPS.BEN_ORG_DELETE dependencies on BEN_PER_IN_LER

Line 458: is select 1 from BEN_PER_IN_LER

454: is select 1 from BEN_LE_CLSN_N_RSTR
455: where business_group_id = p_bg_id;
456:
457: cursor c114(p_bg_id NUMBER)
458: is select 1 from BEN_PER_IN_LER
459: where business_group_id = p_bg_id;
460:
461: cursor c115(p_bg_id NUMBER)
462: is select 1 from BEN_PTNL_LER_FOR_PER

Line 2876: -- Testing for values in BEN_PER_IN_LER

2872: --
2873: close c113;
2874:
2875: --
2876: -- Testing for values in BEN_PER_IN_LER
2877: --
2878: open c114(p_bg_id);
2879: --
2880: fetch c114 into l_temp;

Line 2884: fnd_message.set_token('TABLE_NAME','BEN_PER_IN_LER');

2880: fetch c114 into l_temp;
2881: if c114%found then
2882: close c114;
2883: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2884: fnd_message.set_token('TABLE_NAME','BEN_PER_IN_LER');
2885: fnd_message.raise_error;
2886: end if;
2887: --
2888: close c114;

Line 5916: delete from BEN_PER_IN_LER

5912:
5913: delete from BEN_LE_CLSN_N_RSTR
5914: where business_group_id = p_bg_id;
5915:
5916: delete from BEN_PER_IN_LER
5917: where business_group_id = p_bg_id;
5918:
5919: delete from BEN_PTNL_LER_FOR_PER
5920: where business_group_id = p_bg_id;