APPS.PSP_ENC_LIQ_TRAN dependencies on PSP_ENC_CHANGED_ASSIGNMENTS

Line 2054: AND EXISTS (SELECT 1 FROM psp_enc_changed_assignments peca

2050: AND pec.set_of_books_id = g_sob_id
2051: AND (pec.gl_phase IS NULL or pec.gl_phase = 'TieBack'))
2052: AND pesl.gl_project_flag = 'G'
2053: AND pesl.status_code = 'A'
2054: AND EXISTS (SELECT 1 FROM psp_enc_changed_assignments peca
2055: WHERE peca.assignment_id = pesl.assignment_id
2056: AND peca.request_id IS NOT NULL
2057: AND peca.payroll_id =p_payroll_id)
2058: AND EXISTS (SELECT 1

Line 2097: AND EXISTS (SELECT 1 FROM psp_enc_changed_assignments peca

2093: AND pec.set_of_books_id = g_sob_id
2094: AND (pec.gl_phase IS NULL or pec.gl_phase = 'TieBack'))
2095: AND pesl.gl_project_flag = 'G'
2096: AND pesl.status_code = 'A'
2097: AND EXISTS (SELECT 1 FROM psp_enc_changed_assignments peca
2098: WHERE peca.assignment_id = pesl.assignment_id
2099: AND peca.request_id IS NOT NULL
2100: AND peca.payroll_id = p_payroll_id
2101: AND peca.change_type IN ('LS', 'ET', 'AS', 'QU'))

Line 2362: AND EXISTS (SELECT 1 FROM psp_enc_changed_assignments peca

2358: OR
2359: (p_action_type IN ('Q', 'U') AND EXISTS
2360: (SELECT 1 FROM PSP_ENC_LINES_HISTORY PELH WHERE PELH.ENC_SUMMARY_LINE_ID = PESL.ENC_SUMMARY_LINE_ID
2361: AND PELH.CHANGE_FLAG = 'N')
2362: AND EXISTS (SELECT 1 FROM psp_enc_changed_assignments peca
2363: WHERE peca.assignment_id = pesl.assignment_id
2364: AND peca.request_id IS NOT NULL
2365: AND peca.payroll_id =p_payroll_id
2366: AND ((p_action_type = 'Q' and peca.change_type IN ('LS', 'ET', 'AS', 'QU'))

Line 4509: AND EXISTS (SELECT 1 FROM psp_enc_changed_assignments peca

4505: AND pec.set_of_books_id = g_sob_id
4506: AND (pec.gms_phase IS NULL or pec.gms_phase = 'TieBack'))
4507: AND gl_project_flag = 'P'
4508: AND status_code = 'A'
4509: AND EXISTS (SELECT 1 FROM psp_enc_changed_assignments peca
4510: WHERE peca.assignment_id = pesl.assignment_id
4511: AND peca.request_id IS NOT NULL
4512: AND peca.payroll_id = p_payroll_id)
4513: AND EXISTS (SELECT 1

Line 4559: AND EXISTS (SELECT 1 FROM psp_enc_changed_assignments peca

4555: AND pec.set_of_books_id = g_sob_id
4556: AND (pec.gms_phase IS NULL or pec.gms_phase = 'TieBack'))
4557: AND gl_project_flag = 'P'
4558: AND status_code = 'A'
4559: AND EXISTS (SELECT 1 FROM psp_enc_changed_assignments peca
4560: WHERE peca.assignment_id = pesl.assignment_id
4561: AND peca.request_id IS NOT NULL
4562: AND peca.payroll_id = p_payroll_id
4563: AND peca.change_type IN ('LS', 'ET', 'AS', 'QU'))

Line 4862: AND EXISTS (SELECT 1 FROM psp_enc_changed_assignments peca

4858: OR
4859: (p_action_type IN ('Q', 'U') AND EXISTS
4860: (SELECT 1 FROM PSP_ENC_LINES_HISTORY PELH WHERE PELH.ENC_SUMMARY_LINE_ID = PESL.ENC_SUMMARY_LINE_ID
4861: AND PELH.CHANGE_FLAG = 'N')
4862: AND EXISTS (SELECT 1 FROM psp_enc_changed_assignments peca
4863: WHERE peca.assignment_id = pesl.assignment_id
4864: AND peca.request_id IS NOT NULL
4865: AND peca.payroll_id =p_payroll_id
4866: AND ((p_action_type = 'Q' and peca.change_type IN ('LS', 'ET', 'AS', 'QU'))

Line 7175: FROM psp_enc_changed_assignments peca

7171:
7172: CURSOR get_rec_to_move IS
7173: SELECT DISTINCT peca.assignment_id,
7174: peca.change_type
7175: FROM psp_enc_changed_assignments peca
7176: WHERE peca.payroll_id = p_payroll_id;
7177:
7178:
7179: CURSOR get_no_asg_to_move IS

Line 7181: FROM psp_enc_changed_assignments peca

7177:
7178:
7179: CURSOR get_no_asg_to_move IS
7180: SELECT COUNT(DISTINCT peca.assignment_id)
7181: FROM psp_enc_changed_assignments peca
7182: WHERE peca.payroll_id = p_payroll_id;
7183:
7184: get_rec_to_move_rec get_rec_to_move%ROWTYPE;
7185:

Line 7217: DELETE FROM psp_enc_changed_assignments peca

7213: fnd_global.user_id,
7214: sysdate,
7215: NULL);
7216:
7217: DELETE FROM psp_enc_changed_assignments peca
7218: WHERE peca.assignment_id = get_rec_to_move_rec.assignment_id
7219: AND peca.change_type = get_rec_to_move_rec.change_type
7220: AND peca.payroll_id = p_payroll_id;
7221: