APPS.JAI_AP_RPT_PRRG_PKG dependencies on JAI_CMN_TAXES_ALL

Line 157: from JAI_CMN_TAXES_ALL

153: );
154:
155: cursor c_get_tax_type(p_tax_id number) is
156: select UPPER(tax_type) tax_type /*Changes by nprashar for bug 7678389, replaced initcap by Upper function Changes by nprashar for bug # 6803557 */
157: from JAI_CMN_TAXES_ALL
158: where tax_id = p_tax_id;
159:
160: cursor c_get_misc_tax_line_amt (p_invoice_id number, p_distribution_line_number number, p_invoice_distribution_id number ) is
161: select amount

Line 178: from JAI_RCV_LINE_TAXES A, JAI_CMN_TAXES_ALL B -- Added by Kevin Cheng for Inclusive Tax

174: p_po_distribution_id number,
175: p_rcv_transaction_id number
176: ) is
177: select A.tax_id, upper(A.tax_type) tax_type, A.currency, A.tax_amount
178: from JAI_RCV_LINE_TAXES A, JAI_CMN_TAXES_ALL B -- Added by Kevin Cheng for Inclusive Tax
179: where (A.shipment_header_id, A.shipment_line_id)
180: in
181: (select shipment_header_id, shipment_line_id
182: from rcv_transactions

Line 219: from JAI_PO_TAXES A, JAI_CMN_TAXES_ALL B -- Added by Kevin Cheng for Inclusive Tax

215: p_po_distribution_id number,
216: p_rcv_transaction_id number
217: ) is
218: select A.tax_id, upper(A.tax_type) tax_type, A.currency, A.tax_amount
219: from JAI_PO_TAXES A, JAI_CMN_TAXES_ALL B -- Added by Kevin Cheng for Inclusive Tax
220: where (A.po_header_id, A.po_line_id, A.line_location_id)
221: in
222: (select po_header_id, po_line_id, line_location_id
223: from po_distributions_all

Line 257: v_tax_type JAI_CMN_TAXES_ALL.tax_type%type;

253: v_po_number po_headers_all.segment1%type;
254: v_po_date date;
255: v_receipt_num rcv_shipment_headers.receipt_num%type;
256: v_receipt_date date;
257: v_tax_type JAI_CMN_TAXES_ALL.tax_type%type;
258: v_po_release_num po_releases_all.release_num%type;
259: v_po_release_date date;
260:
261: v_excise_ap number;