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 381: into l_data from dual;

377: ';
378: ELSIF p_datatype = 'N' or p_datatype = 'C' then
379: IF TRIM(p_format) is not null then
380: select to_char(to_number(p_data), p_format)
381: into l_data from dual;
382: ELSIF p_datatype = 'C' then -- Currency should be two decimal places
383: select to_char(to_number(p_data), '99999999999999999999999999999999999990.99')
384: into l_data from dual;
385: END IF;

Line 384: into l_data from dual;

380: select to_char(to_number(p_data), p_format)
381: into l_data from dual;
382: ELSIF p_datatype = 'C' then -- Currency should be two decimal places
383: select to_char(to_number(p_data), '99999999999999999999999999999999999990.99')
384: into l_data from dual;
385: END IF;
386: l_output := '<' || trim(p_tag) || '>' || trim(l_data) || '
387: ';
388: END IF;