APPS.JAI_AP_DTC_DEFAULTATION_PKG dependencies on JAI_AP_TDS_THHOLD_TYPES

Line 52: --| b. Added alias for table jai_ap_tds_thhold_types. Added table alias prefix to |

48: --| current_invoice_amount. Just get current invoice amount to see it if fall into any slab.|
49: --| Do this update for both Nature accounting mapping and vendor site defaultation method. |
50: --| 3) Update cursor c_get_thr_slab_id_mul to get slab for multi rate |
51: --| a. Added cp_legal_entity_id, cp_tds_section_code parameter |
52: --| b. Added alias for table jai_ap_tds_thhold_types. Added table alias prefix to |
53: --| threshold_hdr_id,threshold_type_id. |
54: --| 02/05/2013 Chong Updated For bug#16274617 |
55: --| 1) Add slab ID as paramter for cursor c_thrd_details, make sure this cursor only loop |
56: --| the targert slab ID. not read and check others slabs in the same threshold setup. |

Line 338: JAI_AP_TDS_THHOLD_TYPES JATTTY,

334: JATTTA.TAX_CATEGORY_ID,
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

Line 560: FROM jai_ap_tds_thhold_types

556: (SELECT FIRST_VALUE(threshold_type_id)
557: OVER (ORDER BY NVL(DEFAULT_TYPE,'N') DESC ,threshold_type_id ASC)
558: ------------------------------------------------
559: --Added by Chong for bug#15939571 20121212 End
560: FROM jai_ap_tds_thhold_types
561: WHERE threshold_hdr_id = cp_thr_hdr_id
562: AND threshold_type = cp_thr_type
563: AND cp_max_accounting_date between nvl(from_date,cp_max_accounting_date) and nvl(to_date, cp_max_accounting_date)
564: AND cp_min_accounting_date between nvl(from_date,cp_min_accounting_date) and nvl(to_date, cp_min_accounting_date))

Line 585: from jai_ap_tds_thhold_types jattt

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
586: where jattt.threshold_hdr_id = cp_threshold_hdr_id
587: and jattt.threshold_type = cp_threshold_type
588: /* Commented out by Chong for bug#15964390 20121213 Start
589: and cp_max_accounting_date between nvl(jattt.from_date,sysdate) and nvl(jattt.to_date, sysdate)

Line 652: FROM jai_ap_tds_thhold_types

648: -- cursor to validate accounting date for every threshold type
649: cursor c_valid_accounting_date (cp_thr_hdr_id number, cp_max_date date, cp_min_date date)
650: is
651: SELECT 'Y'
652: FROM jai_ap_tds_thhold_types
653: WHERE threshold_hdr_id = cp_thr_hdr_id
654: AND cp_max_date between nvl(from_date, cp_max_date) and nvl(to_date, cp_max_date)
655: AND cp_min_date between nvl(from_date, cp_min_date) and nvl(to_date, cp_min_date);
656: