DBA Data[Home] [Help]

APPS.PAY_NL_NWR_XML_EXTRACT_PKG dependencies on HR_ORGANIZATION_UNITS

Line 410: FROM hr_organization_units hou

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