APPS.BEN_ORG_DELETE dependencies on BEN_PL_DPNT_CVG_CTFN_F

Line 554: is select 1 from BEN_PL_DPNT_CVG_CTFN_F

550: is select 1 from BEN_PL_BNF_CTFN_F
551: where business_group_id = p_bg_id;
552:
553: cursor c139(p_bg_id NUMBER)
554: is select 1 from BEN_PL_DPNT_CVG_CTFN_F
555: where business_group_id = p_bg_id;
556:
557: cursor c140(p_bg_id NUMBER)
558: is select 1 from BEN_PL_GD_OR_SVC_F

Line 3236: -- Testing for values in BEN_PL_DPNT_CVG_CTFN_F

3232: --
3233: close c138;
3234:
3235: --
3236: -- Testing for values in BEN_PL_DPNT_CVG_CTFN_F
3237: --
3238: open c139(p_bg_id);
3239: --
3240: fetch c139 into l_temp;

Line 3244: fnd_message.set_token('TABLE_NAME','BEN_PL_DPNT_CVG_CTFN_F');

3240: fetch c139 into l_temp;
3241: if c139%found then
3242: close c139;
3243: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3244: fnd_message.set_token('TABLE_NAME','BEN_PL_DPNT_CVG_CTFN_F');
3245: fnd_message.raise_error;
3246: end if;
3247: --
3248: close c139;

Line 5988: delete from BEN_PL_DPNT_CVG_CTFN_F

5984:
5985: delete from BEN_PL_BNF_CTFN_F
5986: where business_group_id = p_bg_id;
5987:
5988: delete from BEN_PL_DPNT_CVG_CTFN_F
5989: where business_group_id = p_bg_id;
5990:
5991: delete from BEN_PL_GD_OR_SVC_F
5992: where business_group_id = p_bg_id;