DBA Data[Home] [Help]

APPS.PAY_AE_SOE dependencies on PAY_RUN_RESULT_VALUES

Line 561: ,pay_run_result_values rrv

557: RETURN VARCHAR2 IS
558: CURSOR csr_loan_type IS
559: SELECT hr_general.decode_lookup('AE_LOAN_TYPE',result_value)
560: FROM pay_run_results rr
561: ,pay_run_result_values rrv
562: ,pay_input_values_f iv
563: ,pay_input_values_f_tl ivt
564: ,pay_element_types_f et
565: ,pay_element_types_f_tl ettl

Line 610: , pay_run_result_values rrv

606: , decode(count(*),1,''1'',''2'') COL17 -- destination indicator
607: , decode(count(*),1,max(rr.run_result_id),max(et.element_type_id)) COL18
608: from pay_assignment_actions aa
609: , pay_run_results rr
610: , pay_run_result_values rrv
611: , pay_input_values_f iv
612: , pay_input_values_f_tl ivtl
613: , pay_element_types_f et
614: , pay_element_types_f_tl ettl