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_NO_PAYSLIP_REPORT dependencies on DUAL

Line 110: EXECUTE IMMEDIATE 'SELECT pay_'||p_legislation_code||'_rules.get_payslip_sort_order1 FROM DUAL'

106: l_sort_order VARCHAR2(20);
107: BEGIN
108: IF p_type = 'LE' THEN
109: --
110: EXECUTE IMMEDIATE 'SELECT pay_'||p_legislation_code||'_rules.get_payslip_sort_order1 FROM DUAL'
111: INTO l_sort_order;
112: ELSIF p_type = 'ORG' THEN
113: --
114: EXECUTE IMMEDIATE 'SELECT pay_'||p_legislation_code||'_rules.get_payslip_sort_order2 FROM DUAL'

Line 114: EXECUTE IMMEDIATE 'SELECT pay_'||p_legislation_code||'_rules.get_payslip_sort_order2 FROM DUAL'

110: EXECUTE IMMEDIATE 'SELECT pay_'||p_legislation_code||'_rules.get_payslip_sort_order1 FROM DUAL'
111: INTO l_sort_order;
112: ELSIF p_type = 'ORG' THEN
113: --
114: EXECUTE IMMEDIATE 'SELECT pay_'||p_legislation_code||'_rules.get_payslip_sort_order2 FROM DUAL'
115: INTO l_sort_order;
116: ELSIF p_type = 'NAME' THEN
117: --
118: EXECUTE IMMEDIATE 'SELECT pay_'||p_legislation_code||'_rules.get_payslip_sort_order3 FROM DUAL'

Line 118: EXECUTE IMMEDIATE 'SELECT pay_'||p_legislation_code||'_rules.get_payslip_sort_order3 FROM DUAL'

114: EXECUTE IMMEDIATE 'SELECT pay_'||p_legislation_code||'_rules.get_payslip_sort_order2 FROM DUAL'
115: INTO l_sort_order;
116: ELSIF p_type = 'NAME' THEN
117: --
118: EXECUTE IMMEDIATE 'SELECT pay_'||p_legislation_code||'_rules.get_payslip_sort_order3 FROM DUAL'
119: INTO l_sort_order;
120: END IF;
121: --
122: RETURN l_sort_order;

Line 266: --EXECUTE IMMEDIATE 'SELECT pay_'||l_legislation_code||'_rules.get_payroll_token FROM DUAL' into l_token;

262: ,l_legislation_code);
263: --
264: l_start_dt := TO_DATE(l_start_date,'YYYY/MM/DD');
265: l_end_dt := TO_DATE(l_end_date,'YYYY/MM/DD');
266: --EXECUTE IMMEDIATE 'SELECT pay_'||l_legislation_code||'_rules.get_payroll_token FROM DUAL' into l_token;
267: --
268: IF g_pa_token IS NULL THEN
269: DECLARE
270: BEGIN

Line 376: FROM DUAL ;

372: l_final_xml_string := NULL ;
373: --
374: SELECT fnd_global.local_chr(13) || fnd_global.local_chr(10)
375: INTO EOL
376: FROM DUAL ;
377: --
378: l_final_xml_string := '' || EOL ;
379: --
380: pay_core_files.write_to_magtape_lob(l_final_xml_string);