APPS.PSP_PQH_INTEGRATION dependencies on PSP_ENC_CONTROLS

Line 68: (SELECT enc_control_id from psp_enc_controls where action_code='I' and

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;
71:
72: CURSOR get_enc_details_liq_cur is

Line 81: (SELECT ENC_CONTROL_ID FROM PSP_ENC_CONTROLS WHERE ACTION_CODE='IU'

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)
80: AND PESL.ENC_CONTROL_ID IN -- Changed PELH to PESL for 11510_CU2 Consolidated performance fixes.
81: (SELECT ENC_CONTROL_ID FROM PSP_ENC_CONTROLS WHERE ACTION_CODE='IU'
82: AND RUN_ID=PSP_ENC_LIQ_TRAN.G_RUN_ID)
83: GROUP BY PELH.ASSIGNMENT_ID,ENC_ELEMENT_TYPE_ID;
84:
85: BEGIN