APPS.PAY_CA_T4_MAG dependencies on DUAL

Line 260: FROM dual;

256: 'pay_ca_t4_mag.create_assignement_act', 40);
257:
258: SELECT pay_assignment_actions_s.nextval
259: INTO lockingactid
260: FROM dual;
261:
262: hr_utility.set_location(
263: 'pay_ca_t4_mag.create_assignement_act', 50);
264:

Line 416: into l_data from dual;

412: ';
413: ELSIF p_datatype = 'N' or p_datatype = 'C' then
414: IF TRIM(p_format) is not null then
415: select to_char(to_number(p_data), p_format)
416: into l_data from dual;
417:
418: ELSIF p_datatype = 'C' then -- Currency should be two decimal places
419: select to_char(to_number(p_data), '99999999999999999999999999999999999990.99')
420: into l_data from dual;

Line 420: into l_data from dual;

416: into l_data from dual;
417:
418: ELSIF p_datatype = 'C' then -- Currency should be two decimal places
419: select to_char(to_number(p_data), '99999999999999999999999999999999999990.99')
420: into l_data from dual;
421: END IF;
422: l_output := '<' || trim(p_tag) || '>' || trim(l_data) || '';
423: -- new datatype ('X') is added by rgottipa for bug 9984889
424: ELSIF p_datatype = 'X' then