DBA Data[Home] [Help]

APPS.PSP_PQH_INTEGRATION dependencies on PSP_ENC_CHANGED_ASSIGNMENTS

Line 78: (SELECT '1' from PSP_ENC_CHANGED_ASSIGNMENTS PECA where PECA.ASSIGNMENT_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)
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)