APPS.PAY_AE_SOE dependencies on PAY_RUN_RESULTS

Line 212: pay_run_results rr

208: ,rr.run_result_id)
209: ,null) source_text2
210: from pay_assignment_actions aa,
211: pay_payroll_actions pa,
212: pay_run_results rr
213: where aa.ASSIGNMENT_ID = l_assignment_id
214: and aa.assignment_action_id = rr.assignment_action_id
215: and l_action_sequence >= aa.action_sequence
216: and aa.payroll_action_id = pa.payroll_action_id

Line 243: FROM pay_run_results rr

239: and legislation_code = 'AE';
240: --
241: cursor getRRstatus(l_ele_id number) IS
242: SELECT status
243: FROM pay_run_results rr
244: WHERE rr.assignment_action_id = p_assignment_action_id
245: AND rr.element_type_id = l_ele_id;
246: --
247: begin

Line 554: FROM pay_run_results rr

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

Line 603: , pay_run_results rr

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