DBA Data[Home] [Help]

APPS.PSP_ENC_CREATE_LINES dependencies on PSP_ENC_SUMMARY_LINES_S

Line 8182: SELECT psp_enc_summary_lines_s.NEXTVAL,

8178: attribute9, attribute10, payroll_action_id,
8179: proposed_termination_date, last_update_date, last_updated_by,
8180: last_update_login, created_by, creation_date,
8181: update_flag, org_id)
8182: SELECT psp_enc_summary_lines_s.NEXTVAL,
8183: p_business_group_id,
8184: p_set_of_books_id,
8185: pesl.enc_control_id,
8186: pesl.time_period_id,

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