APPS.PAY_CA_T4_AMEND_MAG dependencies on DUAL

Line 230: FROM dual;

226: ' End Date: '|| to_char(l_effective_end_date,'DD-Mon-YYYY'));
227:
228: SELECT pay_assignment_actions_s.nextval
229: INTO lockingactid
230: FROM dual;
231: hr_utility.trace('New T4 Amend Action = ' ||to_char(lockingactid));
232:
233: BEGIN
234: OPEN c_get_fed_amend_flag(l_assignment_action_id,

Line 632: FROM dual;

628: end if; */
629: SELECT
630: fnd_global.local_chr(13) || fnd_global.local_chr(10)
631: INTO EOL
632: FROM dual;
633: IF p_null_allowed = 'N'
634: AND (TRIM(p_data) IS NULL
635: OR (p_datatype IN ('N','C')
636: AND to_number(p_data) = 0)) THEN

Line 656: INTO l_data FROM dual;

652: -- hr_utility.trace('l_output='||l_output);
653: ELSIF p_datatype = 'N' OR p_datatype = 'C' THEN
654: IF TRIM(p_format) IS NOT NULL THEN
655: SELECT to_char(to_number(p_data), p_format)
656: INTO l_data FROM dual;
657: ELSIF p_datatype = 'C' THEN -- Currency should be two decimal places
658: SELECT to_char(to_number(p_data), '99999999999999999999999999999999999990.99')
659: INTO l_data FROM dual;
660: END IF;

Line 659: INTO l_data FROM dual;

655: SELECT to_char(to_number(p_data), p_format)
656: INTO l_data FROM dual;
657: ELSIF p_datatype = 'C' THEN -- Currency should be two decimal places
658: SELECT to_char(to_number(p_data), '99999999999999999999999999999999999990.99')
659: INTO l_data FROM dual;
660: END IF;
661: l_output := '<' || trim(p_tag) || '>' || trim(l_data)
662: || ''||EOL;
663: ELSIF p_datatype = 'Z' then