DBA Data[Home] [Help]

APPS.JAI_CMN_ST_FORMS_PKG dependencies on JAI_RCV_LINE_TAXES

Line 101: from JAI_RCV_LINE_TAXES

97: and po_line_id = p_line_id;
98:
99: cursor c_get_tax_ln_no_receipt (p_rcv_transaction_id number, p_tax_id number) is
100: select tax_line_no
101: from JAI_RCV_LINE_TAXES
102: where (shipment_header_id, shipment_line_id)
103: in
104: (select shipment_header_id, shipment_line_id
105: from rcv_transactions

Line 273: FROM jai_rcv_line_taxes

269: /*Bug 14277151 - Start*/
270: cursor c_get_tax_precedence_rcv (p_rcv_transaction_id NUMBER)
271: IS
272: SELECT precedence_1, precedence_2, precedence_3, precedence_4, precedence_5
273: FROM jai_rcv_line_taxes
274: WHERE shipment_line_id IN (SELECT shipment_line_id
275: FROM RCV_TRANSACTIONS
276: WHERE transaction_id = p_rcv_transaction_id)
277: AND tax_id = p_tax_id;