APPS.PAY_GB_RTI_OUTPUT dependencies on DUAL

Line 130: FROM dual;

126:
127: SELECT
128: fnd_global.local_chr(13) || fnd_global.local_chr(10)
129: INTO EOL
130: FROM dual;
131: IF p_null_allowed = 'N'
132: AND (TRIM(p_data) IS NULL
133: OR (p_datatype IN ('N','C')
134: AND to_number(p_data) = 0)) THEN

Line 154: INTO l_data FROM dual;

150:
151: ELSIF p_datatype = 'N' OR p_datatype = 'C' THEN
152: IF TRIM(p_format) IS NOT NULL THEN
153: SELECT to_char(to_number(p_data), p_format)
154: INTO l_data FROM dual;
155: ELSIF p_datatype = 'C' THEN -- Currency should be two decimal places
156: SELECT to_char(to_number(p_data), '99999999999999999999999999999999999990.99')
157: INTO l_data FROM dual;
158: END IF;

Line 157: INTO l_data FROM dual;

153: SELECT to_char(to_number(p_data), p_format)
154: INTO l_data FROM dual;
155: ELSIF p_datatype = 'C' THEN -- Currency should be two decimal places
156: SELECT to_char(to_number(p_data), '99999999999999999999999999999999999990.99')
157: INTO l_data FROM dual;
158: END IF;
159: l_output := '<' || trim(p_tag) || '>' || trim(l_data)
160: || ''||EOL;
161: END IF;

Line 276: select substr(to_char(sysdate, 'YYYYMMDD'),1,8),substr(to_char(sysdate, 'HH24MISS'),1,6) into l_system_date,l_system_time from dual;

272: l_test_indicator,
273: l_header_value;
274: close get_heder_details;
275:
276: select substr(to_char(sysdate, 'YYYYMMDD'),1,8),substr(to_char(sysdate, 'HH24MISS'),1,6) into l_system_date,l_system_time from dual;
277:
278: tab_header(payroll_prod_ver)
279: := convert_2_xml(l_payroll_prod_ver,'PAYROLL_PROD_VER');
280:

Line 1181: from dual;

1177: -- Create one assignment action for every assignment
1178: hr_utility.set_location('Archiving for assignment_id '||lv_assignment_id, 57);
1179: select pay_assignment_actions_s.nextval
1180: into lockingactid
1181: from dual;
1182:
1183: -- Insert assignment into pay_assignment_actions
1184: hr_nonrun_asact.insact
1185: (