DBA Data[Home] [Help]

APPS.PSP_LABOR_DIST dependencies on DUAL

Line 5275: from dual;

5271: psp_payroll_controls_s.nextval
5272: into l_line_id,
5273: g_sub_line_id,
5274: l_control_id
5275: from dual;
5276:
5277: insert into psp_payroll_lines
5278: (payroll_line_id,
5279: set_of_books_id,

Line 7328: from dual;

7324: for i in 1..t_dist_line_id.count
7325: loop
7326: select psp_distribution_lines_s.nextval
7327: into t_excess_line_id(i)
7328: from dual;
7329: end loop;
7330:
7331: forall i in 1..t_dist_line_id.count
7332: Insert into psp_distribution_lines(distribution_line_id,

Line 8807: select pay_assignment_actions_s.nextval into l_asgactid from dual;

8803: close get_assignments;
8804: for i in 1..t_asg_array.count
8805: loop
8806: --#fnd_file.put_line(fnd_file.log,'########asg_action_code#######PACTID, asg_id='||p_pactid||','|| t_asg_array(i));
8807: select pay_assignment_actions_s.nextval into l_asgactid from dual;
8808:
8809: hr_nonrun_asact.insact( l_asgactid ,
8810: pactid => p_pactid,
8811: chunk => p_chunk_num,