APPS.PAY_US_GEOCODE_REPORT_PKG dependencies on HR_ORGANIZATION_UNITS

Line 4201: hr_organization_units hou,

4197: ', '||fdfc.form_left_prompt
4198: from pay_patch_status pps,
4199: pay_us_geo_update pgu,
4200: hr_organization_information hoi,
4201: hr_organization_units hou,
4202: fnd_descr_flex_contexts_vl fdfv,
4203: fnd_descr_flex_col_usage_vl fdfc,
4204: hr_org_information_types hoit,
4205: pay_us_modified_geocodes pumg1,

Line 4248: ln_organization_name hr_organization_units.name%TYPE;

4244:
4245: ln_location_name hr_locations_all.location_code%TYPE;
4246: ln_location_id hr_locations_all.location_id%TYPE;
4247:
4248: ln_organization_name hr_organization_units.name%TYPE;
4249: ln_organization_id hr_organization_units.organization_id%TYPE;
4250:
4251: lv_header_label VARCHAR2(32000);
4252:

Line 4249: ln_organization_id hr_organization_units.organization_id%TYPE;

4245: ln_location_name hr_locations_all.location_code%TYPE;
4246: ln_location_id hr_locations_all.location_id%TYPE;
4247:
4248: ln_organization_name hr_organization_units.name%TYPE;
4249: ln_organization_id hr_organization_units.organization_id%TYPE;
4250:
4251: lv_header_label VARCHAR2(32000);
4252:
4253: lv_data_row VARCHAR2(32000);