APPS.JAI_OE_OLA_TRIGGER_PKG dependencies on PO_REQUISITION_HEADERS_ALL

Line 196: FROM po_requisition_headers_all a, oe_order_headers_all b

192: CURSOR po_reqn_lines_count(p_requisition_number VARCHAR2) IS
193: SELECT count(1)
194: FROM JAI_PO_REQ_LINES
195: WHERE requisition_header_id IN ( SELECT requisition_header_id
196: FROM po_requisition_headers_all a, oe_order_headers_all b
197: WHERE A.segment1 = b.orig_sys_document_ref
198: AND A.segment1 = p_requisition_number );
199:
200: