APPS.BEN_ORG_DELETE dependencies on BEN_BNFT_RSTRN_CTFN_F

Line 626: is select 1 from BEN_BNFT_RSTRN_CTFN_F

622: is select 1 from BEN_VRBL_RT_PRFL_F
623: where business_group_id = p_bg_id;
624:
625: cursor c157(p_bg_id NUMBER)
626: is select 1 from BEN_BNFT_RSTRN_CTFN_F
627: where business_group_id = p_bg_id;
628:
629: cursor c158(p_bg_id NUMBER)
630: is select 1 from BEN_BRGNG_UNIT_RT_F

Line 3506: -- Testing for values in BEN_BNFT_RSTRN_CTFN_F

3502: --
3503: close c156;
3504:
3505: --
3506: -- Testing for values in BEN_BNFT_RSTRN_CTFN_F
3507: --
3508: open c157(p_bg_id);
3509: --
3510: fetch c157 into l_temp;

Line 3514: fnd_message.set_token('TABLE_NAME','BEN_BNFT_RSTRN_CTFN_F');

3510: fetch c157 into l_temp;
3511: if c157%found then
3512: close c157;
3513: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3514: fnd_message.set_token('TABLE_NAME','BEN_BNFT_RSTRN_CTFN_F');
3515: fnd_message.raise_error;
3516: end if;
3517: --
3518: close c157;

Line 6042: delete from BEN_BNFT_RSTRN_CTFN_F

6038:
6039: delete from BEN_VRBL_RT_PRFL_F
6040: where business_group_id = p_bg_id;
6041:
6042: delete from BEN_BNFT_RSTRN_CTFN_F
6043: where business_group_id = p_bg_id;
6044:
6045: delete from BEN_BRGNG_UNIT_RT_F
6046: where business_group_id = p_bg_id;