APPS.BEN_ORG_DELETE dependencies on BEN_ELIG_PRTT_ANTHR_PL_PRTE_F

Line 590: is select 1 from BEN_ELIG_PRTT_ANTHR_PL_PRTE_F

586: is select 1 from BEN_CRT_ORDR
587: where business_group_id = p_bg_id;
588:
589: cursor c148(p_bg_id NUMBER)
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

Line 3371: -- Testing for values in BEN_ELIG_PRTT_ANTHR_PL_PRTE_F

3367: --
3368: close c147;
3369:
3370: --
3371: -- Testing for values in BEN_ELIG_PRTT_ANTHR_PL_PRTE_F
3372: --
3373: open c148(p_bg_id);
3374: --
3375: fetch c148 into l_temp;

Line 3379: fnd_message.set_token('TABLE_NAME','BEN_ELIG_PRTT_ANTHR_PL_PRTE_F');

3375: fetch c148 into l_temp;
3376: if c148%found then
3377: close c148;
3378: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3379: fnd_message.set_token('TABLE_NAME','BEN_ELIG_PRTT_ANTHR_PL_PRTE_F');
3380: fnd_message.raise_error;
3381: end if;
3382: --
3383: close c148;

Line 6015: delete from BEN_ELIG_PRTT_ANTHR_PL_PRTE_F

6011:
6012: delete from BEN_CRT_ORDR
6013: where business_group_id = p_bg_id;
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;