APPS.PAY_GB_RTI_FPS_OUTPUT dependencies on DUAL

Line 69: FROM dual;

65:
66: SELECT
67: fnd_global.local_chr(13) || fnd_global.local_chr(10)
68: INTO EOL
69: FROM dual;
70: IF p_null_allowed = 'N'
71: AND (TRIM(p_data) IS NULL
72: OR (p_datatype IN ('N','C')
73: AND to_number(p_data) = 0)) THEN

Line 93: INTO l_data FROM dual;

89:
90: ELSIF p_datatype = 'N' OR p_datatype = 'C' THEN
91: IF TRIM(p_format) IS NOT NULL THEN
92: SELECT to_char(to_number(p_data), p_format)
93: INTO l_data FROM dual;
94: ELSIF p_datatype = 'C' THEN -- Currency should be two decimal places
95: SELECT to_char(to_number(p_data), '99999999999999999999999999999999999990.99')
96: INTO l_data FROM dual;
97: END IF;

Line 96: INTO l_data FROM dual;

92: SELECT to_char(to_number(p_data), p_format)
93: INTO l_data FROM dual;
94: ELSIF p_datatype = 'C' THEN -- Currency should be two decimal places
95: SELECT to_char(to_number(p_data), '99999999999999999999999999999999999990.99')
96: INTO l_data FROM dual;
97: END IF;
98: l_output := '<' || trim(p_tag) || '>' || trim(l_data)
99: || ''||EOL;
100: END IF;

Line 1652: from dual;

1648: -- Create one assignment action for every assignment
1649: hr_utility.set_location('Archiving for assignment_id '||lv_assignment_id, 57);
1650: select pay_assignment_actions_s.nextval
1651: into lockingactid
1652: from dual;
1653:
1654: -- Insert assignment into pay_assignment_actions
1655: hr_nonrun_asact.insact
1656: (