734: select 'Y' results_exist
735: from dual
736: where
737: exists ( select 'x' 738: from pay_run_results rr, 739: pay_element_types_f ele
740: where
741: ele.element_type_id = rr.element_type_id
742: and ele.element_name in ( p_element_string||'POST_VERTEX', p_element_string||'ARR')