APPS.BEN_ORG_DELETE dependencies on BEN_PRTT_ENRT_RSLT_F

Line 810: is select 1 from BEN_PRTT_ENRT_RSLT_F

806: is select 1 from BEN_BENFTS_GRP_RT_F
807: where business_group_id = p_bg_id;
808:
809: cursor c203(p_bg_id NUMBER)
810: is select 1 from BEN_PRTT_ENRT_RSLT_F
811: where business_group_id = p_bg_id;
812:
813: cursor c204(p_bg_id NUMBER)
814: is select 1 from BEN_BNFT_VRBL_RT_F

Line 4196: -- Testing for values in BEN_PRTT_ENRT_RSLT_F

4192: --
4193: close c202;
4194:
4195: --
4196: -- Testing for values in BEN_PRTT_ENRT_RSLT_F
4197: --
4198: open c203(p_bg_id);
4199: --
4200: fetch c203 into l_temp;

Line 4204: fnd_message.set_token('TABLE_NAME','BEN_PRTT_ENRT_RSLT_F');

4200: fetch c203 into l_temp;
4201: if c203%found then
4202: close c203;
4203: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4204: fnd_message.set_token('TABLE_NAME','BEN_PRTT_ENRT_RSLT_F');
4205: fnd_message.raise_error;
4206: end if;
4207: --
4208: close c203;

Line 6180: delete from BEN_PRTT_ENRT_RSLT_F

6176:
6177: delete from BEN_BENFTS_GRP_RT_F
6178: where business_group_id = p_bg_id;
6179:
6180: delete from BEN_PRTT_ENRT_RSLT_F
6181: where business_group_id = p_bg_id;
6182:
6183: delete from BEN_BNFT_VRBL_RT_F
6184: where business_group_id = p_bg_id;