APPS.ZX_EXTRACT_PKG dependencies on HR_ORGANIZATION_UNITS

Line 2199: l_rep_context_name HR_ORGANIZATION_UNITS.name%TYPE;

2195: l_request_id NUMBER;
2196: l_rep_entity_id NUMBER;
2197: l_rep_context_tax_reg_no HR_ORGANIZATION_INFORMATION.org_information2%TYPE;
2198: l_rep_context_loc_id HR_LOCATIONS_ALL.location_id%TYPE;
2199: l_rep_context_name HR_ORGANIZATION_UNITS.name%TYPE;
2200: l_rep_context_city HR_LOCATIONS_ALL.town_or_city%TYPE;
2201: l_rep_context_county HR_LOCATIONS_ALL.region_3%TYPE;
2202: l_rep_context_state HR_LOCATIONS_ALL.region_2%TYPE;
2203: l_rep_context_province HR_LOCATIONS_ALL.region_1%TYPE;

Line 2254: hr_organization_units org

2250: loc.telephone_number_1,
2251: loc.style,
2252: loc.location_id
2253: FROM hr_locations loc,
2254: hr_organization_units org
2255: WHERE org.location_id = loc.location_id
2256: AND org.organization_id = c_rep_entity_id;
2257: */
2258: CURSOR c_legal_info (c_rep_entity_id number) IS

Line 2496: FROM hr_organization_units org_unit,

2492: INTO l_rep_context_tax_reg_no,
2493: l_rep_context_org_id,
2494: l_rep_context_loc_id,
2495: l_rep_context_name
2496: FROM hr_organization_units org_unit,
2497: hr_organization_information org_info
2498: WHERE org_unit.organization_id = org_info.organization_id
2499: AND org_info.org_information1 = 'OPERATING_UNIT'
2500: AND org_unit.organization_id = p_rep_entity_id;