APPS.PER_JP_VALIDATIONS dependencies on HR_ORGANIZATION_INFORMATION

Line 263: from hr_organization_information hoi,

259: l_found BOOLEAN := FALSE;
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')