APPS.PSP_ENC_SUM_TRAN dependencies on PSP_ENC_PROCESS_ASSIGNMENTS

Line 665: UPDATE psp_enc_process_assignments pepa

661: IF (SQL%ROWCOUNT > 0) THEN
662: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process_phase to liquidate for liquidation re-processing');
663: END IF;
664:
665: UPDATE psp_enc_process_assignments pepa
666: SET assignment_status = 'P'
667: WHERE payroll_action_id = p_payroll_action_id
668: AND NOT EXISTS (SELECT 1
669: FROM psp_enc_summary_lines pesl

Line 678: UPDATE psp_enc_process_assignments pepa

674: IF (SQL%ROWCOUNT > 0) THEN
675: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated assignment_status to processed for summarized and transferred assignments count: '||SQL%ROWCOUNT);
676: END IF;
677:
678: UPDATE psp_enc_process_assignments pepa
679: SET assignment_status = 'S'
680: WHERE payroll_action_id = p_payroll_action_id
681: AND EXISTS (SELECT 1
682: FROM psp_enc_summary_lines pesl

Line 692: UPDATE psp_enc_process_assignments pepa

688: IF (SQL%ROWCOUNT > 0) THEN
689: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated assignment_status to summarize and transfer for assignments to be summarized and transferred count: '||SQL%ROWCOUNT);
690: END IF;
691:
692: UPDATE psp_enc_process_assignments pepa
693: SET assignment_status = 'L'
694: WHERE payroll_action_id = p_payroll_action_id
695: AND EXISTS (SELECT 1
696: FROM psp_enc_summary_lines pesl