APPS.JAI_AP_RPT_PRRG_PKG dependencies on JAI_CMN_TAXES_ALL

Line 162: from JAI_CMN_TAXES_ALL

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

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

179: p_po_distribution_id number,
180: p_rcv_transaction_id number
181: ) is
182: select A.tax_id, upper(A.tax_type) tax_type, A.currency, A.tax_amount
183: from JAI_RCV_LINE_TAXES A, JAI_CMN_TAXES_ALL B -- Added by Kevin Cheng for Inclusive Tax
184: where (A.shipment_header_id, A.shipment_line_id)
185: in
186: (select shipment_header_id, shipment_line_id
187: from rcv_transactions

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

220: p_po_distribution_id number,
221: p_rcv_transaction_id number
222: ) is
223: select A.tax_id, upper(A.tax_type) tax_type, A.currency, A.tax_amount
224: from JAI_PO_TAXES A, JAI_CMN_TAXES_ALL B -- Added by Kevin Cheng for Inclusive Tax
225: where (A.po_header_id, A.po_line_id, A.line_location_id)
226: in
227: (select po_header_id, po_line_id, line_location_id
228: from po_distributions_all

Line 262: v_tax_type JAI_CMN_TAXES_ALL.tax_type%type;

258: v_po_number po_headers_all.segment1%type;
259: v_po_date date;
260: v_receipt_num rcv_shipment_headers.receipt_num%type;
261: v_receipt_date date;
262: v_tax_type JAI_CMN_TAXES_ALL.tax_type%type;
263: v_po_release_num po_releases_all.release_num%type;
264: v_po_release_date date;
265:
266: v_excise_ap number;