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 357: ,hr_organization_information hoi

353: --
354: CURSOR csr_get_name(p_organization_id NUMBER) IS
355: SELECT hoi1.org_information14
356: FROM hr_organization_units hou
357: ,hr_organization_information hoi
358: ,hr_organization_information hoi1
359: WHERE hou.organization_id = hoi.organization_id
360: AND hou.organization_id = hoi1.organization_id(+)
361: AND hou.organization_id = p_organization_id

Line 358: ,hr_organization_information hoi1

354: CURSOR csr_get_name(p_organization_id NUMBER) IS
355: SELECT hoi1.org_information14
356: FROM hr_organization_units hou
357: ,hr_organization_information hoi
358: ,hr_organization_information hoi1
359: WHERE hou.organization_id = hoi.organization_id
360: AND hou.organization_id = hoi1.organization_id(+)
361: AND hou.organization_id = p_organization_id
362: AND hoi.org_information_context = 'CLASS'

Line 365: l_name hr_organization_information.org_information14%TYPE;

361: AND hou.organization_id = p_organization_id
362: AND hoi.org_information_context = 'CLASS'
363: AND hoi1.org_information_context(+) = 'NL_ORG_INFORMATION';
364: --
365: l_name hr_organization_information.org_information14%TYPE;
366: l_legal_emplr_id NUMBER(15);
367: --
368: BEGIN
369: --