DBA Data[Home] [Help]

APPS.PSP_PQH_INTEGRATION dependencies on PSP_ENC_SUM_TRAN

Line 69: run_id = psp_enc_sum_tran.g_run_id)

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
73: SELECT pelh.assignment_id,enc_element_type_id, sum(encumbrance_amount),min(pelh.time_period_id),