APPS.BEN_ORG_DELETE dependencies on BEN_DSGN_RQMT_F

Line 538: is select 1 from BEN_DSGN_RQMT_F

534: is select 1 from BEN_CM_TYP_USG_F
535: where business_group_id = p_bg_id;
536:
537: cursor c135(p_bg_id NUMBER)
538: is select 1 from BEN_DSGN_RQMT_F
539: where business_group_id = p_bg_id;
540:
541: cursor c136(p_bg_id NUMBER)
542: is select 1 from BEN_ELIG_TO_PRTE_RSN_F

Line 3176: -- Testing for values in BEN_DSGN_RQMT_F

3172: --
3173: close c134;
3174:
3175: --
3176: -- Testing for values in BEN_DSGN_RQMT_F
3177: --
3178: open c135(p_bg_id);
3179: --
3180: fetch c135 into l_temp;

Line 3184: fnd_message.set_token('TABLE_NAME','BEN_DSGN_RQMT_F');

3180: fetch c135 into l_temp;
3181: if c135%found then
3182: close c135;
3183: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3184: fnd_message.set_token('TABLE_NAME','BEN_DSGN_RQMT_F');
3185: fnd_message.raise_error;
3186: end if;
3187: --
3188: close c135;

Line 5976: delete from BEN_DSGN_RQMT_F

5972:
5973: delete from BEN_CM_TYP_USG_F
5974: where business_group_id = p_bg_id;
5975:
5976: delete from BEN_DSGN_RQMT_F
5977: where business_group_id = p_bg_id;
5978:
5979: delete from BEN_ELIG_TO_PRTE_RSN_F
5980: where business_group_id = p_bg_id;