APPS.JAI_CMN_ST_FORMS_PKG dependencies on JAI_PO_TAXES

Line 112: from JAI_PO_TAXES

108: and tax_id = p_tax_id;
109:
110: cursor get_tax_ln_no_po(p_po_line_location_id number, p_tax_id number) is
111: select tax_line_no
112: from JAI_PO_TAXES
113: where tax_id = p_tax_id
114: and line_location_id = p_po_line_location_id;
115:
116: cursor c_get_match_org_loc(p_po_line_location_id number) is

Line 163: v_tax_line_no JAI_PO_TAXES.tax_line_no%type;

159: v_po_line_location_id JAI_AP_MATCH_INV_TAXES.line_location_id%type;
160: v_po_header_id JAI_AP_MATCH_INV_TAXES.po_header_id%type;
161: v_po_num po_headers_all.segment1%type;
162: v_po_line_id JAI_AP_MATCH_INV_TAXES.po_line_id%type;
163: v_tax_line_no JAI_PO_TAXES.tax_line_no%type;
164: v_match_option po_line_locations_all.match_option%type;
165: v_ship_to_organization_id po_line_locations_all.ship_to_organization_id%type;
166: v_ship_to_location_id po_line_locations_all.ship_to_location_id%type;
167: v_type_lookup_code po_headers_all.type_lookup_code%type;

Line 265: from JAI_PO_TAXES

261:
262: -- precedences are always available in po taxes only (receipt taxes does not have it)
263: cursor c_get_tax_precedence (p_po_line_location_id number) is
264: select precedence_1, precedence_2 , precedence_3, precedence_4, precedence_5
265: from JAI_PO_TAXES
266: where tax_id = p_tax_id
267: and line_location_id = p_po_line_location_id;
268:
269: /*Bug 14277151 - Start*/

Line 307: and jmit.tax_id = (select jpt.tax_id from JAI_PO_TAXES jpt

303: and jmit.po_line_id = p_po_line_id
304: and jmit.line_location_id = p_line_location_id
305: and nvl(jmit.po_distribution_id,1) = nvl(p_po_distribution_id,nvl(jmit.po_distribution_id,1)) /*Added by nprashar for bug # 12561167 */
306: and jmit.parent_invoice_line_number = p_parent_line_number
307: and jmit.tax_id = (select jpt.tax_id from JAI_PO_TAXES jpt
308: , jai_cmn_taxes_all jcta -- for bug 14183827 by anupgupt
309: Where jpt.line_location_id = p_line_location_id
310: and jpt.tax_line_no = p_precedence
311: and jpt.tax_id = jcta.tax_id -- for bug 14183827 by anupgupt

Line 317: from JAI_PO_TAXES

313: and jpt.tax_id = jmit.tax_id));
314: /*in Commented by nprashar for bug # 9830853
315: (
316: select tax_id
317: from JAI_PO_TAXES
318: where line_location_id = p_line_location_id
319: and tax_line_no in
320: (p_precedence_1, p_precedence_2, p_precedence_3, p_precedence_4, p_precedence_5)
321: )

Line 402: is not present in jai_po_taxes*/

398: Fetch c_get_non_zero_precedence_amt into v_tax_base_amt_loop;
399: Close c_get_non_zero_precedence_amt;
400:
401: IF nvl(v_tax_base_amt_loop,0) = 0 Then /*Tax id present in JAI_AP_MATCH_INV_TAXES
402: is not present in jai_po_taxes*/
403: Begin /*Added Begin End section for bug # 12561167 */
404: select jamit.tax_amount into v_tax_base_amt_loop
405: from JAI_AP_MATCH_INV_TAXES jamit
406: , jai_cmn_taxes_all jcta -- for bug 14183827 by anupgupt