APPS.HR_NO_UTILITY dependencies on HR_ORGANIZATION_INFORMATION

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 345: from hr_organization_information hoi , hr_lookups lookups

341:
342:
343: cursor get_info_from_local_unit is
344: select lookups.meaning
345: from hr_organization_information hoi , hr_lookups lookups
346: where hoi.organization_id = l_org_id
347: and hoi.org_information_context = 'NO_EMPLOYMENT_DEFAULTS'
348: and lookups.lookup_type = l_information_code
349: and lookups.enabled_flag = 'Y'

Line 359: from hr_organization_information hoi1 , hr_organization_information hoi2

355: 'NO_AGREED_WORKING_HOURS',hoi.org_information6,null);
356:
357: cursor get_legal_employer is
358: select hoi2.organization_id
359: from hr_organization_information hoi1 , hr_organization_information hoi2
360: where hoi1.org_information1 = to_char(l_local_unit) and hoi1.org_information_context = 'NO_LOCAL_UNITS'
361: and hoi2.org_information_context = 'CLASS' and hoi2.org_information1 = 'HR_LEGAL_EMPLOYER'
362: and hoi2.organization_id = hoi1.organization_id;
363:

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:

Line 386: from hr_organization_information hoi

382:
383:
384: cursor get_info_from_local_unit_awh is
385: select hoi.org_information6
386: from hr_organization_information hoi
387: where hoi.organization_id = l_org_id
388: and hoi.org_information_context = 'NO_EMPLOYMENT_DEFAULTS';
389:
390: