DBA Data[Home] [Help]

APPS.PAY_NL_NWR_XML_EXTRACT_PKG dependencies on HR_ORGANIZATION_UNITS

Line 356: FROM hr_organization_units hou

352: FUNCTION get_le_name(p_payroll_action_id NUMBER) RETURN VARCHAR2 AS
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(+)