78: WHERE set_of_books_id = c_sob;
79:
80: CURSOR fetch_rcv_record(v_rcv_trans_id NUMBER) IS
81: SELECT po_header_id,po_line_id
82: FROM rcv_transactions
83: WHERE transaction_id = v_rcv_trans_id;
84:
85: CURSOR fetch_tax_distribution(v_po_header_id NUMBER, v_po_line_id NUMBER, v_invoice_id NUMBER) IS
86: SELECT COUNT(*)
154: AND NVL(org_id, 0) = NVL(v_org_id, 0);
155:
156: CURSOR count_receipts(p_pck_slip VARCHAR2, ven_id NUMBER, cpv_transaction_type VARCHAR2 ) IS
157: SELECT DISTINCT rsh.receipt_num, rsh.shipment_header_id
158: FROM rcv_shipment_headers rsh, rcv_transactions rt
159: WHERE rsh.shipment_header_id = rt.shipment_header_id
160: AND rsh.packing_slip = p_pck_slip
161: AND rsh.vendor_id = ven_id
162: AND rt.transaction_type = cpv_transaction_type;
461: FROM DUAL
462: WHERE EXISTS (SELECT '1'
463: FROM JAI_RCV_LINE_TAXES
464: WHERE shipment_line_id IN (SELECT shipment_line_id
465: FROM RCV_TRANSACTIONS
466: WHERE po_header_id = pr_new.po_header_id
467: AND po_line_id = pr_new.po_line_id
468: AND source_document_code = 'PO')
469: );