APPS.BEN_ORG_DELETE dependencies on BEN_LER_PER_INFO_CS_LER_F

Line 450: is select 1 from BEN_LER_PER_INFO_CS_LER_F

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
451: where business_group_id = p_bg_id;
452:
453: cursor c113(p_bg_id NUMBER)
454: is select 1 from BEN_LE_CLSN_N_RSTR

Line 2846: -- Testing for values in BEN_LER_PER_INFO_CS_LER_F

2842: --
2843: close c111;
2844:
2845: --
2846: -- Testing for values in BEN_LER_PER_INFO_CS_LER_F
2847: --
2848: open c112(p_bg_id);
2849: --
2850: fetch c112 into l_temp;

Line 2854: fnd_message.set_token('TABLE_NAME','BEN_LER_PER_INFO_CS_LER_F');

2850: fetch c112 into l_temp;
2851: if c112%found then
2852: close c112;
2853: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2854: fnd_message.set_token('TABLE_NAME','BEN_LER_PER_INFO_CS_LER_F');
2855: fnd_message.raise_error;
2856: end if;
2857: --
2858: close c112;

Line 5910: delete from BEN_LER_PER_INFO_CS_LER_F

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;
5912:
5913: delete from BEN_LE_CLSN_N_RSTR
5914: where business_group_id = p_bg_id;