APPS.BEN_ORG_DELETE dependencies on BEN_PAIRD_RT_F

Line 1098: is select 1 from BEN_PAIRD_RT_F

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
1099: where business_group_id = p_bg_id;
1100:
1101: cursor c276(p_bg_id NUMBER)
1102: is select 1 from BEN_PRTL_MO_RT_PRTN_VAL_F

Line 5276: -- Testing for values in BEN_PAIRD_RT_F

5272: --
5273: close c274;
5274:
5275: --
5276: -- Testing for values in BEN_PAIRD_RT_F
5277: --
5278: open c275(p_bg_id);
5279: --
5280: fetch c275 into l_temp;

Line 5284: fnd_message.set_token('TABLE_NAME','BEN_PAIRD_RT_F');

5280: fetch c275 into l_temp;
5281: if c275%found then
5282: close c275;
5283: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5284: fnd_message.set_token('TABLE_NAME','BEN_PAIRD_RT_F');
5285: fnd_message.raise_error;
5286: end if;
5287: --
5288: close c275;

Line 6396: delete from BEN_PAIRD_RT_F

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;
6398:
6399: delete from BEN_PRTL_MO_RT_PRTN_VAL_F
6400: where business_group_id = p_bg_id;