APPS.PAY_CA_T4A_MAG dependencies on DUAL

Line 292: FROM dual;

288: 'pay_ca_t4a_mag.create_assignement_act', 40);
289:
290: SELECT pay_assignment_actions_s.nextval
291: INTO lockingactid
292: FROM dual;
293: hr_utility.set_location(
294: 'pay_ca_t4a_mag.create_assignement_act', 50);
295:
296: hr_nonrun_asact.insact(lockingactid, l_assignment_id,

Line 725: into l_data from dual;

721: ';
722: ELSIF p_datatype = 'N' or p_datatype = 'C' then
723: IF TRIM(p_format) is not null then
724: select to_char(to_number(p_data), p_format)
725: into l_data from dual;
726: ELSIF p_datatype = 'C' then -- Currency should be two decimal places
727: select to_char(to_number(p_data), '99999999999999999999999999999999999990.99')
728: into l_data from dual;
729: END IF;

Line 728: into l_data from dual;

724: select to_char(to_number(p_data), p_format)
725: into l_data from dual;
726: ELSIF p_datatype = 'C' then -- Currency should be two decimal places
727: select to_char(to_number(p_data), '99999999999999999999999999999999999990.99')
728: into l_data from dual;
729: END IF;
730: l_output := '<' || trim(p_tag) || '>' || trim(l_data) || '
731: ';
732: END IF;