APPS.ZX_ON_FLY_TRX_UPGRADE_PO_PKG dependencies on HR_LOCATIONS_ALL

Line 488: hr_locations_all hr

484: fnd_currencies fc,
485: po_lines_all pol,
486: po_line_locations_all poll,
487: zx_party_tax_profile ptp,
488: hr_locations_all hr
489: WHERE NVL(poh.currency_code, poh.base_currency_code) = fc.currency_code(+)
490: AND pol.po_header_id = poh.po_header_id
491: AND poll.po_header_id = pol.po_header_id
492: AND poll.po_line_id = pol.po_line_id

Line 2824: hr_locations_all hr

2820: ) poll,
2821: fnd_currencies fc,
2822: po_lines_all pol,
2823: zx_party_tax_profile ptp,
2824: hr_locations_all hr
2825: WHERE NVL(poll.poh_currency_code, poll.aps_base_currency_code) = fc.currency_code(+)
2826: AND pol.po_header_id = poll.po_header_id
2827: AND pol.po_line_id = poll.po_line_id
2828: AND hr.location_id(+) = poll.ship_to_location_id

Line 5254: hr_locations_all hr

5250: fnd_currencies fc,
5251: po_lines_all pol,
5252: po_line_locations_all poll,
5253: zx_party_tax_profile ptp,
5254: hr_locations_all hr
5255: WHERE NVL(poh.currency_code, poh.base_currency_code) = fc.currency_code(+)
5256: AND pol.po_header_id = poh.po_header_id
5257: AND poll.po_header_id = pol.po_header_id
5258: AND poll.po_line_id = pol.po_line_id

Line 7576: hr_locations_all hr

7572: ) poll,
7573: fnd_currencies fc,
7574: po_lines_all pol,
7575: zx_party_tax_profile ptp,
7576: hr_locations_all hr
7577: WHERE NVL(poll.poh_currency_code, poll.aps_base_currency_code) = fc.currency_code(+)
7578: AND pol.po_header_id = poll.po_header_id
7579: AND pol.po_line_id = poll.po_line_id
7580: AND hr.location_id(+) = poll.ship_to_location_id