DBA Data[Home] [Help]

APPS.PQP_GB_TP_EXT_PROCESS dependencies on HR_ORGANIZATION_UNITS_V

Line 1652: FROM hr_organization_units_v org

1648: CURSOR csr_location_code IS
1649: SELECT loc.location_code
1650: ,loc.location_id
1651: ,lei.lei_information6 lea_number
1652: FROM hr_organization_units_v org
1653: ,hr_locations_all loc
1654: ,hr_location_extra_info lei
1655: WHERE org.organization_id = p_organization_id
1656: AND loc.location_id = org.location_id