APPS.BEN_ORG_DELETE dependencies on BEN_LE_CLSN_N_RSTR

Line 454: is select 1 from BEN_LE_CLSN_N_RSTR

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
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

Line 2861: -- Testing for values in BEN_LE_CLSN_N_RSTR

2857: --
2858: close c112;
2859:
2860: --
2861: -- Testing for values in BEN_LE_CLSN_N_RSTR
2862: --
2863: open c113(p_bg_id);
2864: --
2865: fetch c113 into l_temp;

Line 2869: fnd_message.set_token('TABLE_NAME','BEN_LE_CLSN_N_RSTR');

2865: fetch c113 into l_temp;
2866: if c113%found then
2867: close c113;
2868: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2869: fnd_message.set_token('TABLE_NAME','BEN_LE_CLSN_N_RSTR');
2870: fnd_message.raise_error;
2871: end if;
2872: --
2873: close c113;

Line 5913: delete from BEN_LE_CLSN_N_RSTR

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;
5915:
5916: delete from BEN_PER_IN_LER
5917: where business_group_id = p_bg_id;

Line 6480: delete from BEN_LE_CLSN_N_RSTR

6476:
6477: delete from BEN_PER_IN_ORG_UNIT_F
6478: where organization_id = p_org_id;
6479:
6480: delete from BEN_LE_CLSN_N_RSTR
6481: where organization_id = p_org_id;
6482:
6483: delete from BEN_PL_REGY_BOD_F
6484: where organization_id = p_org_id;