DBA Data[Home] [Help]

APPS.PAY_GB_RTI_EYU dependencies on PAY_RUN_RESULT_VALUES

Line 627: pay_run_result_values rrv

623: CURSOR csr_run_result(p_run_result_id number,p_element_type_id number) IS
624: SELECT max(decode(name,'Tax Code',result_value,NULL)) tax_code,
625: max(decode(name,'Tax Basis',result_value,NULL)) tax_basis
626: FROM pay_input_values_f v,
627: pay_run_result_values rrv
628: WHERE rrv.run_result_id = p_run_result_id
629: AND v.input_value_id = rrv.input_value_id
630: AND v.element_type_id = p_element_type_id;
631: