APPS.PSP_ENC_LIQ_TRAN dependencies on PSP_ENC_PROCESS_ASSIGNMENTS

Line 1558: UPDATE psp_enc_process_assignments pepa

1554: END IF;
1555: END IF;
1556: End of comment for Create and Update multi thread *****/
1557:
1558: UPDATE psp_enc_process_assignments pepa
1559: SET assignment_status = 'P'
1560: WHERE payroll_action_id = p_payroll_action_id
1561: AND NOT EXISTS (SELECT 1
1562: FROM psp_enc_summary_lines pesl

Line 1571: UPDATE psp_enc_process_assignments pepa

1567:
1568: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Update psp_enc_process_assignmnets set assignment_status to P sql%rowcount'||sql%rowcount);
1569:
1570:
1571: UPDATE psp_enc_process_assignments pepa
1572: SET assignment_status = 'S'
1573: WHERE payroll_action_id = p_payroll_action_id
1574: AND EXISTS (SELECT 1
1575: FROM psp_enc_summary_lines pesl

Line 1585: UPDATE psp_enc_process_assignments pepa

1581:
1582: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Update psp_enc_process_assignmnets set assignment_status to S sql%rowcount'||sql%rowcount);
1583:
1584:
1585: UPDATE psp_enc_process_assignments pepa
1586: SET assignment_status = 'L'
1587: WHERE payroll_action_id = p_payroll_action_id
1588: AND EXISTS (SELECT 1
1589: FROM psp_enc_summary_lines pesl