APPS.JAI_FA_MA_TRIGGER_PKG dependencies on JAI_AP_MATCH_INV_TAXES

Line 325: FROM jai_ap_match_inv_taxes A, ap_invoice_lines_all B /* rchandan for bug#4454657 JAI_CMN_FA_INV_DIST_ALL is obsolete and so replaced by JAI_AP_MATCH_INV_TAXES */

321: || rchandan for bug#4454657 commented the aboce cursor and following cursor has been added by rchandan for ap lines change
322: */
323: CURSOR c_get_line_info IS
324: SELECT A.rcv_transaction_id
325: FROM jai_ap_match_inv_taxes A, ap_invoice_lines_all B /* rchandan for bug#4454657 JAI_CMN_FA_INV_DIST_ALL is obsolete and so replaced by JAI_AP_MATCH_INV_TAXES */
326: WHERE A.line_type_lookup_code NOT like 'ITEM'
327: AND B.invoice_id = pr_new.invoice_id
328: AND A.INVOICE_ID = B.INVOICE_ID
329: AND A.invoice_line_number = B.line_number

Line 354: FROM JAI_AP_MATCH_INV_TAXES a,

350: SELECT b.mod_cr_percentage,
351: a.tax_id
352: ,a.parent_invoice_distribution_id -- 5763527
353: ,a.line_no -- 5763527
354: FROM JAI_AP_MATCH_INV_TAXES a,
355: JAI_CMN_TAXES_ALL b
356: WHERE a.invoice_id = pr_new.invoice_id
357: AND a.invoice_line_number = pr_new.invoice_line_number /*rchandan for bug#4454657*/
358: AND a.tax_id = b.tax_id;

Line 401: cursor c_get_tax_line_cnt (cp_tax_id JAI_AP_MATCH_INV_TAXES.tax_id%type

397: --
398: -- Begin 5763527
399: --
400: ln_cnt number;
401: cursor c_get_tax_line_cnt (cp_tax_id JAI_AP_MATCH_INV_TAXES.tax_id%type
402: ,cp_parent_inv_dist_id JAI_AP_MATCH_INV_TAXES.parent_invoice_distribution_id%type
403: ,cp_tax_line_num JAI_AP_MATCH_INV_TAXES.line_no%type
404: )
405: is

Line 402: ,cp_parent_inv_dist_id JAI_AP_MATCH_INV_TAXES.parent_invoice_distribution_id%type

398: -- Begin 5763527
399: --
400: ln_cnt number;
401: cursor c_get_tax_line_cnt (cp_tax_id JAI_AP_MATCH_INV_TAXES.tax_id%type
402: ,cp_parent_inv_dist_id JAI_AP_MATCH_INV_TAXES.parent_invoice_distribution_id%type
403: ,cp_tax_line_num JAI_AP_MATCH_INV_TAXES.line_no%type
404: )
405: is
406: select count(1)

Line 403: ,cp_tax_line_num JAI_AP_MATCH_INV_TAXES.line_no%type

399: --
400: ln_cnt number;
401: cursor c_get_tax_line_cnt (cp_tax_id JAI_AP_MATCH_INV_TAXES.tax_id%type
402: ,cp_parent_inv_dist_id JAI_AP_MATCH_INV_TAXES.parent_invoice_distribution_id%type
403: ,cp_tax_line_num JAI_AP_MATCH_INV_TAXES.line_no%type
404: )
405: is
406: select count(1)
407: from JAI_AP_MATCH_INV_TAXES a

Line 407: from JAI_AP_MATCH_INV_TAXES a

403: ,cp_tax_line_num JAI_AP_MATCH_INV_TAXES.line_no%type
404: )
405: is
406: select count(1)
407: from JAI_AP_MATCH_INV_TAXES a
408: where a.invoice_id = pr_new.invoice_id
409: and a.parent_invoice_distribution_id = cp_parent_inv_dist_id
410: and a.tax_id = cp_tax_id
411: and a.line_no = cp_tax_line_num ;