APPS.BEN_ORG_DELETE dependencies on BEN_CMBN_PTIP_OPT_F

Line 530: is select 1 from BEN_CMBN_PTIP_OPT_F

526: is select 1 from BEN_CMBN_PTIP_F
527: where business_group_id = p_bg_id;
528:
529: cursor c133(p_bg_id NUMBER)
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

Line 3146: -- Testing for values in BEN_CMBN_PTIP_OPT_F

3142: --
3143: close c132;
3144:
3145: --
3146: -- Testing for values in BEN_CMBN_PTIP_OPT_F
3147: --
3148: open c133(p_bg_id);
3149: --
3150: fetch c133 into l_temp;

Line 3154: fnd_message.set_token('TABLE_NAME','BEN_CMBN_PTIP_OPT_F');

3150: fetch c133 into l_temp;
3151: if c133%found then
3152: close c133;
3153: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3154: fnd_message.set_token('TABLE_NAME','BEN_CMBN_PTIP_OPT_F');
3155: fnd_message.raise_error;
3156: end if;
3157: --
3158: close c133;

Line 5970: delete from BEN_CMBN_PTIP_OPT_F

5966:
5967: delete from BEN_CMBN_PTIP_F
5968: where business_group_id = p_bg_id;
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;