APPS.PAY_MX_SUA_MAG dependencies on DUAL

Line 700: FROM dual;

696: IF (ln_exist = 0 OR l_report = 0) THEN
697: IF (ln_person_id <> ln_prev_person_id) THEN
698: SELECT pay_assignment_actions_s.nextval
699: INTO ln_mag_asg_act_id
700: FROM dual;
701:
702: hr_utility_trace('Creating magtape assignment action '||
703: ln_mag_asg_act_id);
704: hr_nonrun_asact.insact(ln_mag_asg_act_id,

Line 896: FROM DUAL

892: CURSOR csr_asg_actions (cp_person_id number) IS
893: SELECT fnd_number.canonical_to_number(
894: pay_magtape_generic.get_parameter_value ('TRANSFER_ACT_ID')),
895: fnd_date.canonical_to_date(g_mag_end_date)
896: FROM DUAL
897: UNION
898: SELECT paa.assignment_action_id,
899: fnd_date.canonical_to_date(
900: pay_mx_utility.get_legi_param_val('END_DATE',