DBA Data[Home] [Help]

APPS.PAY_SE_ALECTA dependencies on DUAL

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

439: WHEN OTHERS
440: THEN
441: -- Return cursor that selects no rows
442: p_sql :=
443: 'select 1 from dual where to_char(:payroll_action_id) = dummy';
444: END range_code;
445:
446: /* ASSIGNMENT ACTION CODE */
447: PROCEDURE assignment_action_code (

Line 583: FROM DUAL;

579: IF l_assignment_id <> rec_prepaid_assignments.assignment_id
580: THEN
581: SELECT pay_assignment_actions_s.NEXTVAL
582: INTO l_actid
583: FROM DUAL;
584:
585: -- Create the archive assignment action
586: hr_nonrun_asact.insact (l_actid
587: ,rec_prepaid_assignments.assignment_id