DBA Data[Home] [Help]

APPS.PAY_ES_ONLINE_SOE dependencies on PAY_RUN_RESULT_VALUES

Line 546: , pay_run_result_values rrv

542: , decode(count(*),1,''1'',''2'') COL17 -- destination indicator
543: , decode(count(*),1,max(rr.run_result_id),max(et.element_type_id)) COL18
544: from pay_assignment_actions aa
545: , pay_run_results rr
546: , pay_run_result_values rrv
547: , pay_input_values_f iv
548: , pay_input_values_f_tl ivtl
549: , pay_element_types_f et
550: , pay_element_types_f_tl ettl

Line 620: ,pay_run_result_values PRRV

616: CURSOR csr_giv IS
617: SELECT hr_general.decode_lookup(p_lookup_name,PRRV.RESULT_VALUE ) name
618: FROM pay_run_results PRR
619: ,pay_input_values_f PIV
620: ,pay_run_result_values PRRV
621: WHERE PRR.element_type_id = p_element_type_id
622: AND PIV.name = p_name
623: AND PRR.RUN_RESULT_ID= p_run_result_id
624: AND PRRV.RUN_RESULT_ID=PRR.RUN_RESULT_ID