APPS.HR_NO_UTILITY dependencies on HR_ORGANIZATION_INFORMATION

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

385:
386:
387: cursor get_info_from_local_unit is
388: select lookups.meaning
389: from hr_organization_information hoi , hr_lookups lookups
390: where hoi.organization_id = l_org_id
391: and hoi.org_information_context = 'NO_EMPLOYMENT_DEFAULTS'
392: and lookups.lookup_type = l_information_code
393: and lookups.enabled_flag = 'Y'

Line 403: from hr_organization_information hoi1 , hr_organization_information hoi2

399: 'NO_AGREED_WORKING_HOURS',hoi.org_information6,null);
400:
401: cursor get_legal_employer is
402: select hoi2.organization_id
403: from hr_organization_information hoi1 , hr_organization_information hoi2
404: where hoi1.org_information1 = to_char(l_local_unit) and hoi1.org_information_context = 'NO_LOCAL_UNITS'
405: and hoi2.org_information_context = 'CLASS' and hoi2.org_information1 = 'HR_LEGAL_EMPLOYER'
406: and hoi2.organization_id = hoi1.organization_id;
407:

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:

Line 430: from hr_organization_information hoi

426:
427:
428: cursor get_info_from_local_unit_awh is
429: select hoi.org_information6
430: from hr_organization_information hoi
431: where hoi.organization_id = l_org_id
432: and hoi.org_information_context = 'NO_EMPLOYMENT_DEFAULTS';
433:
434: