APPS.PAY_CA_T4A_AMEND_MAG dependencies on DUAL

Line 241: FROM dual;

237: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date,'DD-Mon-YYYY'));
238: hr_utility.trace('x------------------------------------------------x');
239: SELECT pay_assignment_actions_s.nextval
240: INTO lockingactid
241: FROM dual;
242: hr_utility.trace('New T4A Amend Action = ' ||to_char(lockingactid));
243:
244: BEGIN
245: OPEN c_get_fed_amend_flag(l_assignment_action_id,

Line 643: FROM dual;

639: end if; */
640: SELECT
641: fnd_global.local_chr(13) || fnd_global.local_chr(10)
642: INTO EOL
643: FROM dual;
644: IF p_null_allowed = 'N'
645: AND (TRIM(p_data) IS NULL
646: OR (p_datatype IN ('N','C')
647: AND to_number(p_data) = 0)) THEN

Line 667: INTO l_data FROM dual;

663: -- hr_utility.trace('l_output='||l_output);
664: ELSIF p_datatype = 'N' OR p_datatype = 'C' THEN
665: IF TRIM(p_format) IS NOT NULL THEN
666: SELECT to_char(to_number(p_data), p_format)
667: INTO l_data FROM dual;
668: ELSIF p_datatype = 'C' THEN -- Currency should be two decimal places
669: SELECT to_char(to_number(p_data), '99999999999999999999999999999999999990.99')
670: INTO l_data FROM dual;
671: END IF;

Line 670: INTO l_data FROM dual;

666: SELECT to_char(to_number(p_data), p_format)
667: INTO l_data FROM dual;
668: ELSIF p_datatype = 'C' THEN -- Currency should be two decimal places
669: SELECT to_char(to_number(p_data), '99999999999999999999999999999999999990.99')
670: INTO l_data FROM dual;
671: END IF;
672: l_output := '<' || trim(p_tag) || '>' || trim(l_data)
673: || ''||EOL;
674: END IF;