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.PAY_INS_CUSTOM_TEMPLATE dependencies on FND_APPLICATION

Line 55: AND application_id = (SELECT application_id FROM fnd_application WHERE application_short_name = 'PAY')

51: CURSOR csr_get_temp_codes(p_lookup_type IN VARCHAR) IS
52: SELECT lookup_code, meaning
53: FROM fnd_common_lookups
54: WHERE lookup_type = p_lookup_type
55: AND application_id = (SELECT application_id FROM fnd_application WHERE application_short_name = 'PAY')
56: AND sysdate between nvl(start_date_active,sysdate) AND nvl(end_date_active,sysdate)
57: AND enabled_flag = 'Y';
58:
59: CURSOR csr_temp_code_dtls(p_template_code IN VARCHAR,

Line 147: AND application_id = (SELECT application_id FROM fnd_application WHERE application_short_name = 'PAY')

143: SELECT description INTO lv_rg_short_name
144: FROM fnd_common_lookups
145: WHERE lookup_type = 'GEN_CUST_TEMP_CONC_PROGS'
146: AND lookup_code = p_conc_prog
147: AND application_id = (SELECT application_id FROM fnd_application WHERE application_short_name = 'PAY')
148: AND sysdate between nvl(start_date_active,sysdate) AND nvl(end_date_active,sysdate)
149: AND enabled_flag = 'Y';
150: fnd_file.put_line(fnd_file.log,'Report Group Short Name : ' || lv_rg_short_name);
151: EXCEPTION