[Home] [Help]
410: SELECT 1
411: FROM DUAL
412: WHERE EXISTS
413: (SELECT NULL
414: FROM pa_draft_revenues_all
415: WHERE project_id = p_project_id
416: AND released_date IS NOT NULL
417: AND transfer_status_code = 'A'
418: AND pji_summarized_flag = 'N');