APPS.JAI_AP_IDA_TRIGGER_DTC_PKG dependencies on JAI_PO_TAXES

Line 95: FROM JAI_PO_TAXES a, JAI_CMN_TAXES_ALL b

91: and b.section_type= 'WCT_SECTION';
92:
93: CURSOR c_line_location_wct_taxes(focus_id NUMBER) IS
94: SELECT a.tax_id
95: FROM JAI_PO_TAXES a, JAI_CMN_TAXES_ALL b
96: WHERE line_focus_id = focus_id
97: and a.tax_id = b.tax_id
98: and b.section_type= 'WCT_SECTION'
99: AND a. tax_type = 'TDS';

Line 272: (nvl(jct.adhoc_flag,'Q')='Y' and exists (select '1' from jai_po_taxes jpt

268: and line_type_lookup_code='MISCELLANEOUS'
269: --adhoc taxes which are different from transaction currency shall not be considered for IPV/ERV ,16dec
270: and (nvl(jct.adhoc_flag,'Q')='N'
271: OR
272: (nvl(jct.adhoc_flag,'Q')='Y' and exists (select '1' from jai_po_taxes jpt
273: where jpt.line_location_id=jm.line_location_id
274: and jpt.currency=jm.currency_code
275: AND jpt.tax_id=jm.tax_id)
276: )

Line 399: from jai_po_taxes

395:
396: cursor get_po_tax_amt (cp_line_location_id in number ,cp_tax_id in number)
397: is
398: select tax_amount
399: from jai_po_taxes
400: where line_location_id=cp_line_location_id
401: and tax_id=cp_tax_id;
402:
403: ln_src_tax_amt NUMBER;