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.PAY_NL_NWR_XML_EXTRACT_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 411: ,hr_organization_information hoi

407: --
408: CURSOR csr_get_name(p_organization_id NUMBER) IS
409: SELECT hoi1.org_information14
410: FROM hr_organization_units hou
411: ,hr_organization_information hoi
412: ,hr_organization_information hoi1
413: WHERE hou.organization_id = hoi.organization_id
414: AND hou.organization_id = hoi1.organization_id(+)
415: AND hou.organization_id = p_organization_id

Line 412: ,hr_organization_information hoi1

408: CURSOR csr_get_name(p_organization_id NUMBER) IS
409: SELECT hoi1.org_information14
410: FROM hr_organization_units hou
411: ,hr_organization_information hoi
412: ,hr_organization_information hoi1
413: WHERE hou.organization_id = hoi.organization_id
414: AND hou.organization_id = hoi1.organization_id(+)
415: AND hou.organization_id = p_organization_id
416: AND hoi.org_information_context = 'CLASS'

Line 419: l_name hr_organization_information.org_information14%TYPE;

415: AND hou.organization_id = p_organization_id
416: AND hoi.org_information_context = 'CLASS'
417: AND hoi1.org_information_context(+) = 'NL_ORG_INFORMATION';
418: --
419: l_name hr_organization_information.org_information14%TYPE;
420: l_legal_emplr_id NUMBER(15);
421: --
422: BEGIN
423: --