APPS.PSP_ENC_CREATE_LINES dependencies on DUAL

Line 3477: FROM DUAL;

3473: -- Get a number for enc control id
3474: BEGIN
3475: SELECT psp_enc_controls_s.nextval
3476: INTO l_enc_control_id
3477: FROM DUAL;
3478: END;
3479: End of comment for Create and Update multi thread enh. *****/
3480: enc_control_tab.r_enc_control_id(l_rec_no) := l_enc_control_id;
3481: enc_control_tab.r_no_of_dr(l_rec_no) := 0;

Line 3608: SELECT psp_enc_controls_s.NEXTVAL INTO p_enc_control_id FROM DUAL;

3604: CLOSE get_enc_control_id_cur;
3605:
3606: -- FORALL i IN 1 ..enc_control_tab.r_time_period_id.COUNT
3607: IF (p_enc_control_id IS NULL) THEN
3608: SELECT psp_enc_controls_s.NEXTVAL INTO p_enc_control_id FROM DUAL;
3609:
3610: INSERT INTO PSP_ENC_CONTROLS
3611: (time_period_id, enc_control_id,
3612: number_of_dr, number_of_cr,

Line 6773: SELECT pay_assignment_actions_s.NEXTVAL INTO l_asg_action_id FROM DUAL;

6769:
6770: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' t_asg_array.COUNT: ' || t_asg_array.COUNT);
6771: FOR recno IN 1..t_asg_array.COUNT
6772: LOOP
6773: SELECT pay_assignment_actions_s.NEXTVAL INTO l_asg_action_id FROM DUAL;
6774: hr_nonrun_asact.insact(l_asg_action_id,
6775: pactid => p_pactid,
6776: chunk => p_chunk_num,
6777: object_id => t_asg_array(recno),

Line 8685: SELECT psp_enc_summary_lines_s.NEXTVAL INTO t_sum_lines.enc_summary_line_id(recno) FROM DUAL;

8681: CLOSE sum_lines_cur;
8682:
8683: FOR recno IN 1..t_sum_lines.enc_control_id.COUNT
8684: LOOP
8685: SELECT psp_enc_summary_lines_s.NEXTVAL INTO t_sum_lines.enc_summary_line_id(recno) FROM DUAL;
8686: END LOOP;
8687:
8688: FORALL recno IN 1..t_sum_lines.enc_control_id.COUNT
8689: INSERT INTO psp_enc_summary_lines