APPS.BEN_ORG_DELETE dependencies on BEN_ENRT_RT

Line 1138: is select 1 from BEN_ENRT_RT

1134: is select 1 from BEN_PRTT_VSTG_F
1135: where business_group_id = p_bg_id;
1136:
1137: cursor c285(p_bg_id NUMBER)
1138: is select 1 from BEN_ENRT_RT
1139: where business_group_id = p_bg_id;
1140:
1141: cursor c286(p_bg_id NUMBER)
1142: is select 1 from BEN_PRTT_REIMBMT_RECON

Line 5426: -- Testing for values in BEN_ENRT_RT

5422: --
5423: close c284;
5424:
5425: --
5426: -- Testing for values in BEN_ENRT_RT
5427: --
5428: open c285(p_bg_id);
5429: --
5430: fetch c285 into l_temp;

Line 5434: fnd_message.set_token('TABLE_NAME','BEN_ENRT_RT');

5430: fetch c285 into l_temp;
5431: if c285%found then
5432: close c285;
5433: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5434: fnd_message.set_token('TABLE_NAME','BEN_ENRT_RT');
5435: fnd_message.raise_error;
5436: end if;
5437: --
5438: close c285;

Line 6426: delete from BEN_ENRT_RT

6422:
6423: delete from BEN_PRTT_VSTG_F
6424: where business_group_id = p_bg_id;
6425:
6426: delete from BEN_ENRT_RT
6427: where business_group_id = p_bg_id;
6428:
6429: delete from BEN_PRTT_REIMBMT_RECON
6430: where business_group_id = p_bg_id;