APPS.JAI_AP_DTC_DEFAULTATION_PKG dependencies on JAI_AP_TDS_TH_VSITE_V

Line 288: -- cursor to fetch JAI_AP_TDS_TH_VSITE_V

284: ,ACCOUNTING_DATE;
285: ----------------------------------------------
286: -- Added by Chong for bug#15939571 on 20121213 End
287:
288: -- cursor to fetch JAI_AP_TDS_TH_VSITE_V
289: cursor c_tds_th_vsite_v (cp_tds_vendor_tlc JAI_AP_TDS_VENDOR_HDRS.TDS_VENDOR_TYPE_LOOKUP_CODE%TYPE,
290: cp_vendor_id JAI_AP_TDS_VENDOR_HDRS.VENDOR_ID%TYPE,
291: cp_vendor_site_id PO_VENDOR_SITES_ALL.VENDOR_SITE_ID%TYPE,
292: cp_tds_sec_code JAI_AP_TDS_THHOLD_HDRS.SECTION_CODE%TYPE)

Line 297: FROM JAI_AP_TDS_TH_VSITE_V

293: is
294: SELECT THRESHOLD_HDR_ID,
295: NVL(EXCEPTION_SETUP_FLAG,'N'),
296: NVL(MULTIPLE_RATE_SETUP,'N')
297: FROM JAI_AP_TDS_TH_VSITE_V
298: WHERE TDS_VENDOR_TYPE_LOOKUP_CODE = cp_tds_vendor_tlc
299: AND VENDOR_ID = cp_vendor_id
300: AND VENDOR_SITE_ID = cp_vendor_site_id
301: AND SECTION_CODE = cp_tds_sec_code;

Line 663: FROM JAI_AP_TDS_TH_VSITE_V JATVV

659: cp_sec_code varchar2)
660: is
661: SELECT threshold_hdr_id,
662: NVL(MULTIPLE_RATE_SETUP,'N')
663: FROM JAI_AP_TDS_TH_VSITE_V JATVV
664: WHERE tds_vendor_type_lookup_code = cp_vendor_tlc
665: AND section_code = cp_sec_code
666: AND section_type = 'TDS_SECTION'
667: AND exception_setup_flag = 'N'