APPS.PON_PRINTING_PKG dependencies on HR_LOCATIONS_ALL

Line 2560: hr_locations_all loc_bill,

2556: fnd_lookup_values fl_freight_terms ,
2557: fnd_lookup_values flv,
2558: ap_terms ap ,
2559: fnd_lookup_values fl_fob ,
2560: hr_locations_all loc_bill,
2561: fnd_territories_tl bill_territories_tl,
2562: hr_locations_all loc_ship,
2563: fnd_territories_tl ship_territories_tl,
2564: fnd_currencies_tl currency_tl ,

Line 2562: hr_locations_all loc_ship,

2558: ap_terms ap ,
2559: fnd_lookup_values fl_fob ,
2560: hr_locations_all loc_bill,
2561: fnd_territories_tl bill_territories_tl,
2562: hr_locations_all loc_ship,
2563: fnd_territories_tl ship_territories_tl,
2564: fnd_currencies_tl currency_tl ,
2565: pon_auc_doctypes doctypes,
2566: hz_parties hp1,

Line 2570: hr_locations_all entity_loc,

2566: hz_parties hp1,
2567: hr_operating_units ou,
2568: hr_all_organization_units entity,
2569: hr_all_organization_units_tl entitytl,
2570: hr_locations_all entity_loc,
2571: fnd_territories_tl entity_terr,
2572: fnd_lookups fl_security,
2573: gl_daily_conversion_types gdct,
2574: fnd_product_groups fpg,

Line 2839: hr_locations_all hl,

2835: ,paip.has_quantity_tiers negline_has_quantity_tiers
2836: ,pbip.has_quantity_tiers bidline_has_quantity_tiers
2837: from
2838: pon_auction_item_prices_all paip ,
2839: hr_locations_all hl,
2840: fnd_territories_tl tl,
2841: per_jobs_vl jobs,
2842: icx_cat_categories_v icx,
2843: mtl_units_of_measure_tl units,

Line 2963: hr_locations_all hrl,

2959: pon_auc_payments_shipments pay,
2960: pa_projects_all proj,
2961: pa_tasks_expend_v task,
2962: gms_awards_all awrd,
2963: hr_locations_all hrl,
2964: hr_all_organization_units hrorg,
2965: fnd_user fuser,
2966: po_lookup_codes lkp1,
2967: fnd_territories_tl terr,

Line 3038: hr_locations_all hrl,

3034: pon_auc_payments_shipments pay,
3035: pa_projects_all proj,
3036: pa_tasks_expend_v task,
3037: gms_awards_all awrd,
3038: hr_locations_all hrl,
3039: hr_all_organization_units hrorg,
3040: fnd_user fuser,
3041: po_lookup_codes lkp1,
3042: fnd_territories_tl terr,

Line 3321: hr_locations_all loc,

3317: pbsm.price_type,
3318: pbsm.price_discount
3319: FROM pon_auction_shipments_all pas,
3320: pon_auction_item_prices_all paip,
3321: hr_locations_all loc,
3322: mtl_parameters mp,
3323: -- bidpdf: add response price for price breaks
3324: pon_bid_shipments pbsm
3325: WHERE pbsm.bid_number = p_bid_number

Line 3362: hr_locations_all loc,

3358: null price_type,
3359: null price_discount
3360: FROM pon_auction_shipments_all pas,
3361: pon_auction_item_prices_all paip,
3362: hr_locations_all loc,
3363: mtl_parameters mp
3364: WHERE pas.auction_header_id = p_auction_header_id
3365: AND pas.line_number = line_num
3366: AND l_neg_has_price_breaks = 'Y'

Line 4112: hr_locations_all loc,

4108: loc.postal_code postal_code,
4109: loc.country country,
4110: loc.region_1 county
4111: from
4112: hr_locations_all loc,
4113: pon_auction_shipments_all pas,
4114: fnd_territories_tl ship_territories_tl
4115: WHERE
4116: pas.auction_header_id = p_auction_header_id

Line 4144: hr_locations_all loc,

4140: loc.postal_code postal_code,
4141: loc.country country,
4142: loc.region_1 county
4143: from
4144: hr_locations_all loc,
4145: hr_all_organization_units haou,
4146: fnd_territories_tl ship_territories_tl,
4147: mtl_parameters mp ,
4148: ( SELECT