DBA Data[Home] [Help]

APPS.PAY_DK_SOE dependencies on PAY_RUN_RESULTS

Line 418: , pay_run_results rr

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

Line 636: pay_run_results rr

632: ,rr.run_result_id)
633: ,null) organization_id
634: from pay_assignment_actions aa,
635: pay_payroll_actions pa,
636: pay_run_results rr
637: where aa.ASSIGNMENT_ID = l_assignment_id
638: and aa.assignment_action_id = rr.assignment_action_id
639: and l_action_sequence >= aa.action_sequence
640: and aa.payroll_action_id = pa.payroll_action_id