APPS.JAI_AP_IDA_TRIGGER_PKG dependencies on JAI_RCV_TRANSACTIONS

Line 134: FROM jai_rcv_transactions rcv, ap_invoice_lines_all ap

130: AND ap.line_number = pn_line_number;
131:
132: CURSOR get_rcpt_matched_org_cur(pn_line_number NUMBER) IS
133: SELECT rcv.organization_id, rcv.location_id
134: FROM jai_rcv_transactions rcv, ap_invoice_lines_all ap
135: WHERE ap.rcv_transaction_id = rcv.transaction_id
136: AND ap.invoice_id = pr_new.invoice_id
137: AND ap.line_number = pn_line_number;
138:

Line 1253: from jai_rcv_line_taxes jt ,jai_rcv_transactions jrt

1249: */
1250: cursor get_rcv_tax_amt (cp_rcv_transaction_id in number ,cp_tax_id in number)
1251: is
1252: select jt.tax_amount
1253: from jai_rcv_line_taxes jt ,jai_rcv_transactions jrt
1254: where
1255: jrt.shipment_header_id=jt.shipment_headeR_id
1256: and jrt.shipment_line_id=jt.shipment_line_id
1257: and jrt.transaction_id=cp_rcv_transaction_id