DBA Data[Home] [Help]

APPS.ZX_EXTRACT_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 2197: l_rep_context_tax_reg_no HR_ORGANIZATION_INFORMATION.org_information2%TYPE;

2193: l_rep_context_id NUMBER;
2194: l_rep_context_org_id NUMBER;
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;

Line 2497: hr_organization_information org_info

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;
2501: