DBA Data[Home] [Help]

APPS.ZX_ON_DEMAND_TRX_UPGRADE_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 4401: hr_organization_information oi,

4397: AND NVL(aps.org_id, -99) = NVL(fsp.org_id, -99)
4398: AND (trunc(poh.last_update_date) between upd.start_date and upd.end_date)
4399: ) poh,
4400: fnd_currencies fc,
4401: hr_organization_information oi,
4402: po_lines_all pol,
4403: po_line_locations_all poll,
4404: zx_party_tax_profile ptp,
4405: hr_locations_all hr

Line 5077: hr_organization_information oi

5073: FROM po_headers_all poh,
5074: financials_system_params_all fsp,
5075: xla_upgrade_dates upd,
5076: ap_system_parameters_all aps,
5077: hr_organization_information oi
5078: WHERE poh.rowid BETWEEN p_start_rowid AND p_end_rowid
5079: AND NVL(poh.closed_code, 'X') <> 'FINALLY CLOSED'
5080: AND NVL(poh.org_id,-99) = NVL(fsp.org_id,-99)
5081: AND upd.ledger_id = fsp.set_of_books_id

Line 5784: hr_organization_information oi

5780: FROM po_headers_all poh,
5781: financials_system_params_all fsp,
5782: xla_upgrade_dates upd,
5783: ap_system_parameters_all aps,
5784: hr_organization_information oi
5785: WHERE poh.rowid BETWEEN p_start_rowid AND p_end_rowid
5786: AND NVL(poh.closed_code, 'X') <> 'FINALLY CLOSED'
5787: AND NVL(poh.org_id,-99) = NVL(fsp.org_id,-99)
5788: AND upd.ledger_id = fsp.set_of_books_id