APPS.BEN_ORG_DELETE dependencies on BEN_ELIG_TO_PRTE_RSN_F

Line 542: is select 1 from BEN_ELIG_TO_PRTE_RSN_F

538: is select 1 from BEN_DSGN_RQMT_F
539: where business_group_id = p_bg_id;
540:
541: cursor c136(p_bg_id NUMBER)
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

Line 3191: -- Testing for values in BEN_ELIG_TO_PRTE_RSN_F

3187: --
3188: close c135;
3189:
3190: --
3191: -- Testing for values in BEN_ELIG_TO_PRTE_RSN_F
3192: --
3193: open c136(p_bg_id);
3194: --
3195: fetch c136 into l_temp;

Line 3199: fnd_message.set_token('TABLE_NAME','BEN_ELIG_TO_PRTE_RSN_F');

3195: fetch c136 into l_temp;
3196: if c136%found then
3197: close c136;
3198: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3199: fnd_message.set_token('TABLE_NAME','BEN_ELIG_TO_PRTE_RSN_F');
3200: fnd_message.raise_error;
3201: end if;
3202: --
3203: close c136;

Line 5979: delete from BEN_ELIG_TO_PRTE_RSN_F

5975:
5976: delete from BEN_DSGN_RQMT_F
5977: where business_group_id = p_bg_id;
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;