DBA Data[Home] [Help]

APPS.PQP_GB_TP_EXT_PROCESS dependencies on HR_ORGANIZATION_UNITS_V

Line 1662: FROM hr_organization_units_v org

1658: CURSOR csr_location_code IS
1659: SELECT loc.location_code
1660: ,loc.location_id
1661: ,lei.lei_information6 lea_number
1662: FROM hr_organization_units_v org
1663: ,hr_locations_all loc
1664: ,hr_location_extra_info lei
1665: WHERE org.organization_id = p_organization_id
1666: AND loc.location_id = org.location_id