Line 863: Select Segment1 PO_NUMBER From po_headers_all
859: And ei.project_id =p_project_id);
860:
861: -- Cursor C5 is to get all the PO number's matched to an Invoice.
862: Cursor C5(p_Invoice_Id Number) IS 863: Select Segment1 PO_NUMBER From po_headers_all 864: Where po_header_id in (Select distinct po_header_id
865: from pa_pwp_ap_inv_dtl where invoice_id = p_Invoice_id);
866:
867: --Cursor C6 is to get all the linked invoices for a given Draft_Inv_Num
[Home] [Help]