APPS.BEN_ORG_DELETE dependencies on BEN_PRTL_MO_RT_PRTN_VAL_F

Line 1102: is select 1 from BEN_PRTL_MO_RT_PRTN_VAL_F

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
1103: where business_group_id = p_bg_id;
1104:
1105: cursor c277(p_bg_id NUMBER)
1106: is select 1 from BEN_VRBL_RT_RL_F

Line 5291: -- Testing for values in BEN_PRTL_MO_RT_PRTN_VAL_F

5287: --
5288: close c275;
5289:
5290: --
5291: -- Testing for values in BEN_PRTL_MO_RT_PRTN_VAL_F
5292: --
5293: open c276(p_bg_id);
5294: --
5295: fetch c276 into l_temp;

Line 5299: fnd_message.set_token('TABLE_NAME','BEN_PRTL_MO_RT_PRTN_VAL_F');

5295: fetch c276 into l_temp;
5296: if c276%found then
5297: close c276;
5298: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5299: fnd_message.set_token('TABLE_NAME','BEN_PRTL_MO_RT_PRTN_VAL_F');
5300: fnd_message.raise_error;
5301: end if;
5302: --
5303: close c276;

Line 6399: delete from BEN_PRTL_MO_RT_PRTN_VAL_F

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;
6401:
6402: delete from BEN_VRBL_RT_RL_F
6403: where business_group_id = p_bg_id;