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_DTC_DEFAULTATION_PKG dependencies on JAI_AP_TDS_THHOLD_HDRS

Line 292: cp_tds_sec_code JAI_AP_TDS_THHOLD_HDRS.SECTION_CODE%TYPE)

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)
293: is
294: SELECT THRESHOLD_HDR_ID,
295: NVL(EXCEPTION_SETUP_FLAG,'N'),
296: NVL(MULTIPLE_RATE_SETUP,'N')

Line 337: FROM JAI_AP_TDS_THHOLD_HDRS JATTH,

333: JATTS.TO_AMOUNT,
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

Line 743: ln_thr_header_id JAI_AP_TDS_THHOLD_HDRS.THRESHOLD_HDR_ID%TYPE;

739: lv_tax_default_option VARCHAR2(40);
740: lv_tds_vendor_default_flag VARCHAR2(40) := NULL; --Added by Chong for bug#16367707
741: -- la_aida_tab AIDA_TYPE := AIDA_TYPE(); commented for test by ChongLei
742: la_cum_amt_tab CUM_AMT_TYPE := CUM_AMT_TYPE();
743: ln_thr_header_id JAI_AP_TDS_THHOLD_HDRS.THRESHOLD_HDR_ID%TYPE;
744: lv_exp_setup_flg JAI_AP_TDS_THHOLD_HDRS.EXCEPTION_SETUP_FLAG%TYPE;
745: lv_multi_rate_flg JAI_AP_TDS_THHOLD_HDRS.MULTIPLE_RATE_SETUP%TYPE;
746: ln_effective_amount NUMBER;
747: lv_pan_no VARCHAR2(30);

Line 744: lv_exp_setup_flg JAI_AP_TDS_THHOLD_HDRS.EXCEPTION_SETUP_FLAG%TYPE;

740: lv_tds_vendor_default_flag VARCHAR2(40) := NULL; --Added by Chong for bug#16367707
741: -- la_aida_tab AIDA_TYPE := AIDA_TYPE(); commented for test by ChongLei
742: la_cum_amt_tab CUM_AMT_TYPE := CUM_AMT_TYPE();
743: ln_thr_header_id JAI_AP_TDS_THHOLD_HDRS.THRESHOLD_HDR_ID%TYPE;
744: lv_exp_setup_flg JAI_AP_TDS_THHOLD_HDRS.EXCEPTION_SETUP_FLAG%TYPE;
745: lv_multi_rate_flg JAI_AP_TDS_THHOLD_HDRS.MULTIPLE_RATE_SETUP%TYPE;
746: ln_effective_amount NUMBER;
747: lv_pan_no VARCHAR2(30);
748: lv_tan_no VARCHAR2(30);

Line 745: lv_multi_rate_flg JAI_AP_TDS_THHOLD_HDRS.MULTIPLE_RATE_SETUP%TYPE;

741: -- la_aida_tab AIDA_TYPE := AIDA_TYPE(); commented for test by ChongLei
742: la_cum_amt_tab CUM_AMT_TYPE := CUM_AMT_TYPE();
743: ln_thr_header_id JAI_AP_TDS_THHOLD_HDRS.THRESHOLD_HDR_ID%TYPE;
744: lv_exp_setup_flg JAI_AP_TDS_THHOLD_HDRS.EXCEPTION_SETUP_FLAG%TYPE;
745: lv_multi_rate_flg JAI_AP_TDS_THHOLD_HDRS.MULTIPLE_RATE_SETUP%TYPE;
746: ln_effective_amount NUMBER;
747: lv_pan_no VARCHAR2(30);
748: lv_tan_no VARCHAR2(30);
749: lv_default_section_code JAI_AP_TDS_VENDOR_HDRS.SECTION_CODE%TYPE;