APPS.PON_PRINTING_PKG dependencies on HR_LOCATIONS_ALL

Line 1694: hr_locations_all hl,

1690: ,paip.has_quantity_tiers negline_has_quantity_tiers
1691: ,pbip.has_quantity_tiers bidline_has_quantity_tiers
1692: from
1693: pon_auction_item_prices_all paip ,
1694: hr_locations_all hl,
1695: fnd_territories_tl tl,
1696: per_jobs_vl jobs,
1697: icx_cat_categories_v icx,
1698: mtl_units_of_measure_tl units,

Line 2242: hr_locations_all loc,

2238: pbsm.price_type,
2239: pbsm.price_discount
2240: FROM pon_auction_shipments_all pas,
2241: pon_auction_item_prices_all paip,
2242: hr_locations_all loc,
2243: mtl_parameters mp,
2244: -- bidpdf: add response price for price breaks
2245: pon_bid_shipments pbsm
2246: WHERE pbsm.bid_number = pbhs.bid_number

Line 2284: hr_locations_all loc,

2280: null price_type,
2281: null price_discount
2282: FROM pon_auction_shipments_all pas,
2283: pon_auction_item_prices_all paip,
2284: hr_locations_all loc,
2285: mtl_parameters mp
2286: WHERE pas.auction_header_id = pah.auction_header_id
2287: AND l_neg_has_price_breaks = 'Y'
2288: AND paip.auction_header_id = pas.auction_header_id

Line 2404: hr_locations_all hrl,

2400: pon_auc_payments_shipments pay,
2401: pa_projects_all proj,
2402: pa_tasks task,
2403: gms_awards_all awrd,
2404: hr_locations_all hrl,
2405: hr_all_organization_units hrorg,
2406: fnd_user fuser,
2407: po_lookup_codes lkp1,
2408: fnd_territories_tl terr,

Line 2480: hr_locations_all hrl,

2476: pon_auc_payments_shipments pay,
2477: pa_projects_all proj,
2478: pa_tasks task,
2479: gms_awards_all awrd,
2480: hr_locations_all hrl,
2481: hr_all_organization_units hrorg,
2482: fnd_user fuser,
2483: po_lookup_codes lkp1,
2484: fnd_territories_tl terr,

Line 2526: hr_locations_all loc,

2522: loc.postal_code postal_code,
2523: loc.country country,
2524: loc.region_1 county
2525: from
2526: hr_locations_all loc,
2527: pon_auction_shipments_all pas,
2528: fnd_territories_tl ship_territories_tl
2529: WHERE
2530: pas.auction_header_id = pah.auction_header_id

Line 2558: hr_locations_all loc,

2554: loc.postal_code postal_code,
2555: loc.country country,
2556: loc.region_1 county
2557: from
2558: hr_locations_all loc,
2559: hr_all_organization_units haou,
2560: fnd_territories_tl ship_territories_tl,
2561: mtl_parameters mp ,
2562: ( SELECT

Line 3139: hr_locations_all loc_bill,

3135: fnd_lookups fl_pf_type_allowed,
3136: fnd_lookup_values fl_freight_terms ,
3137: ap_terms ap ,
3138: fnd_lookup_values fl_fob ,
3139: hr_locations_all loc_bill,
3140: fnd_territories_tl bill_territories_tl,
3141: hr_locations_all loc_ship,
3142: fnd_territories_tl ship_territories_tl,
3143: fnd_currencies_tl currency_tl ,

Line 3141: hr_locations_all loc_ship,

3137: ap_terms ap ,
3138: fnd_lookup_values fl_fob ,
3139: hr_locations_all loc_bill,
3140: fnd_territories_tl bill_territories_tl,
3141: hr_locations_all loc_ship,
3142: fnd_territories_tl ship_territories_tl,
3143: fnd_currencies_tl currency_tl ,
3144: pon_auc_doctypes doctypes,
3145: hz_parties hp1,

Line 3149: hr_locations_all entity_loc,

3145: hz_parties hp1,
3146: hr_operating_units ou,
3147: hr_all_organization_units entity,
3148: hr_all_organization_units_tl entitytl,
3149: hr_locations_all entity_loc,
3150: fnd_territories_tl entity_terr,
3151: fnd_lookups fl_security,
3152: gl_daily_conversion_types gdct,
3153: fnd_product_groups fpg,