DBA Data[Home] [Help]

APPS.PAY_SE_ALECTA dependencies on DUAL

Line 483: 'select 1 from dual where to_char(:payroll_action_id) = dummy';

479: WHEN OTHERS
480: THEN
481: -- Return cursor that selects no rows
482: p_sql :=
483: 'select 1 from dual where to_char(:payroll_action_id) = dummy';
484: END range_code;
485:
486: /* ASSIGNMENT ACTION CODE */
487: PROCEDURE assignment_action_code (

Line 623: FROM DUAL;

619: IF l_assignment_id <> rec_prepaid_assignments.assignment_id
620: THEN
621: SELECT pay_assignment_actions_s.NEXTVAL
622: INTO l_actid
623: FROM DUAL;
624:
625: -- Create the archive assignment action
626: hr_nonrun_asact.insact (l_actid
627: ,rec_prepaid_assignments.assignment_id