APPS.PER_JP_VALIDATIONS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 264: hr_all_organization_units hou

260: l_dummy VARCHAR2(1);
261: CURSOR cur_org_exists IS
262: select 'X'
263: from hr_organization_information hoi,
264: hr_all_organization_units hou
265: where hou.business_group_id=p_business_group_id
266: and hou.organization_id=p_organization_id
267: -- and to_date(p_effective_date,'DD-MON-YYYY')
268: --between hou.date_from and nvl(hou.date_to,to_date(p_effective_date,'DD-MON-YYYY'))