APPS.PSP_ENC_LIQ_TRAN dependencies on PSP_ENC_CHANGED_ASSIGNMENTS

Line 2002: AND EXISTS (SELECT 1 FROM psp_enc_changed_assignments peca

1998: AND pec.set_of_books_id = g_sob_id
1999: AND (pec.gl_phase IS NULL or pec.gl_phase = 'TieBack'))
2000: AND pesl.gl_project_flag = 'G'
2001: AND pesl.status_code = 'A'
2002: AND EXISTS (SELECT 1 FROM psp_enc_changed_assignments peca
2003: WHERE peca.assignment_id = pesl.assignment_id
2004: AND peca.request_id IS NOT NULL
2005: AND peca.payroll_id =p_payroll_id)
2006: AND EXISTS (SELECT 1

Line 2045: AND EXISTS (SELECT 1 FROM psp_enc_changed_assignments peca

2041: AND pec.set_of_books_id = g_sob_id
2042: AND (pec.gl_phase IS NULL or pec.gl_phase = 'TieBack'))
2043: AND pesl.gl_project_flag = 'G'
2044: AND pesl.status_code = 'A'
2045: AND EXISTS (SELECT 1 FROM psp_enc_changed_assignments peca
2046: WHERE peca.assignment_id = pesl.assignment_id
2047: AND peca.request_id IS NOT NULL
2048: AND peca.payroll_id = p_payroll_id
2049: AND peca.change_type IN ('LS', 'ET', 'AS', 'QU'))

Line 2309: AND EXISTS (SELECT 1 FROM psp_enc_changed_assignments peca

2305: OR
2306: (p_action_type IN ('Q', 'U') AND EXISTS
2307: (SELECT 1 FROM PSP_ENC_LINES_HISTORY PELH WHERE PELH.ENC_SUMMARY_LINE_ID = PESL.ENC_SUMMARY_LINE_ID
2308: AND PELH.CHANGE_FLAG = 'N')
2309: AND EXISTS (SELECT 1 FROM psp_enc_changed_assignments peca
2310: WHERE peca.assignment_id = pesl.assignment_id
2311: AND peca.request_id IS NOT NULL
2312: AND peca.payroll_id =p_payroll_id
2313: AND ((p_action_type = 'Q' and peca.change_type IN ('LS', 'ET', 'AS', 'QU'))

Line 4445: AND EXISTS (SELECT 1 FROM psp_enc_changed_assignments peca

4441: AND pec.set_of_books_id = g_sob_id
4442: AND (pec.gms_phase IS NULL or pec.gms_phase = 'TieBack'))
4443: AND gl_project_flag = 'P'
4444: AND status_code = 'A'
4445: AND EXISTS (SELECT 1 FROM psp_enc_changed_assignments peca
4446: WHERE peca.assignment_id = pesl.assignment_id
4447: AND peca.request_id IS NOT NULL
4448: AND peca.payroll_id = p_payroll_id)
4449: AND EXISTS (SELECT 1

Line 4495: AND EXISTS (SELECT 1 FROM psp_enc_changed_assignments peca

4491: AND pec.set_of_books_id = g_sob_id
4492: AND (pec.gms_phase IS NULL or pec.gms_phase = 'TieBack'))
4493: AND gl_project_flag = 'P'
4494: AND status_code = 'A'
4495: AND EXISTS (SELECT 1 FROM psp_enc_changed_assignments peca
4496: WHERE peca.assignment_id = pesl.assignment_id
4497: AND peca.request_id IS NOT NULL
4498: AND peca.payroll_id = p_payroll_id
4499: AND peca.change_type IN ('LS', 'ET', 'AS', 'QU'))

Line 4797: AND EXISTS (SELECT 1 FROM psp_enc_changed_assignments peca

4793: OR
4794: (p_action_type IN ('Q', 'U') AND EXISTS
4795: (SELECT 1 FROM PSP_ENC_LINES_HISTORY PELH WHERE PELH.ENC_SUMMARY_LINE_ID = PESL.ENC_SUMMARY_LINE_ID
4796: AND PELH.CHANGE_FLAG = 'N')
4797: AND EXISTS (SELECT 1 FROM psp_enc_changed_assignments peca
4798: WHERE peca.assignment_id = pesl.assignment_id
4799: AND peca.request_id IS NOT NULL
4800: AND peca.payroll_id =p_payroll_id
4801: AND ((p_action_type = 'Q' and peca.change_type IN ('LS', 'ET', 'AS', 'QU'))

Line 6937: FROM psp_enc_changed_assignments peca

6933:
6934: CURSOR get_rec_to_move IS
6935: SELECT DISTINCT peca.assignment_id,
6936: peca.change_type
6937: FROM psp_enc_changed_assignments peca
6938: WHERE peca.payroll_id = p_payroll_id;
6939:
6940:
6941: CURSOR get_no_asg_to_move IS

Line 6943: FROM psp_enc_changed_assignments peca

6939:
6940:
6941: CURSOR get_no_asg_to_move IS
6942: SELECT COUNT(DISTINCT peca.assignment_id)
6943: FROM psp_enc_changed_assignments peca
6944: WHERE peca.payroll_id = p_payroll_id;
6945:
6946: get_rec_to_move_rec get_rec_to_move%ROWTYPE;
6947:

Line 6979: DELETE FROM psp_enc_changed_assignments peca

6975: fnd_global.user_id,
6976: sysdate,
6977: NULL);
6978:
6979: DELETE FROM psp_enc_changed_assignments peca
6980: WHERE peca.assignment_id = get_rec_to_move_rec.assignment_id
6981: AND peca.change_type = get_rec_to_move_rec.change_type
6982: AND peca.payroll_id = p_payroll_id;
6983: