APPS.BEN_ORG_DELETE dependencies on BEN_VRBL_RT_PRFL_F

Line 622: is select 1 from BEN_VRBL_RT_PRFL_F

618: is select 1 from BEN_VALD_RLSHP_FOR_REIMB_F
619: where business_group_id = p_bg_id;
620:
621: cursor c156(p_bg_id NUMBER)
622: is select 1 from BEN_VRBL_RT_PRFL_F
623: where business_group_id = p_bg_id;
624:
625: cursor c157(p_bg_id NUMBER)
626: is select 1 from BEN_BNFT_RSTRN_CTFN_F

Line 3491: -- Testing for values in BEN_VRBL_RT_PRFL_F

3487: --
3488: close c155;
3489:
3490: --
3491: -- Testing for values in BEN_VRBL_RT_PRFL_F
3492: --
3493: open c156(p_bg_id);
3494: --
3495: fetch c156 into l_temp;

Line 3499: fnd_message.set_token('TABLE_NAME','BEN_VRBL_RT_PRFL_F');

3495: fetch c156 into l_temp;
3496: if c156%found then
3497: close c156;
3498: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3499: fnd_message.set_token('TABLE_NAME','BEN_VRBL_RT_PRFL_F');
3500: fnd_message.raise_error;
3501: end if;
3502: --
3503: close c156;

Line 6039: delete from BEN_VRBL_RT_PRFL_F

6035:
6036: delete from BEN_VALD_RLSHP_FOR_REIMB_F
6037: where business_group_id = p_bg_id;
6038:
6039: delete from BEN_VRBL_RT_PRFL_F
6040: where business_group_id = p_bg_id;
6041:
6042: delete from BEN_BNFT_RSTRN_CTFN_F
6043: where business_group_id = p_bg_id;