APPS.HR_NO_UTILITY dependencies on HR_ORGANIZATION_UNITS

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

356: 'NO_AGREED_WORKING_HOURS',scl.segment10,null);
357:
358: cursor get_info_from_org is
359: select lookups.meaning
360: from hr_organization_units hou, hr_organization_information hoi , hr_lookups lookups
361: where hou.organization_id = l_organization_id
362: and hou.organization_id = hoi.organization_id
363: and hoi.org_information_context = 'NO_EMPLOYMENT_DEFAULTS'
364: and lookups.lookup_type = l_information_code

Line 375: from hr_organization_units hou , hr_organization_information hoi

371: 'NO_AGREED_WORKING_HOURS',hoi.org_information6,null);
372:
373: cursor is_hr_org is
374: select nvl(hoi.org_information1,'NO_DATA')
375: from hr_organization_units hou , hr_organization_information hoi
376: where hou.organization_id = l_organization_id
377: and hou.organization_id = hoi.organization_id
378: and hoi.org_information_context = 'CLASS'
379: and hoi.org_information1 = 'HR_ORG';

Line 411: from hr_organization_units

407:
408:
409: cursor get_bg_id is
410: select business_group_id
411: from hr_organization_units
412: where organization_id = l_organization_id;
413:
414: cursor get_info_from_scl_awh is
415: select scl.segment10

Line 422: from hr_organization_units hou, hr_organization_information hoi

418:
419:
420: cursor get_info_from_org_awh is
421: select hoi.org_information6
422: from hr_organization_units hou, hr_organization_information hoi
423: where hou.organization_id = l_organization_id
424: and hou.organization_id = hoi.organization_id
425: and hoi.org_information_context = 'NO_EMPLOYMENT_DEFAULTS';
426: