APPS.BEN_ORG_DELETE dependencies on BEN_PER_IN_ORG_ROLE_F

Line 414: is select 1 from BEN_PER_IN_ORG_ROLE_F

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
415: where business_group_id = p_bg_id;
416:
417: cursor c104(p_bg_id NUMBER)
418: is select 1 from BEN_ACRS_PTIP_CVG_F

Line 2711: -- Testing for values in BEN_PER_IN_ORG_ROLE_F

2707: --
2708: close c102;
2709:
2710: --
2711: -- Testing for values in BEN_PER_IN_ORG_ROLE_F
2712: --
2713: open c103(p_bg_id);
2714: --
2715: fetch c103 into l_temp;

Line 2719: fnd_message.set_token('TABLE_NAME','BEN_PER_IN_ORG_ROLE_F');

2715: fetch c103 into l_temp;
2716: if c103%found then
2717: close c103;
2718: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2719: fnd_message.set_token('TABLE_NAME','BEN_PER_IN_ORG_ROLE_F');
2720: fnd_message.raise_error;
2721: end if;
2722: --
2723: close c103;

Line 5883: delete from BEN_PER_IN_ORG_ROLE_F

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;
5885:
5886: delete from BEN_ACRS_PTIP_CVG_F
5887: where business_group_id = p_bg_id;