DBA Data[Home] [Help]

APPS.PAY_CA_ARCHIVE dependencies on DUAL

Line 973: dual;

969: cursor cur_asg_action_id is
970: select
971: pay_assignment_actions_s.nextval
972: from
973: dual;
974:
975: cursor cur_prd_end_date(p_payroll_id number,
976: p_date date) is
977: select

Line 2163: dual;

2159: union
2160: select
2161: l_tax_unit_id tax_unit_id
2162: from
2163: dual;
2164:
2165: l_serial_number pay_assignment_actions.serial_number%TYPE;
2166:
2167: begin

Line 3480: FROM dual;

3476: declare
3477:
3478: cursor c_sequence is
3479: SELECT hr_assignment_sets_s.nextval
3480: FROM dual;
3481:
3482: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;
3483:
3484: CURSOR c_already_in_set is