APPS.BEN_ORG_DELETE dependencies on BEN_LOA_RSN_RT_F

Line 1150: is select 1 from BEN_LOA_RSN_RT_F

1146: is select 1 from BEN_ELIG_LOA_RSN_PRTE_F
1147: where business_group_id = p_bg_id;
1148:
1149: cursor c288(p_bg_id NUMBER)
1150: is select 1 from BEN_LOA_RSN_RT_F
1151: where business_group_id = p_bg_id;
1152:
1153: cursor c289(p_bg_id NUMBER)
1154: is select 1 from BEN_ELIG_PY_BSS_PRTE_F

Line 5471: -- Testing for values in BEN_LOA_RSN_RT_F

5467: --
5468: close c287;
5469:
5470: --
5471: -- Testing for values in BEN_LOA_RSN_RT_F
5472: --
5473: open c288(p_bg_id);
5474: --
5475: fetch c288 into l_temp;

Line 5479: fnd_message.set_token('TABLE_NAME','BEN_LOA_RSN_RT_F');

5475: fetch c288 into l_temp;
5476: if c288%found then
5477: close c288;
5478: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5479: fnd_message.set_token('TABLE_NAME','BEN_LOA_RSN_RT_F');
5480: fnd_message.raise_error;
5481: end if;
5482: --
5483: close c288;

Line 6435: delete from BEN_LOA_RSN_RT_F

6431:
6432: delete from BEN_ELIG_LOA_RSN_PRTE_F
6433: where business_group_id = p_bg_id;
6434:
6435: delete from BEN_LOA_RSN_RT_F
6436: where business_group_id = p_bg_id;
6437:
6438: delete from BEN_ELIG_PY_BSS_PRTE_F
6439: where business_group_id = p_bg_id;