DBA Data[Home] [Help]

APPS.PAY_KW_SOE dependencies on PAY_RUN_RESULT_VALUES

Line 545: ,pay_run_result_values rrv

541: RETURN VARCHAR2 IS
542: CURSOR csr_loan_type IS
543: SELECT hr_general.decode_lookup('KW_LOAN_TYPE',result_value)
544: FROM pay_run_results rr
545: ,pay_run_result_values rrv
546: ,pay_input_values_f iv
547: ,pay_input_values_f_tl ivt
548: ,pay_element_types_f et
549: ,pay_element_types_f_tl ettl

Line 594: , pay_run_result_values rrv

590: , decode(count(*),1,''1'',''2'') COL17 -- destination indicator
591: , decode(count(*),1,max(rr.run_result_id),max(et.element_type_id)) COL18
592: from pay_assignment_actions aa
593: , pay_run_results rr
594: , pay_run_result_values rrv
595: , pay_input_values_f iv
596: , pay_input_values_f_tl ivtl
597: , pay_element_types_f et
598: , pay_element_types_f_tl ettl