APPS.BEN_ORG_DELETE dependencies on BEN_CMBN_PLIP_F

Line 522: is select 1 from BEN_CMBN_PLIP_F

518: is select 1 from BEN_BNFT_PRVDR_POOL_F
519: where business_group_id = p_bg_id;
520:
521: cursor c131(p_bg_id NUMBER)
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

Line 3116: -- Testing for values in BEN_CMBN_PLIP_F

3112: --
3113: close c130;
3114:
3115: --
3116: -- Testing for values in BEN_CMBN_PLIP_F
3117: --
3118: open c131(p_bg_id);
3119: --
3120: fetch c131 into l_temp;

Line 3124: fnd_message.set_token('TABLE_NAME','BEN_CMBN_PLIP_F');

3120: fetch c131 into l_temp;
3121: if c131%found then
3122: close c131;
3123: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3124: fnd_message.set_token('TABLE_NAME','BEN_CMBN_PLIP_F');
3125: fnd_message.raise_error;
3126: end if;
3127: --
3128: close c131;

Line 5964: delete from BEN_CMBN_PLIP_F

5960:
5961: delete from BEN_BNFT_PRVDR_POOL_F
5962: where business_group_id = p_bg_id;
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;