APPS.PSP_PQH_INTEGRATION dependencies on PSP_ENC_LINES

Line 17: psp_enc_lines_history pelh

13: SELECT pelh.enc_element_type_id , sum(decode(pelh.gl_project_flag , 'G',
14: encumbrance_amount , 0))gl_enc_amount, sum(decode(pelh.gl_project_flag, 'P',
15: encumbrance_amount, 0))gms_enc_amount
16: from psp_enc_summary_lines pesl,
17: psp_enc_lines_history pelh
18: WHERE
19: pelh.assignment_id=p_assignment_id and
20: pesl.enc_summary_line_id=pelh.enc_summary_line_id
21: and pesl.effective_date between p_encumbrance_start_date and

Line 66: max(time_period_id) from PSP_ENC_LINES

62: p_return_status OUT NOCOPY VARCHAR2) IS
63:
64: CURSOR get_enc_details_sum_cur IS /* Cursor for Enc S and Transfer */
65: SELECT assignment_id,enc_element_type_id , sum(encumbrance_amount),min(time_period_id),
66: max(time_period_id) from PSP_ENC_LINES
67: WHERE enc_control_id in
68: (SELECT enc_control_id from psp_enc_controls where action_code='I' and
69: run_id = psp_enc_sum_tran.g_run_id)
70: GROUP BY assignment_id, enc_element_type_id;

Line 75: PESL, PSP_ENC_LINES_HISTORY PELH WHERE

71:
72: CURSOR get_enc_details_liq_cur is
73: SELECT pelh.assignment_id,enc_element_type_id, sum(encumbrance_amount),min(pelh.time_period_id),
74: max(pelh.time_period_id) FROM PSP_ENC_SUMMARY_LINES
75: PESL, PSP_ENC_LINES_HISTORY PELH WHERE
76: PESL.status_code='A' and PELH.enc_summary_line_id=pesl.enc_summary_line_id
77: AND PELH.CHANGE_FLAG ='N' and EXISTS
78: (SELECT '1' from PSP_ENC_CHANGED_ASSIGNMENTS PECA where PECA.ASSIGNMENT_ID=
79: PESL.ASSIGNMENT_ID)