APPS.BEN_ORG_DELETE dependencies on BEN_LER_CHG_PGM_ENRT_F

Line 546: is select 1 from BEN_LER_CHG_PGM_ENRT_F

542: is select 1 from BEN_ELIG_TO_PRTE_RSN_F
543: where business_group_id = p_bg_id;
544:
545: cursor c137(p_bg_id NUMBER)
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

Line 3206: -- Testing for values in BEN_LER_CHG_PGM_ENRT_F

3202: --
3203: close c136;
3204:
3205: --
3206: -- Testing for values in BEN_LER_CHG_PGM_ENRT_F
3207: --
3208: open c137(p_bg_id);
3209: --
3210: fetch c137 into l_temp;

Line 3214: fnd_message.set_token('TABLE_NAME','BEN_LER_CHG_PGM_ENRT_F');

3210: fetch c137 into l_temp;
3211: if c137%found then
3212: close c137;
3213: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3214: fnd_message.set_token('TABLE_NAME','BEN_LER_CHG_PGM_ENRT_F');
3215: fnd_message.raise_error;
3216: end if;
3217: --
3218: close c137;

Line 5982: delete from BEN_LER_CHG_PGM_ENRT_F

5978:
5979: delete from BEN_ELIG_TO_PRTE_RSN_F
5980: where business_group_id = p_bg_id;
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;