APPS.JAI_OE_OLA_TRIGGER_PKG dependencies on PO_REQUISITION_HEADERS_ALL

Line 215: FROM po_requisition_headers_all a, oe_order_headers_all b

211: CURSOR po_reqn_lines_count(p_requisition_number VARCHAR2) IS
212: SELECT count(1)
213: FROM JAI_PO_REQ_LINES
214: WHERE requisition_header_id IN ( SELECT requisition_header_id
215: FROM po_requisition_headers_all a, oe_order_headers_all b
216: WHERE A.segment1 = b.orig_sys_document_ref
217: AND A.segment1 = p_requisition_number );
218:
219: