APPS.BEN_ORG_DELETE dependencies on BEN_MTCHG_RT_F

Line 1094: is select 1 from BEN_MTCHG_RT_F

1090: is select 1 from BEN_COMP_LVL_ACTY_RT_F
1091: where business_group_id = p_bg_id;
1092:
1093: cursor c274(p_bg_id NUMBER)
1094: is select 1 from BEN_MTCHG_RT_F
1095: where business_group_id = p_bg_id;
1096:
1097: cursor c275(p_bg_id NUMBER)
1098: is select 1 from BEN_PAIRD_RT_F

Line 5261: -- Testing for values in BEN_MTCHG_RT_F

5257: --
5258: close c273;
5259:
5260: --
5261: -- Testing for values in BEN_MTCHG_RT_F
5262: --
5263: open c274(p_bg_id);
5264: --
5265: fetch c274 into l_temp;

Line 5269: fnd_message.set_token('TABLE_NAME','BEN_MTCHG_RT_F');

5265: fetch c274 into l_temp;
5266: if c274%found then
5267: close c274;
5268: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5269: fnd_message.set_token('TABLE_NAME','BEN_MTCHG_RT_F');
5270: fnd_message.raise_error;
5271: end if;
5272: --
5273: close c274;

Line 6393: delete from BEN_MTCHG_RT_F

6389:
6390: delete from BEN_COMP_LVL_ACTY_RT_F
6391: where business_group_id = p_bg_id;
6392:
6393: delete from BEN_MTCHG_RT_F
6394: where business_group_id = p_bg_id;
6395:
6396: delete from BEN_PAIRD_RT_F
6397: where business_group_id = p_bg_id;