APPS.PAY_CA_T4A_CANCEL_MAG dependencies on DUAL

Line 204: FROM dual;

200: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date,'DD-Mon-YYYY'));
201: hr_utility.trace('x------------------------------------------------x');
202: SELECT pay_assignment_actions_s.nextval
203: INTO lockingactid
204: FROM dual;
205: hr_utility.trace('New T4A Cancel Action = ' ||to_char(lockingactid));
206: hr_utility.set_location('pay_ca_t4a_cancel_mag.action_creation', 30);
207: hr_nonrun_asact.insact(lockingactid
208: ,l_assignment_id

Line 557: FROM dual;

553: end if; */
554: SELECT
555: fnd_global.local_chr(13) || fnd_global.local_chr(10)
556: INTO EOL
557: FROM dual;
558: IF p_null_allowed = 'N'
559: AND (TRIM(p_data) IS NULL
560: OR (p_datatype IN ('N','C')
561: AND to_number(p_data) = 0)) THEN

Line 581: INTO l_data FROM dual;

577: -- hr_utility.trace('l_output='||l_output);
578: ELSIF p_datatype = 'N' OR p_datatype = 'C' THEN
579: IF TRIM(p_format) IS NOT NULL THEN
580: SELECT to_char(to_number(p_data), p_format)
581: INTO l_data FROM dual;
582: ELSIF p_datatype = 'C' THEN -- Currency should be two decimal places
583: SELECT to_char(to_number(p_data), '99999999999999999999999999999999999990.99')
584: INTO l_data FROM dual;
585: END IF;

Line 584: INTO l_data FROM dual;

580: SELECT to_char(to_number(p_data), p_format)
581: INTO l_data FROM dual;
582: ELSIF p_datatype = 'C' THEN -- Currency should be two decimal places
583: SELECT to_char(to_number(p_data), '99999999999999999999999999999999999990.99')
584: INTO l_data FROM dual;
585: END IF;
586: l_output := '<' || trim(p_tag) || '>' || trim(l_data)
587: || ''||EOL;
588: END IF;