APPS.PSP_ENC_CREATE_LINES dependencies on DUAL

Line 3246: FROM DUAL;

3242: -- Get a number for enc control id
3243: BEGIN
3244: SELECT psp_enc_controls_s.nextval
3245: INTO l_enc_control_id
3246: FROM DUAL;
3247: END;
3248: End of comment for Create and Update multi thread enh. *****/
3249: enc_control_tab.r_enc_control_id(l_rec_no) := l_enc_control_id;
3250: enc_control_tab.r_no_of_dr(l_rec_no) := 0;

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

3372: CLOSE get_enc_control_id_cur;
3373:
3374: -- FORALL i IN 1 ..enc_control_tab.r_time_period_id.COUNT
3375: IF (p_enc_control_id IS NULL) THEN
3376: SELECT psp_enc_controls_s.NEXTVAL INTO p_enc_control_id FROM DUAL;
3377:
3378: INSERT INTO PSP_ENC_CONTROLS
3379: (time_period_id, enc_control_id,
3380: number_of_dr, number_of_cr,

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

6512:
6513: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' t_asg_array.COUNT: ' || t_asg_array.COUNT);
6514: FOR recno IN 1..t_asg_array.COUNT
6515: LOOP
6516: SELECT pay_assignment_actions_s.NEXTVAL INTO l_asg_action_id FROM DUAL;
6517: hr_nonrun_asact.insact(l_asg_action_id,
6518: pactid => p_pactid,
6519: chunk => p_chunk_num,
6520: object_id => t_asg_array(recno),

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

8359: CLOSE sum_lines_cur;
8360:
8361: FOR recno IN 1..t_sum_lines.enc_control_id.COUNT
8362: LOOP
8363: SELECT psp_enc_summary_lines_s.NEXTVAL INTO t_sum_lines.enc_summary_line_id(recno) FROM DUAL;
8364: END LOOP;
8365:
8366: FORALL recno IN 1..t_sum_lines.enc_control_id.COUNT
8367: INSERT INTO psp_enc_summary_lines