APPS.JAI_AP_IDA_TRIGGER_PKG dependencies on JAI_PO_TAXES

Line 972: FROM JAI_PO_TAXES a, JAI_CMN_TAXES_ALL b

968: and b.section_type= 'WCT_SECTION';
969:
970: CURSOR c_line_location_wct_taxes(focus_id NUMBER) IS
971: SELECT a.tax_id
972: FROM JAI_PO_TAXES a, JAI_CMN_TAXES_ALL b
973: WHERE line_focus_id = focus_id
974: and a.tax_id = b.tax_id
975: and b.section_type= 'WCT_SECTION'
976: AND a. tax_type = 'TDS';

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

1135: and line_type_lookup_code='MISCELLANEOUS'
1136: --adhoc taxes which are different from transaction currency shall not be considered for IPV/ERV ,16dec
1137: and (nvl(jct.adhoc_flag,'Q')='N'
1138: OR
1139: (nvl(jct.adhoc_flag,'Q')='Y' and exists (select '1' from jai_po_taxes jpt
1140: where jpt.line_location_id=jm.line_location_id
1141: and jpt.currency=jm.currency_code
1142: AND jpt.tax_id=jm.tax_id)
1143: )

Line 1262: from jai_po_taxes

1258: and tax_id=cp_tax_id;
1259: cursor get_po_tax_amt (cp_line_location_id in number ,cp_tax_id in number)
1260: is
1261: select tax_amount
1262: from jai_po_taxes
1263: where line_location_id=cp_line_location_id
1264: and tax_id=cp_tax_id;
1265:
1266: ln_src_tax_amt NUMBER;