APPS.JAI_CMN_ST_FORMS_PKG dependencies on JAI_PO_TAXES

Line 96: from JAI_PO_TAXES

92: and tax_id = p_tax_id;
93:
94: cursor get_tax_ln_no_po(p_po_line_location_id number, p_tax_id number) is
95: select tax_line_no
96: from JAI_PO_TAXES
97: where tax_id = p_tax_id
98: and line_location_id = p_po_line_location_id;
99:
100: cursor c_get_match_org_loc(p_po_line_location_id number) is

Line 147: v_tax_line_no JAI_PO_TAXES.tax_line_no%type;

143: v_po_line_location_id JAI_AP_MATCH_INV_TAXES.line_location_id%type;
144: v_po_header_id JAI_AP_MATCH_INV_TAXES.po_header_id%type;
145: v_po_num po_headers_all.segment1%type;
146: v_po_line_id JAI_AP_MATCH_INV_TAXES.po_line_id%type;
147: v_tax_line_no JAI_PO_TAXES.tax_line_no%type;
148: v_match_option po_line_locations_all.match_option%type;
149: v_ship_to_organization_id po_line_locations_all.ship_to_organization_id%type;
150: v_ship_to_location_id po_line_locations_all.ship_to_location_id%type;
151: v_type_lookup_code po_headers_all.type_lookup_code%type;

Line 236: from JAI_PO_TAXES

232:
233: -- precedences are always available in po taxes only (receipt taxes does not have it)
234: cursor c_get_tax_precedence (p_po_line_location_id number) is
235: select precedence_1, precedence_2 , precedence_3, precedence_4, precedence_5
236: from JAI_PO_TAXES
237: where tax_id = p_tax_id
238: and line_location_id = p_po_line_location_id;
239:
240: /* Modified by Ramananda for bug# due to uptake of ap_invoice_lines_all */

Line 271: from JAI_PO_TAXES

267: and tax_id
268: in
269: (
270: select tax_id
271: from JAI_PO_TAXES
272: where line_location_id = p_line_location_id
273: and tax_line_no in
274: (p_precedence_1, p_precedence_2, p_precedence_3, p_precedence_4, p_precedence_5)
275: )