DBA Data[Home] [Help]

APPS.PAY_CA_ARCHIVE dependencies on DUAL

Line 977: dual;

973: cursor cur_asg_action_id is
974: select
975: pay_assignment_actions_s.nextval
976: from
977: dual;
978:
979: cursor cur_prd_end_date(p_payroll_id number,
980: p_date date) is
981: select

Line 2167: dual;

2163: union
2164: select
2165: l_tax_unit_id tax_unit_id
2166: from
2167: dual;
2168:
2169: l_serial_number pay_assignment_actions.serial_number%TYPE;
2170:
2171: begin

Line 3501: FROM dual;

3497: declare
3498:
3499: cursor c_sequence is
3500: SELECT hr_assignment_sets_s.nextval
3501: FROM dual;
3502:
3503: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;
3504:
3505: CURSOR c_already_in_set is