APPS.BEN_ORG_DELETE dependencies on BEN_PRTT_CLM_GD_OR_SVC_TYP

Line 1042: is select 1 from BEN_PRTT_CLM_GD_OR_SVC_TYP

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
1043: where business_group_id = p_bg_id;
1044:
1045: cursor c262(p_bg_id NUMBER)
1046: is select 1 from BEN_ROLL_REIMB_RQST

Line 5066: -- Testing for values in BEN_PRTT_CLM_GD_OR_SVC_TYP

5062: --
5063: close c260;
5064:
5065: --
5066: -- Testing for values in BEN_PRTT_CLM_GD_OR_SVC_TYP
5067: --
5068: open c261(p_bg_id);
5069: --
5070: fetch c261 into l_temp;

Line 5074: fnd_message.set_token('TABLE_NAME','BEN_PRTT_CLM_GD_OR_SVC_TYP');

5070: fetch c261 into l_temp;
5071: if c261%found then
5072: close c261;
5073: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5074: fnd_message.set_token('TABLE_NAME','BEN_PRTT_CLM_GD_OR_SVC_TYP');
5075: fnd_message.raise_error;
5076: end if;
5077: --
5078: close c261;

Line 6354: delete from BEN_PRTT_CLM_GD_OR_SVC_TYP

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;
6356:
6357: delete from BEN_ROLL_REIMB_RQST
6358: where business_group_id = p_bg_id;