APPS.BEN_ORG_DELETE dependencies on BEN_PYRL_RT_F

Line 678: is select 1 from BEN_PYRL_RT_F

674: is select 1 from BEN_PSTL_ZIP_RT_F
675: where business_group_id = p_bg_id;
676:
677: cursor c170(p_bg_id NUMBER)
678: is select 1 from BEN_PYRL_RT_F
679: where business_group_id = p_bg_id;
680:
681: cursor c171(p_bg_id NUMBER)
682: is select 1 from BEN_SCHEDD_HRS_RT_F

Line 3701: -- Testing for values in BEN_PYRL_RT_F

3697: --
3698: close c169;
3699:
3700: --
3701: -- Testing for values in BEN_PYRL_RT_F
3702: --
3703: open c170(p_bg_id);
3704: --
3705: fetch c170 into l_temp;

Line 3709: fnd_message.set_token('TABLE_NAME','BEN_PYRL_RT_F');

3705: fetch c170 into l_temp;
3706: if c170%found then
3707: close c170;
3708: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3709: fnd_message.set_token('TABLE_NAME','BEN_PYRL_RT_F');
3710: fnd_message.raise_error;
3711: end if;
3712: --
3713: close c170;

Line 6081: delete from BEN_PYRL_RT_F

6077:
6078: delete from BEN_PSTL_ZIP_RT_F
6079: where business_group_id = p_bg_id;
6080:
6081: delete from BEN_PYRL_RT_F
6082: where business_group_id = p_bg_id;
6083:
6084: delete from BEN_SCHEDD_HRS_RT_F
6085: where business_group_id = p_bg_id;