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 JA_LOOKUPS

Line 245: FROM JA_LOOKUPS

241: -- cursor to get scetion code
242: cursor c_get_section_code
243: is
244: SELECT LOOKUP_CODE SECTION_CODE
245: FROM JA_LOOKUPS
246: WHERE LOOKUP_TYPE = 'JAI_TDS_SECTION';
247:
248: cursor c_sectionwise_cum_amt (cp_section_code VARCHAR2)
249: is

Line 446: FROM ja_lookups

442: -- cursor to get tds on service flg
443: cursor c_get_tds_on_service(cp_section_code varchar2)
444: is
445: SELECT 'Y'
446: FROM ja_lookups
447: WHERE lookup_type = 'JAI_TDS_SECTION_SERVICE'
448: --AND lookup_code = cp_section_code; -- commented out by zhiwei.xin for bug 13731393 on 29-Feb-2012
449: AND UPPER(lookup_code) = UPPER(cp_section_code); -- added by zhiwei.xin for bug 13731393 on 29-Feb-2012
450: