DBA Data[Home] [Help]

APPS.JAI_AP_DTC_DEFAULTATION_PKG dependencies on JAI_AP_TDS_THHOLD_SLABS

Line 339: JAI_AP_TDS_THHOLD_SLABS JATTS,

335: JATTTA.OPERATING_UNIT_ID
336: ,JATTH.THRESHOLD_HDR_ID --Added by Chong for bug#13740866 20121213
337: FROM JAI_AP_TDS_THHOLD_HDRS JATTH,
338: JAI_AP_TDS_THHOLD_TYPES JATTTY,
339: JAI_AP_TDS_THHOLD_SLABS JATTS,
340: JAI_AP_TDS_THHOLD_TAXES JATTTA
341: WHERE JATTH.THRESHOLD_HDR_ID = cp_thrd_header_id
342: AND JATTH.THRESHOLD_HDR_ID = JATTTY.THRESHOLD_HDR_ID
343: AND JATTTY.THRESHOLD_TYPE_ID = JATTS.THRESHOLD_TYPE_ID

Line 550: FROM jai_ap_tds_thhold_slabs

546: cp_max_accounting_date date,
547: cp_min_accounting_date date)
548: is
549: SELECT threshold_slab_id
550: FROM jai_ap_tds_thhold_slabs
551: WHERE threshold_hdr_id = cp_thr_hdr_id
552: AND threshold_type_id in
553: -- (SELECT threshold_type_id --Commented by Chong for bug#15939571 20121212
554: --Added by Chong for bug#15939571 20121212 Start

Line 581: from jai_ap_tds_thhold_slabs

577: ,cp_accounting_date Date --Added by Chong for Bug#15939571 2012/12/12
578: )
579: is
580: select threshold_slab_id
581: from jai_ap_tds_thhold_slabs
582: where threshold_hdr_id = cp_threshold_hdr_id
583: and threshold_type_id in
584: ( select jattt.threshold_type_id
585: from jai_ap_tds_thhold_types jattt