DBA Data[Home] [Help]

APPS.PAY_MX_SUA_MAG dependencies on DUAL

Line 606: FROM dual;

602:
603: IF (ln_person_id <> ln_prev_person_id) THEN
604: SELECT pay_assignment_actions_s.nextval
605: INTO ln_mag_asg_act_id
606: FROM dual;
607:
608: hr_utility_trace('Creating magtape assignment action '||
609: ln_mag_asg_act_id);
610: hr_nonrun_asact.insact(ln_mag_asg_act_id,

Line 781: FROM DUAL

777: CURSOR csr_asg_actions (cp_person_id number) IS
778: SELECT fnd_number.canonical_to_number(
779: pay_magtape_generic.get_parameter_value ('TRANSFER_ACT_ID')),
780: fnd_date.canonical_to_date(g_mag_end_date)
781: FROM DUAL
782: UNION
783: SELECT paa.assignment_action_id,
784: fnd_date.canonical_to_date(
785: pay_mx_utility.get_legi_param_val('END_DATE',