APPS.PAY_KW_SOE dependencies on PAY_RUN_RESULTS

Line 207: pay_run_results rr

203: ,rr.run_result_id)
204: ,null) source_text2
205: from pay_assignment_actions aa,
206: pay_payroll_actions pa,
207: pay_run_results rr
208: where aa.ASSIGNMENT_ID = l_assignment_id
209: and aa.assignment_action_id = rr.assignment_action_id
210: and l_action_sequence >= aa.action_sequence
211: and aa.payroll_action_id = pa.payroll_action_id

Line 237: FROM pay_run_results rr

233: and legislation_code = 'KW';
234: --
235: cursor getRRstatus(l_ele_id number) IS
236: SELECT status
237: FROM pay_run_results rr
238: WHERE rr.assignment_action_id = p_assignment_action_id
239: AND rr.element_type_id = l_ele_id;
240:
241: begin

Line 544: FROM pay_run_results rr

540: FUNCTION kw_loan_type (p_assignment_action_id NUMBER, p_run_result_id NUMBER , p_effective_date date)
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

Line 593: , pay_run_results rr

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