eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_AP_TDS_ETDS_PKG dependencies on JAI_CMN_TAXES_ALL

Line 483: ln_tax_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE;

479: v_prepayment_amount_applied NUMBER;
480:
481: \* Bug 4353842. Added by Lakshmi Gopalsami *\
482: ln_check_number ap_checks_all.check_number%TYPE;
483: ln_tax_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE;
484: ln_tds_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE;
485: ln_surcharge_rate JAI_CMN_TAXES_ALL.surcharge_rate%TYPE;
486: ln_cess_rate JAI_CMN_TAXES_ALL.cess_rate%TYPE;
487: ln_inv_amt ap_invoices_all.invoice_amount%TYPE;

Line 484: ln_tds_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE;

480:
481: \* Bug 4353842. Added by Lakshmi Gopalsami *\
482: ln_check_number ap_checks_all.check_number%TYPE;
483: ln_tax_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE;
484: ln_tds_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE;
485: ln_surcharge_rate JAI_CMN_TAXES_ALL.surcharge_rate%TYPE;
486: ln_cess_rate JAI_CMN_TAXES_ALL.cess_rate%TYPE;
487: ln_inv_amt ap_invoices_all.invoice_amount%TYPE;
488:

Line 485: ln_surcharge_rate JAI_CMN_TAXES_ALL.surcharge_rate%TYPE;

481: \* Bug 4353842. Added by Lakshmi Gopalsami *\
482: ln_check_number ap_checks_all.check_number%TYPE;
483: ln_tax_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE;
484: ln_tds_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE;
485: ln_surcharge_rate JAI_CMN_TAXES_ALL.surcharge_rate%TYPE;
486: ln_cess_rate JAI_CMN_TAXES_ALL.cess_rate%TYPE;
487: ln_inv_amt ap_invoices_all.invoice_amount%TYPE;
488:
489: -- added, Harshita for Bug 4525089

Line 486: ln_cess_rate JAI_CMN_TAXES_ALL.cess_rate%TYPE;

482: ln_check_number ap_checks_all.check_number%TYPE;
483: ln_tax_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE;
484: ln_tds_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE;
485: ln_surcharge_rate JAI_CMN_TAXES_ALL.surcharge_rate%TYPE;
486: ln_cess_rate JAI_CMN_TAXES_ALL.cess_rate%TYPE;
487: ln_inv_amt ap_invoices_all.invoice_amount%TYPE;
488:
489: -- added, Harshita for Bug 4525089
490:

Line 667: CURSOR c_tax_rates(p_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE)

663: r_get_tds_inv c_get_tds_inv_det%rowtype;
664:
665: --Added by Xiao Lv for bug#7662155 on 06-Jan-2010, end
666:
667: CURSOR c_tax_rates(p_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE)
668: IS
669: SELECT
670: NVL(tax_rate,0) tax_rate,
671: (NVL(tax_rate,0) - (NVL(surcharge_rate,0) + NVL(cess_rate,0) + NVL(sh_cess_rate,0))) tds_rate, -- added NVL, Harshita for Bug 4639067 --Added sh_cess_rate by Bgowrava for bug #6195027

Line 676: JAI_CMN_TAXES_ALL jtc

672: NVL(surcharge_rate,0) surcharge_rate,
673: NVL(cess_rate,0) cess_rate,
674: NVL(sh_cess_rate,0) sh_cess_rate --Added by Bgowrava for Bug#6195027
675: FROM
676: JAI_CMN_TAXES_ALL jtc
677: WHERE
678: tax_id = p_tax_id ;
679: \*Bug 11896260 - Start*\
680:

Line 889: JAI_CMN_TAXES_ALL jitc

885: FROM ap_invoices_all aia,
886: ap_invoice_distributions_all aida,
887: jai_ap_tds_inv_taxes jatit,
888: JAI_AP_TDS_VENDOR_HDRS jte,
889: JAI_CMN_TAXES_ALL jitc
890: WHERE aia.invoice_id = jatit.invoice_id
891: AND jatit.threshold_grp_id IS NOT NULL
892: AND aia.cancelled_date IS NULL
893: AND nvl(jatit.actual_tax_id, jatit.default_tax_id) = jitc.tax_id

Line 981: from jai_cmn_taxes_all a, ap_invoices_all base_invoices, po_vendor_sites_all povs, \* Added by Avanija for FVU3.6 *\

977: fnd_global.user_id,
978: sysdate,
979: fnd_global.user_id,
980: sysdate
981: from jai_cmn_taxes_all a, ap_invoices_all base_invoices, po_vendor_sites_all povs, \* Added by Avanija for FVU3.6 *\
982: ap_invoice_distributions_all aida, jai_ap_tds_vendor_hdrs jte
983: where jte.vendor_id = base_invoices.vendor_id
984: \* FVU3.6 -start *\
985: and povs.vendor_id = jte.vendor_id

