APPS.JAI_AP_IDA_TRIGGER_PKG dependencies on JAI_AP_MATCH_INV_TAXES

Line 21: from JAI_AP_MATCH_INV_TAXES

17: this invoice in localization tables */
18:
19: Cursor check_loc_tax(ln_invoice_id number) is
20: select 'Y'
21: from JAI_AP_MATCH_INV_TAXES
22: where invoice_id = ln_invoice_id ;
23:
24: /* Check for localization tax existence */
25:

Line 67: FROM jai_ap_match_inv_taxes jamt

63: AND jrd.regime_code = jai_constants.service_regime;
64:
65: CURSOR get_matched_tax_cur IS
66: SELECT jcta.tax_type
67: FROM jai_ap_match_inv_taxes jamt
68: , jai_cmn_taxes_all jcta
69: , jai_rgm_registrations jrr
70: , jai_rgm_definitions jrd
71: WHERE jamt.invoice_id = pr_new.invoice_id

Line 85: FROM ap_invoice_lines_all line, jai_ap_match_inv_taxes jamt

81: /* Modified the cursor get_match_item_cur for bug 14507573 */
82: CURSOR get_match_item_cur IS
83:
84: SELECT line.match_type,line.line_number
85: FROM ap_invoice_lines_all line, jai_ap_match_inv_taxes jamt
86: WHERE line.invoice_id = pr_new.invoice_id
87: and jamt.invoice_id=line.invoice_id
88: and jamt.invoice_distribution_id=nvl(pr_new.parent_reversal_id,pr_new.invoice_distribution_id) /*Modified for bug 16393213 */
89: and jamt.po_distribution_id=pr_new.po_distribution_id

Line 351: jai_ap_match_inv_taxes.shipment_line_id is used to get the receipt tax

347: This issue will particularly occurs if the PO doesnot have the taxes
348: attached.
349:
350: Technical details:
351: jai_ap_match_inv_taxes.shipment_line_id is used to get the receipt tax
352: amount.
353: But jai_ap_match_inv_taxes.shipment_line_id will be always null.
354: Hence the receipt tax amount retrieved is null ,due to which ERV tax amount
355: is null and the accounting didnt happen for the ERV line

Line 353: But jai_ap_match_inv_taxes.shipment_line_id will be always null.

349:
350: Technical details:
351: jai_ap_match_inv_taxes.shipment_line_id is used to get the receipt tax
352: amount.
353: But jai_ap_match_inv_taxes.shipment_line_id will be always null.
354: Hence the receipt tax amount retrieved is null ,due to which ERV tax amount
355: is null and the accounting didnt happen for the ERV line
356:
357: fix :

Line 1131: from JAI_AP_MATCH_INV_TAXES jm,jai_cmn_taxes_all jct

1127: PRAGMA AUTONOMOUS_TRANSACTION;
1128: /* Cursor to get the localization taxes attached to the item line*/
1129: Cursor get_loc_tax(cp_invoice_id number,cp_inv_distid number) is
1130: select jm.*
1131: from JAI_AP_MATCH_INV_TAXES jm,jai_cmn_taxes_all jct
1132: where jm.tax_id=jct.tax_id
1133: and invoice_id = cp_invoice_id
1134: and parent_invoice_distribution_id=cp_inv_distid
1135: and line_type_lookup_code='MISCELLANEOUS'