DBA Data[Home] [Help]

APPS.PAY_DK_SOE dependencies on PAY_RUN_RESULT_VALUES

Line 367: pay_run_result_values rrv

363: /* Changes made to to_number used in csr_get_pp_name */
364: cursor csr_get_pp_name(p_effective_date date ,p_run_result_id number) is
365: select hou.name
366: from
367: pay_run_result_values rrv
368: , pay_input_values_f iv
369: , hr_organization_units hou
370: where rrv.run_result_id = p_run_result_id
371: and rrv.input_value_id = iv.input_value_id

Line 419: , pay_run_result_values rrv

415: , decode(count(*),1,''1'',''2'') COL17 -- destination indicator
416: , decode(count(*),1,max(rr.run_result_id),max(et.element_type_id)) COL18
417: from pay_assignment_actions aa
418: , pay_run_results rr
419: , pay_run_result_values rrv
420: , pay_input_values_f iv
421: , pay_input_values_f_tl ivtl
422: , pay_element_types_f et
423: , pay_element_types_f_tl ettl