eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_SOE_GLB dependencies on PAY_RUN_RESULTS

Line 434: , pay_run_results rr

430: , to_char(sum(FND_NUMBER.CANONICAL_TO_NUMBER(rrv.result_value)),fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
431: , decode(count(*),1,''1'',''2'') COL17 -- destination indicator
432: , decode(count(*),1,max(rr.run_result_id),max(et.element_type_id)) COL18
433: from pay_assignment_actions aa
434: , pay_run_results rr
435: , pay_run_result_values rrv
436: , pay_input_values_f iv
437: , pay_input_values_f_tl ivtl
438: , pay_element_types_f et

Line 612: pay_run_results rr

608: ,rr.run_result_id)
609: ,null) source_text2
610: from pay_assignment_actions aa,
611: pay_payroll_actions pa,
612: pay_run_results rr
613: where aa.ASSIGNMENT_ID = l_assignment_id
614: and aa.assignment_action_id = rr.assignment_action_id
615: and l_action_sequence >= aa.action_sequence
616: and aa.payroll_action_id = pa.payroll_action_id

Line 832: , pay_run_results rr

828: , rrv.result_value COL04
829: , 1 COL05 -- to indicate that we should drilldown directly to run_result_values
830: , rr.run_result_id COL18
831: from pay_assignment_actions aa
832: , pay_run_results rr
833: , pay_run_result_values rrv
834: , pay_input_values_f iv
835: , pay_input_values_f_tl ivtl
836: , pay_element_types_f et

Line 1087: pay_run_results prr,

1083: ,ptp.period_num || '/' || to_char(ptp.start_date,'YYYY')
1084: FROM per_time_periods ptp,
1085: pay_payroll_actions ppa,
1086: pay_assignment_actions paa,
1087: pay_run_results prr,
1088: pay_element_entries_f pee
1089: WHERE pee.element_entry_id=c_element_entry_id
1090: and prr.run_result_id = pee.source_id
1091: and paa.assignment_action_id=prr.assignment_action_id

Line 1109: pay_run_results prr,

1105: ,ptp.period_num || '/' || to_char(ptp.start_date,'YYYY')
1106: FROM per_time_periods ptp,
1107: pay_payroll_actions ppa,
1108: pay_assignment_actions paa,
1109: pay_run_results prr,
1110: pay_element_entries_f pee
1111: WHERE pee.element_entry_id=c_element_entry_id
1112: and prr.run_result_id = pee.source_id
1113: and paa.assignment_action_id=prr.assignment_action_id

Line 1131: pay_run_results prr,

1127: ,ptp.period_num || '/' || to_char(ptp.start_date,'YYYY')
1128: FROM per_time_periods ptp,
1129: pay_payroll_actions ppa,
1130: pay_assignment_actions paa,
1131: pay_run_results prr,
1132: pay_element_entries_f pee
1133: WHERE pee.element_entry_id=c_element_entry_id
1134: and prr.run_result_id = pee.source_id
1135: and paa.assignment_action_id=prr.assignment_action_id