APPS.PAY_ES_ONLINE_SOE dependencies on PAY_RUN_RESULTS

Line 229: pay_run_results rr

225: ,rr.run_result_id)
226: ,null) source_text2
227: from pay_assignment_actions aa,
228: pay_payroll_actions pa,
229: pay_run_results rr
230: where aa.ASSIGNMENT_ID = l_assignment_id
231: and aa.assignment_action_id = rr.assignment_action_id
232: and l_action_sequence >= aa.action_sequence
233: and aa.payroll_action_id = pa.payroll_action_id

Line 545: , pay_run_results rr

541: , to_char(sum(FND_NUMBER.CANONICAL_TO_NUMBER(rrv.result_value)),fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
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

Line 618: FROM pay_run_results PRR

614: ,p_lookup_name VARCHAR2) RETURN VARCHAR2 IS
615: --
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