APPS.BEN_ORG_DELETE dependencies on BEN_PER_IN_ORG_UNIT_F

Line 410: is select 1 from BEN_PER_IN_ORG_UNIT_F

406: is select 1 from BEN_PER_IN_LGL_ENTY_F
407: where business_group_id = p_bg_id;
408:
409: cursor c102(p_bg_id NUMBER)
410: is select 1 from BEN_PER_IN_ORG_UNIT_F
411: where business_group_id = p_bg_id;
412:
413: cursor c103(p_bg_id NUMBER)
414: is select 1 from BEN_PER_IN_ORG_ROLE_F

Line 2696: -- Testing for values in BEN_PER_IN_ORG_UNIT_F

2692: --
2693: close c101;
2694:
2695: --
2696: -- Testing for values in BEN_PER_IN_ORG_UNIT_F
2697: --
2698: open c102(p_bg_id);
2699: --
2700: fetch c102 into l_temp;

Line 2704: fnd_message.set_token('TABLE_NAME','BEN_PER_IN_ORG_UNIT_F');

2700: fetch c102 into l_temp;
2701: if c102%found then
2702: close c102;
2703: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2704: fnd_message.set_token('TABLE_NAME','BEN_PER_IN_ORG_UNIT_F');
2705: fnd_message.raise_error;
2706: end if;
2707: --
2708: close c102;

Line 5880: delete from BEN_PER_IN_ORG_UNIT_F

5876:
5877: delete from BEN_PER_IN_LGL_ENTY_F
5878: where business_group_id = p_bg_id;
5879:
5880: delete from BEN_PER_IN_ORG_UNIT_F
5881: where business_group_id = p_bg_id;
5882:
5883: delete from BEN_PER_IN_ORG_ROLE_F
5884: where business_group_id = p_bg_id;

Line 6477: delete from BEN_PER_IN_ORG_UNIT_F

6473:
6474: delete from BEN_PER_IN_LGL_ENTY_F
6475: where organization_id = p_org_id;
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;