DBA Data[Home] [Help]

APPS.JAI_OE_OLA_TRIGGER_PKG dependencies on JAI_PO_REQ_LINES

Line 213: FROM JAI_PO_REQ_LINES

209: */
210:
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 );