APPS.BEN_ORG_DELETE dependencies on BEN_ENRT_CTFN_F

Line 594: is select 1 from BEN_ENRT_CTFN_F

590: is select 1 from BEN_ELIG_PRTT_ANTHR_PL_PRTE_F
591: where business_group_id = p_bg_id;
592:
593: cursor c149(p_bg_id NUMBER)
594: is select 1 from BEN_ENRT_CTFN_F
595: where business_group_id = p_bg_id;
596:
597: cursor c150(p_bg_id NUMBER)
598: is select 1 from BEN_LEE_RSN_F

Line 3386: -- Testing for values in BEN_ENRT_CTFN_F

3382: --
3383: close c148;
3384:
3385: --
3386: -- Testing for values in BEN_ENRT_CTFN_F
3387: --
3388: open c149(p_bg_id);
3389: --
3390: fetch c149 into l_temp;

Line 3394: fnd_message.set_token('TABLE_NAME','BEN_ENRT_CTFN_F');

3390: fetch c149 into l_temp;
3391: if c149%found then
3392: close c149;
3393: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3394: fnd_message.set_token('TABLE_NAME','BEN_ENRT_CTFN_F');
3395: fnd_message.raise_error;
3396: end if;
3397: --
3398: close c149;

Line 6018: delete from BEN_ENRT_CTFN_F

6014:
6015: delete from BEN_ELIG_PRTT_ANTHR_PL_PRTE_F
6016: where business_group_id = p_bg_id;
6017:
6018: delete from BEN_ENRT_CTFN_F
6019: where business_group_id = p_bg_id;
6020:
6021: delete from BEN_LEE_RSN_F
6022: where business_group_id = p_bg_id;