DBA Data[Home] [Help]

APPS.PAY_SE_HOLIDAY_PAY_DEBT dependencies on DUAL

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

512: WHEN OTHERS
513: THEN
514: -- Return cursor that selects no rows
515: p_sql :=
516: 'select 1 from dual where to_char(:payroll_action_id) = dummy';
517: END range_code;
518:
519: /* ASSIGNMENT ACTION CODE */
520: PROCEDURE assignment_action_code (

Line 690: FROM DUAL;

686: IF l_assignment_id <> rec_prepaid_assignments.assignment_id
687: THEN
688: SELECT pay_assignment_actions_s.NEXTVAL
689: INTO l_actid
690: FROM DUAL;
691:
692: -- Create the archive assignment action
693: hr_nonrun_asact.insact (l_actid
694: , rec_prepaid_assignments.assignment_id