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_DK_UTILITY dependencies on HR_LOOKUPS

Line 371: from HR_SOFT_CODING_KEYFLEX scl, hr_lookups lookups

367: where assignment_id = p_assignment_id;
368:
369: cursor get_info_from_scl is
370: select lookups.meaning
371: from HR_SOFT_CODING_KEYFLEX scl, hr_lookups lookups
372: where scl.SOFT_CODING_KEYFLEX_ID = l_scl_id
373: and lookups.lookup_type=l_information_code
374: and lookups.enabled_flag = 'Y'
375: and lookups.lookup_code = decode(l_information_code,'DK_COND_OF_EMP',scl.segment3,

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

376: 'DK_EMP_GROUP',scl.segment4,NULL);
377:
378: cursor get_info_from_org is
379: select lookups.meaning
380: from hr_organization_units hou, hr_organization_information hoi , hr_lookups lookups
381: where hou.organization_id = l_organization_id
382: and hou.organization_id = hoi.organization_id
383: and hoi.org_information_context = 'DK_EMPLOYMENT_DEFAULTS'
384: and lookups.lookup_type = l_information_code

Line 397: from hr_organization_information hoi , hr_lookups lookups

393:
394:
395: cursor get_info_from_legal_employer is
396: select lookups.meaning
397: from hr_organization_information hoi , hr_lookups lookups
398: where hoi.organization_id = l_org_id
399: and hoi.org_information_context = 'DK_EMPLOYMENT_DEFAULTS'
400: and lookups.lookup_type = l_information_code
401: and lookups.enabled_flag = 'Y'