APPS.BEN_ORG_DELETE dependencies on BEN_PRTT_REIMBMT_RQST_F

Line 1038: is select 1 from BEN_PRTT_REIMBMT_RQST_F

1034: is select 1 from BEN_PER_CM_PRVDD_F
1035: where business_group_id = p_bg_id;
1036:
1037: cursor c260(p_bg_id NUMBER)
1038: is select 1 from BEN_PRTT_REIMBMT_RQST_F
1039: where business_group_id = p_bg_id;
1040:
1041: cursor c261(p_bg_id NUMBER)
1042: is select 1 from BEN_PRTT_CLM_GD_OR_SVC_TYP

Line 5051: -- Testing for values in BEN_PRTT_REIMBMT_RQST_F

5047: --
5048: close c259;
5049:
5050: --
5051: -- Testing for values in BEN_PRTT_REIMBMT_RQST_F
5052: --
5053: open c260(p_bg_id);
5054: --
5055: fetch c260 into l_temp;

Line 5059: fnd_message.set_token('TABLE_NAME','BEN_PRTT_REIMBMT_RQST_F');

5055: fetch c260 into l_temp;
5056: if c260%found then
5057: close c260;
5058: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5059: fnd_message.set_token('TABLE_NAME','BEN_PRTT_REIMBMT_RQST_F');
5060: fnd_message.raise_error;
5061: end if;
5062: --
5063: close c260;

Line 6351: delete from BEN_PRTT_REIMBMT_RQST_F

6347:
6348: delete from BEN_PER_CM_PRVDD_F
6349: where business_group_id = p_bg_id;
6350:
6351: delete from BEN_PRTT_REIMBMT_RQST_F
6352: where business_group_id = p_bg_id;
6353:
6354: delete from BEN_PRTT_CLM_GD_OR_SVC_TYP
6355: where business_group_id = p_bg_id;