APPS.BEN_ORG_DELETE dependencies on BEN_PRTT_REIMBMT_RECON

Line 1142: is select 1 from BEN_PRTT_REIMBMT_RECON

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
1143: where business_group_id = p_bg_id;
1144:
1145: cursor c287(p_bg_id NUMBER)
1146: is select 1 from BEN_ELIG_LOA_RSN_PRTE_F

Line 5441: -- Testing for values in BEN_PRTT_REIMBMT_RECON

5437: --
5438: close c285;
5439:
5440: --
5441: -- Testing for values in BEN_PRTT_REIMBMT_RECON
5442: --
5443: open c286(p_bg_id);
5444: --
5445: fetch c286 into l_temp;

Line 5449: fnd_message.set_token('TABLE_NAME','BEN_PRTT_REIMBMT_RECON');

5445: fetch c286 into l_temp;
5446: if c286%found then
5447: close c286;
5448: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5449: fnd_message.set_token('TABLE_NAME','BEN_PRTT_REIMBMT_RECON');
5450: fnd_message.raise_error;
5451: end if;
5452: --
5453: close c286;

Line 6429: delete from BEN_PRTT_REIMBMT_RECON

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;
6431:
6432: delete from BEN_ELIG_LOA_RSN_PRTE_F
6433: where business_group_id = p_bg_id;