APPS.PSP_ENC_LIQ_TRAN dependencies on PSP_ENC_PROCESS_ASSIGNMENTS

Line 1515: UPDATE psp_enc_process_assignments pepa

1511: END IF;
1512: END IF;
1513: End of comment for Create and Update multi thread *****/
1514:
1515: UPDATE psp_enc_process_assignments pepa
1516: SET assignment_status = 'P'
1517: WHERE payroll_action_id = p_payroll_action_id
1518: AND NOT EXISTS (SELECT 1
1519: FROM psp_enc_summary_lines pesl

Line 1525: UPDATE psp_enc_process_assignments pepa

1521: AND pesl.assignment_id = pepa.assignment_id
1522: AND pesl.payroll_id = pepa.payroll_id
1523: AND pesl.status_code = 'N');
1524:
1525: UPDATE psp_enc_process_assignments pepa
1526: SET assignment_status = 'S'
1527: WHERE payroll_action_id = p_payroll_action_id
1528: AND EXISTS (SELECT 1
1529: FROM psp_enc_summary_lines pesl

Line 1536: UPDATE psp_enc_process_assignments pepa

1532: AND pesl.payroll_id = pepa.payroll_id
1533: AND pesl.status_code = 'N'
1534: AND pesl.superceded_line_id IS NULL);
1535:
1536: UPDATE psp_enc_process_assignments pepa
1537: SET assignment_status = 'L'
1538: WHERE payroll_action_id = p_payroll_action_id
1539: AND EXISTS (SELECT 1
1540: FROM psp_enc_summary_lines pesl