APPS.BEN_ORG_DELETE dependencies on BEN_GRADE_RT_F

Line 730: is select 1 from BEN_GRADE_RT_F

726: is select 1 from BEN_GNDR_RT_F
727: where business_group_id = p_bg_id;
728:
729: cursor c183(p_bg_id NUMBER)
730: is select 1 from BEN_GRADE_RT_F
731: where business_group_id = p_bg_id;
732:
733: cursor c184(p_bg_id NUMBER)
734: is select 1 from BEN_HRLY_SLRD_RT_F

Line 3896: -- Testing for values in BEN_GRADE_RT_F

3892: --
3893: close c182;
3894:
3895: --
3896: -- Testing for values in BEN_GRADE_RT_F
3897: --
3898: open c183(p_bg_id);
3899: --
3900: fetch c183 into l_temp;

Line 3904: fnd_message.set_token('TABLE_NAME','BEN_GRADE_RT_F');

3900: fetch c183 into l_temp;
3901: if c183%found then
3902: close c183;
3903: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3904: fnd_message.set_token('TABLE_NAME','BEN_GRADE_RT_F');
3905: fnd_message.raise_error;
3906: end if;
3907: --
3908: close c183;

Line 6120: delete from BEN_GRADE_RT_F

6116:
6117: delete from BEN_GNDR_RT_F
6118: where business_group_id = p_bg_id;
6119:
6120: delete from BEN_GRADE_RT_F
6121: where business_group_id = p_bg_id;
6122:
6123: delete from BEN_HRLY_SLRD_RT_F
6124: where business_group_id = p_bg_id;