APPS.BEN_ORG_DELETE dependencies on BEN_ROLL_REIMB_RQST

Line 1046: is select 1 from BEN_ROLL_REIMB_RQST

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
1047: where business_group_id = p_bg_id;
1048:
1049: cursor c263(p_bg_id NUMBER)
1050: is select 1 from BEN_ELIG_EE_STAT_PRTE_F

Line 5081: -- Testing for values in BEN_ROLL_REIMB_RQST

5077: --
5078: close c261;
5079:
5080: --
5081: -- Testing for values in BEN_ROLL_REIMB_RQST
5082: --
5083: open c262(p_bg_id);
5084: --
5085: fetch c262 into l_temp;

Line 5089: fnd_message.set_token('TABLE_NAME','BEN_ROLL_REIMB_RQST');

5085: fetch c262 into l_temp;
5086: if c262%found then
5087: close c262;
5088: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5089: fnd_message.set_token('TABLE_NAME','BEN_ROLL_REIMB_RQST');
5090: fnd_message.raise_error;
5091: end if;
5092: --
5093: close c262;

Line 6357: delete from BEN_ROLL_REIMB_RQST

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;
6359:
6360: delete from BEN_ELIG_EE_STAT_PRTE_F
6361: where business_group_id = p_bg_id;