DBA Data[Home] [Help]

APPS.JAI_AP_DTC_GENERATION_PKG dependencies on JAI_AP_TDS_THHOLD_TAXES

Line 2693: jai_ap_tds_thhold_taxes jattt,

2689: jatts.tax_rate tax_rate,
2690: jattt.tax_id tax_id,
2691: (jitc.tax_rate-(nvl(jitc.surcharge_rate,0) + nvl(jitc.cess_rate,0) + nvl(jitc.sh_cess_rate,0))) tax_rate_orig
2692: from jai_ap_tds_thhold_slabs jatts,
2693: jai_ap_tds_thhold_taxes jattt,
2694: jai_cmn_taxes_all jitc
2695: where jatts.threshold_slab_id = jattt.threshold_slab_id
2696: and jattt.tax_id = jitc.tax_id
2697: and jatts.threshold_slab_id = p_threshold_slab_id;

Line 5152: JAI_AP_TDS_THHOLD_TAXES JATTTA

5148: ,jatth.threshold_hdr_id --Added by Chong for bug#16414088 20130313
5149: FROM JAI_AP_TDS_THHOLD_HDRS JATTH,
5150: JAI_AP_TDS_THHOLD_TYPES JATTTY,
5151: JAI_AP_TDS_THHOLD_SLABS JATTS,
5152: JAI_AP_TDS_THHOLD_TAXES JATTTA
5153: WHERE JATTS.THRESHOLD_SLAB_ID = p_threshold_slab_id
5154: AND JATTH.THRESHOLD_HDR_ID = JATTTY.THRESHOLD_HDR_ID
5155: AND JATTTY.THRESHOLD_TYPE_ID = JATTS.THRESHOLD_TYPE_ID
5156: AND JATTS.THRESHOLD_SLAB_ID = JATTTA.THRESHOLD_SLAB_ID