APPS.BEN_ORG_DELETE dependencies on BEN_PL_BNF_CTFN_F

Line 550: is select 1 from BEN_PL_BNF_CTFN_F

546: is select 1 from BEN_LER_CHG_PGM_ENRT_F
547: where business_group_id = p_bg_id;
548:
549: cursor c138(p_bg_id NUMBER)
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

Line 3221: -- Testing for values in BEN_PL_BNF_CTFN_F

3217: --
3218: close c137;
3219:
3220: --
3221: -- Testing for values in BEN_PL_BNF_CTFN_F
3222: --
3223: open c138(p_bg_id);
3224: --
3225: fetch c138 into l_temp;

Line 3229: fnd_message.set_token('TABLE_NAME','BEN_PL_BNF_CTFN_F');

3225: fetch c138 into l_temp;
3226: if c138%found then
3227: close c138;
3228: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3229: fnd_message.set_token('TABLE_NAME','BEN_PL_BNF_CTFN_F');
3230: fnd_message.raise_error;
3231: end if;
3232: --
3233: close c138;

Line 5985: delete from BEN_PL_BNF_CTFN_F

5981:
5982: delete from BEN_LER_CHG_PGM_ENRT_F
5983: where business_group_id = p_bg_id;
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;