APPS.BEN_ORG_DELETE dependencies on BEN_CMBN_PTIP_F

Line 526: is select 1 from BEN_CMBN_PTIP_F

522: is select 1 from BEN_CMBN_PLIP_F
523: where business_group_id = p_bg_id;
524:
525: cursor c132(p_bg_id NUMBER)
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

Line 3131: -- Testing for values in BEN_CMBN_PTIP_F

3127: --
3128: close c131;
3129:
3130: --
3131: -- Testing for values in BEN_CMBN_PTIP_F
3132: --
3133: open c132(p_bg_id);
3134: --
3135: fetch c132 into l_temp;

Line 3139: fnd_message.set_token('TABLE_NAME','BEN_CMBN_PTIP_F');

3135: fetch c132 into l_temp;
3136: if c132%found then
3137: close c132;
3138: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3139: fnd_message.set_token('TABLE_NAME','BEN_CMBN_PTIP_F');
3140: fnd_message.raise_error;
3141: end if;
3142: --
3143: close c132;

Line 5967: delete from BEN_CMBN_PTIP_F

5963:
5964: delete from BEN_CMBN_PLIP_F
5965: where business_group_id = p_bg_id;
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;