Line 1185: JAI_CMN_TAXES_ALL jitc

1181: FROM ap_invoices_all aia,
1182: ap_invoice_distributions_all aida,
1183: jai_ap_tds_inv_taxes jatit,
1184: JAI_AP_TDS_VENDOR_HDRS jte,
1185: JAI_CMN_TAXES_ALL jitc
1186: WHERE aia.invoice_id = jatit.invoice_id
1187: AND jatit.threshold_grp_id IS NOT NULL
1188: AND jatit.threshold_grp_id = c_get_threshold_grp.threshold_grp_id
1189: AND aia.cancelled_date IS NULL

Line 1285: JAI_CMN_TAXES_ALL jitc

1281: FROM ap_invoices_all aia,
1282: ap_invoice_distributions_all aida,
1283: jai_ap_tds_inv_taxes jatit,
1284: JAI_AP_TDS_VENDOR_HDRS jte,
1285: JAI_CMN_TAXES_ALL jitc
1286: WHERE aia.invoice_id = jatit.invoice_id
1287: AND jatit.threshold_grp_id IS NOT NULL
1288: AND jatit.threshold_grp_id = c_get_threshold_grp.threshold_grp_id
1289: AND aia.cancelled_date IS NULL

Line 1734: ln_tax_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE;

1730: v_prepayment_amount_applied NUMBER;
1731:
1732: /* Bug 4353842. Added by Lakshmi Gopalsami */
1733: ln_check_number ap_checks_all.check_number%TYPE;
1734: ln_tax_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE;
1735: ln_tds_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE;
1736: ln_surcharge_rate JAI_CMN_TAXES_ALL.surcharge_rate%TYPE;
1737: ln_cess_rate JAI_CMN_TAXES_ALL.cess_rate%TYPE;
1738: ln_inv_amt ap_invoices_all.invoice_amount%TYPE;

Line 1735: ln_tds_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE;

1731:
1732: /* Bug 4353842. Added by Lakshmi Gopalsami */
1733: ln_check_number ap_checks_all.check_number%TYPE;
1734: ln_tax_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE;
1735: ln_tds_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE;
1736: ln_surcharge_rate JAI_CMN_TAXES_ALL.surcharge_rate%TYPE;
1737: ln_cess_rate JAI_CMN_TAXES_ALL.cess_rate%TYPE;
1738: ln_inv_amt ap_invoices_all.invoice_amount%TYPE;
1739:

Line 1736: ln_surcharge_rate JAI_CMN_TAXES_ALL.surcharge_rate%TYPE;

1732: /* Bug 4353842. Added by Lakshmi Gopalsami */
1733: ln_check_number ap_checks_all.check_number%TYPE;
1734: ln_tax_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE;
1735: ln_tds_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE;
1736: ln_surcharge_rate JAI_CMN_TAXES_ALL.surcharge_rate%TYPE;
1737: ln_cess_rate JAI_CMN_TAXES_ALL.cess_rate%TYPE;
1738: ln_inv_amt ap_invoices_all.invoice_amount%TYPE;
1739:
1740: -- added, Harshita for Bug 4525089

Line 1737: ln_cess_rate JAI_CMN_TAXES_ALL.cess_rate%TYPE;

1733: ln_check_number ap_checks_all.check_number%TYPE;
1734: ln_tax_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE;
1735: ln_tds_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE;
1736: ln_surcharge_rate JAI_CMN_TAXES_ALL.surcharge_rate%TYPE;
1737: ln_cess_rate JAI_CMN_TAXES_ALL.cess_rate%TYPE;
1738: ln_inv_amt ap_invoices_all.invoice_amount%TYPE;
1739:
1740: -- added, Harshita for Bug 4525089
1741:

Line 5338: from jai_cmn_taxes_all, fnd_lookup_values_vl

5334: B - In case of no deduction on account of declaration under section 197A */
5335: /* --Commented out by Chong for eTDS ER bug#16414088 20130330 Start
5336: CURSOR c_reason_non_deduction(p_tax_id IN NUMBER) IS
5337: select 'A'
5338: from jai_cmn_taxes_all, fnd_lookup_values_vl
5339: where tax_id = p_tax_id
5340: and upper(section_code) = lookup_code
5341: and (stform_type is not null or tax_rate = 0)
5342: and lookup_type = 'JAI_TDS_SECTION_ZERO_RATE_197'

Line 5345: from jai_cmn_taxes_all, fnd_lookup_values_vl

5341: and (stform_type is not null or tax_rate = 0)
5342: and lookup_type = 'JAI_TDS_SECTION_ZERO_RATE_197'
5343: UNION
5344: select 'B'
5345: from jai_cmn_taxes_all, fnd_lookup_values_vl
5346: where tax_id = p_tax_id
5347: and tax_rate = 0
5348: and upper(section_code) = lookup_code
5349: and lookup_type = 'JAI_TDS_SECTION_ZERO_RATE_197A';