APPS.BEN_ORG_DELETE dependencies on BEN_CSS_RLTD_PER_PER_IN_LER_F

Line 446: is select 1 from BEN_CSS_RLTD_PER_PER_IN_LER_F

442: is select 1 from BEN_CBR_PER_IN_LER
443: where business_group_id = p_bg_id;
444:
445: cursor c111(p_bg_id NUMBER)
446: is select 1 from BEN_CSS_RLTD_PER_PER_IN_LER_F
447: where business_group_id = p_bg_id;
448:
449: cursor c112(p_bg_id NUMBER)
450: is select 1 from BEN_LER_PER_INFO_CS_LER_F

Line 2831: -- Testing for values in BEN_CSS_RLTD_PER_PER_IN_LER_F

2827: --
2828: close c110;
2829:
2830: --
2831: -- Testing for values in BEN_CSS_RLTD_PER_PER_IN_LER_F
2832: --
2833: open c111(p_bg_id);
2834: --
2835: fetch c111 into l_temp;

Line 2839: fnd_message.set_token('TABLE_NAME','BEN_CSS_RLTD_PER_PER_IN_LER_F');

2835: fetch c111 into l_temp;
2836: if c111%found then
2837: close c111;
2838: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2839: fnd_message.set_token('TABLE_NAME','BEN_CSS_RLTD_PER_PER_IN_LER_F');
2840: fnd_message.raise_error;
2841: end if;
2842: --
2843: close c111;

Line 5907: delete from BEN_CSS_RLTD_PER_PER_IN_LER_F

5903:
5904: delete from BEN_CBR_PER_IN_LER
5905: where business_group_id = p_bg_id;
5906:
5907: delete from BEN_CSS_RLTD_PER_PER_IN_LER_F
5908: where business_group_id = p_bg_id;
5909:
5910: delete from BEN_LER_PER_INFO_CS_LER_F
5911: where business_group_id = p_bg_id;