DBA Data[Home] [Help]

APPS.PSP_ENC_CREATE_LINES dependencies on PSP_ENC_SUMMARY_LINES_S

Line 8503: SELECT psp_enc_summary_lines_s.NEXTVAL,

8499: attribute9, attribute10, payroll_action_id,
8500: proposed_termination_date, last_update_date, last_updated_by,
8501: last_update_login, created_by, creation_date,
8502: update_flag, org_id)
8503: SELECT psp_enc_summary_lines_s.NEXTVAL,
8504: p_business_group_id,
8505: p_set_of_books_id,
8506: pesl.enc_control_id,
8507: pesl.time_period_id,

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