DBA Data[Home] [Help]

APPS.PAY_AE_SOE dependencies on PAY_RUN_RESULT_VALUES

Line 555: ,pay_run_result_values rrv

551: RETURN VARCHAR2 IS
552: CURSOR csr_loan_type IS
553: SELECT hr_general.decode_lookup('AE_LOAN_TYPE',result_value)
554: FROM pay_run_results rr
555: ,pay_run_result_values rrv
556: ,pay_input_values_f iv
557: ,pay_input_values_f_tl ivt
558: ,pay_element_types_f et
559: ,pay_element_types_f_tl ettl

Line 604: , pay_run_result_values rrv

600: , decode(count(*),1,''1'',''2'') COL17 -- destination indicator
601: , decode(count(*),1,max(rr.run_result_id),max(et.element_type_id)) COL18
602: from pay_assignment_actions aa
603: , pay_run_results rr
604: , pay_run_result_values rrv
605: , pay_input_values_f iv
606: , pay_input_values_f_tl ivtl
607: , pay_element_types_f et
608: , pay_element_types_f_tl ettl