DBA Data[Home] [Help]

APPS.JAI_TAX_PROCESSING_PKG dependencies on PO_REQUISITION_HEADERS_ALL

Line 767: CURSOR c_get_req_org_id(cp_trx_id PO_REQUISITION_HEADERS_ALL.REQUISITION_HEADER_ID%TYPE ) IS

763: where header_id = cp_trx_id;
764: --added by zhiwei.xin for OM end.
765:
766: --Added by Wenqiong for PO integration begin
767: CURSOR c_get_req_org_id(cp_trx_id PO_REQUISITION_HEADERS_ALL.REQUISITION_HEADER_ID%TYPE ) IS
768: SELECT org_id
769: FROM PO_REQUISITION_HEADERS_ALL
770: WHERE REQUISITION_HEADER_ID = cp_trx_id;
771:

Line 769: FROM PO_REQUISITION_HEADERS_ALL

765:
766: --Added by Wenqiong for PO integration begin
767: CURSOR c_get_req_org_id(cp_trx_id PO_REQUISITION_HEADERS_ALL.REQUISITION_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