APPS.BEN_ORG_DELETE dependencies on BEN_CM_TYP_USG_F

Line 534: is select 1 from BEN_CM_TYP_USG_F

530: is select 1 from BEN_CMBN_PTIP_OPT_F
531: where business_group_id = p_bg_id;
532:
533: cursor c134(p_bg_id NUMBER)
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

Line 3161: -- Testing for values in BEN_CM_TYP_USG_F

3157: --
3158: close c133;
3159:
3160: --
3161: -- Testing for values in BEN_CM_TYP_USG_F
3162: --
3163: open c134(p_bg_id);
3164: --
3165: fetch c134 into l_temp;

Line 3169: fnd_message.set_token('TABLE_NAME','BEN_CM_TYP_USG_F');

3165: fetch c134 into l_temp;
3166: if c134%found then
3167: close c134;
3168: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3169: fnd_message.set_token('TABLE_NAME','BEN_CM_TYP_USG_F');
3170: fnd_message.raise_error;
3171: end if;
3172: --
3173: close c134;

Line 5973: delete from BEN_CM_TYP_USG_F

5969:
5970: delete from BEN_CMBN_PTIP_OPT_F
5971: where business_group_id = p_bg_id;
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;