DBA Data[Home] [Help]

APPS.JAI_TAX_PROCESSING_PKG dependencies on PO_HEADERS_ALL

Line 772: CURSOR c_get_po_org_id(cp_trx_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE ) IS

768: SELECT org_id
769: FROM PO_REQUISITION_HEADERS_ALL
770: WHERE REQUISITION_HEADER_ID = cp_trx_id;
771:
772: CURSOR c_get_po_org_id(cp_trx_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE ) IS
773: SELECT org_id
774: FROM PO_HEADERS_ALL
775: WHERE PO_HEADER_ID = cp_trx_id;
776:

Line 774: FROM PO_HEADERS_ALL

770: WHERE REQUISITION_HEADER_ID = cp_trx_id;
771:
772: CURSOR c_get_po_org_id(cp_trx_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE ) IS
773: SELECT org_id
774: FROM PO_HEADERS_ALL
775: WHERE PO_HEADER_ID = cp_trx_id;
776:
777: cursor c_fetch_sob_from_hrou(cp_org_id in number)
778: is