APPS.PSP_PQH_INTEGRATION dependencies on PSP_ENC_SUMMARY_LINES

Line 16: from psp_enc_summary_lines pesl,

12: CURSOR get_asg_enc_cur IS
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

Line 74: max(pelh.time_period_id) FROM PSP_ENC_SUMMARY_LINES

70: GROUP BY assignment_id, enc_element_type_id;
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=