APPS.HR_NO_UTILITY dependencies on HR_ORGANIZATION_UNITS

Line 316: from hr_organization_units hou, hr_organization_information hoi , hr_lookups lookups

312: 'NO_AGREED_WORKING_HOURS',scl.segment10,null);
313:
314: cursor get_info_from_org is
315: select lookups.meaning
316: from hr_organization_units hou, hr_organization_information hoi , hr_lookups lookups
317: where hou.organization_id = l_organization_id
318: and hou.organization_id = hoi.organization_id
319: and hoi.org_information_context = 'NO_EMPLOYMENT_DEFAULTS'
320: and lookups.lookup_type = l_information_code

Line 331: from hr_organization_units hou , hr_organization_information hoi

327: 'NO_AGREED_WORKING_HOURS',hoi.org_information6,null);
328:
329: cursor is_hr_org is
330: select nvl(hoi.org_information1,'NO_DATA')
331: from hr_organization_units hou , hr_organization_information hoi
332: where hou.organization_id = l_organization_id
333: and hou.organization_id = hoi.organization_id
334: and hoi.org_information_context = 'CLASS'
335: and hoi.org_information1 = 'HR_ORG';

Line 367: from hr_organization_units

363:
364:
365: cursor get_bg_id is
366: select business_group_id
367: from hr_organization_units
368: where organization_id = l_organization_id;
369:
370: cursor get_info_from_scl_awh is
371: select scl.segment10

Line 378: from hr_organization_units hou, hr_organization_information hoi

374:
375:
376: cursor get_info_from_org_awh is
377: select hoi.org_information6
378: from hr_organization_units hou, hr_organization_information hoi
379: where hou.organization_id = l_organization_id
380: and hou.organization_id = hoi.organization_id
381: and hoi.org_information_context = 'NO_EMPLOYMENT_DEFAULTS';
382: