APPS.ZX_EXTRACT_PKG dependencies on HR_ORGANIZATION_UNITS

Line 2660: l_rep_context_name HR_ORGANIZATION_UNITS.name%TYPE;

2656: l_request_id NUMBER;
2657: l_rep_entity_id NUMBER;
2658: l_rep_context_tax_reg_no HR_ORGANIZATION_INFORMATION.org_information2%TYPE;
2659: l_rep_context_loc_id HR_LOCATIONS_ALL.location_id%TYPE;
2660: l_rep_context_name HR_ORGANIZATION_UNITS.name%TYPE;
2661: l_rep_context_city HR_LOCATIONS_ALL.town_or_city%TYPE;
2662: l_rep_context_county HR_LOCATIONS_ALL.region_3%TYPE;
2663: l_rep_context_state HR_LOCATIONS_ALL.region_2%TYPE;
2664: l_rep_context_province HR_LOCATIONS_ALL.region_1%TYPE;

Line 2715: hr_organization_units org

2711: loc.telephone_number_1,
2712: loc.style,
2713: loc.location_id
2714: FROM hr_locations loc,
2715: hr_organization_units org
2716: WHERE org.location_id = loc.location_id
2717: AND org.organization_id = c_rep_entity_id;
2718: */
2719: CURSOR c_legal_info (c_rep_entity_id number) IS

Line 2955: FROM hr_organization_units org_unit,

2951: INTO l_rep_context_tax_reg_no,
2952: l_rep_context_org_id,
2953: l_rep_context_loc_id,
2954: l_rep_context_name
2955: FROM hr_organization_units org_unit,
2956: hr_organization_information org_info
2957: WHERE org_unit.organization_id = org_info.organization_id
2958: AND org_info.org_information1 = 'OPERATING_UNIT'
2959: AND org_unit.organization_id = p_rep_entity_id;