APPS.BEN_ORG_DELETE dependencies on BEN_PER_CM_F

Line 950: is select 1 from BEN_PER_CM_F

946: is select 1 from BEN_LER_CHG_PL_NIP_RL_F
947: where business_group_id = p_bg_id;
948:
949: cursor c238(p_bg_id NUMBER)
950: is select 1 from BEN_PER_CM_F
951: where business_group_id = p_bg_id;
952:
953: cursor c239(p_bg_id NUMBER)
954: is select 1 from BEN_PER_CM_TRGR_F

Line 4721: -- Testing for values in BEN_PER_CM_F

4717: --
4718: close c237;
4719:
4720: --
4721: -- Testing for values in BEN_PER_CM_F
4722: --
4723: open c238(p_bg_id);
4724: --
4725: fetch c238 into l_temp;

Line 4729: fnd_message.set_token('TABLE_NAME','BEN_PER_CM_F');

4725: fetch c238 into l_temp;
4726: if c238%found then
4727: close c238;
4728: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4729: fnd_message.set_token('TABLE_NAME','BEN_PER_CM_F');
4730: fnd_message.raise_error;
4731: end if;
4732: --
4733: close c238;

Line 6285: delete from BEN_PER_CM_F

6281:
6282: delete from BEN_LER_CHG_PL_NIP_RL_F
6283: where business_group_id = p_bg_id;
6284:
6285: delete from BEN_PER_CM_F
6286: where business_group_id = p_bg_id;
6287:
6288: delete from BEN_PER_CM_TRGR_F
6289: where business_group_id = p_bg_id;