DBA Data[Home] [Help]

APPS.ZX_EXTRACT_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 2658: l_rep_context_tax_reg_no HR_ORGANIZATION_INFORMATION.org_information2%TYPE;

2654: l_rep_context_id NUMBER;
2655: l_rep_context_org_id NUMBER;
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;

Line 2956: hr_organization_information org_info

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