APPS.BEN_ORG_DELETE dependencies on BEN_ELIG_EE_STAT_PRTE_F

Line 1050: is select 1 from BEN_ELIG_EE_STAT_PRTE_F

1046: is select 1 from BEN_ROLL_REIMB_RQST
1047: where business_group_id = p_bg_id;
1048:
1049: cursor c263(p_bg_id NUMBER)
1050: is select 1 from BEN_ELIG_EE_STAT_PRTE_F
1051: where business_group_id = p_bg_id;
1052:
1053: cursor c264(p_bg_id NUMBER)
1054: is select 1 from BEN_EE_STAT_RT_F

Line 5096: -- Testing for values in BEN_ELIG_EE_STAT_PRTE_F

5092: --
5093: close c262;
5094:
5095: --
5096: -- Testing for values in BEN_ELIG_EE_STAT_PRTE_F
5097: --
5098: open c263(p_bg_id);
5099: --
5100: fetch c263 into l_temp;

Line 5104: fnd_message.set_token('TABLE_NAME','BEN_ELIG_EE_STAT_PRTE_F');

5100: fetch c263 into l_temp;
5101: if c263%found then
5102: close c263;
5103: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5104: fnd_message.set_token('TABLE_NAME','BEN_ELIG_EE_STAT_PRTE_F');
5105: fnd_message.raise_error;
5106: end if;
5107: --
5108: close c263;

Line 6360: delete from BEN_ELIG_EE_STAT_PRTE_F

6356:
6357: delete from BEN_ROLL_REIMB_RQST
6358: where business_group_id = p_bg_id;
6359:
6360: delete from BEN_ELIG_EE_STAT_PRTE_F
6361: where business_group_id = p_bg_id;
6362:
6363: delete from BEN_EE_STAT_RT_F
6364: where business_group_id = p_bg_id;