eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_NO_UTILITY dependencies on HR_LOOKUPS

Line 347: from HR_SOFT_CODING_KEYFLEX scl, hr_lookups lookups

343: where assignment_id = p_assignment_id;
344:
345: cursor get_info_from_scl is
346: select lookups.meaning
347: from HR_SOFT_CODING_KEYFLEX scl, hr_lookups lookups
348: where scl.SOFT_CODING_KEYFLEX_ID = l_scl_id
349: and lookups.lookup_type=l_information_code
350: and lookups.enabled_flag = 'Y'
351: and lookups.lookup_code = decode(l_information_code,'NO_JOB_STATUS',scl.segment5,

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 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'