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 445: , pay_run_results rr

441: , to_char(sum(FND_NUMBER.CANONICAL_TO_NUMBER(rrv.result_value)),fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
442: , decode(count(*),1,''1'',''2'') COL17 -- destination indicator,
443: , decode(count(*),1,max(rr.run_result_id),max(et.element_type_id)) COL18
444: from pay_assignment_actions aa
445: , pay_run_results rr
446: , pay_run_result_values rrv
447: , pay_input_values_f iv
448: , pay_input_values_f_tl ivtl
449: , pay_element_types_f et

Line 493: , pay_run_results rr

489: , to_char(sum(FND_NUMBER.CANONICAL_TO_NUMBER(rrv.result_value)),fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
490: , decode(count(*),1,''1'',''2'') COL17 -- destination indicator,
491: , decode(count(*),1,max(rr.run_result_id),max(et.element_type_id)) COL18
492: from pay_assignment_actions aa
493: , pay_run_results rr
494: , pay_run_result_values rrv
495: , pay_input_values_f iv
496: , pay_input_values_f_tl ivtl
497: , pay_element_types_f et

Line 678: pay_run_results rr

674: ,rr.run_result_id)
675: ,null) source_text2
676: from pay_assignment_actions aa,
677: pay_payroll_actions pa,
678: pay_run_results rr
679: where aa.ASSIGNMENT_ID = l_assignment_id
680: and aa.assignment_action_id = rr.assignment_action_id
681: and l_action_sequence >= aa.action_sequence
682: and aa.payroll_action_id = pa.payroll_action_id

Line 907: , pay_run_results rr

903: , rrv.result_value COL04
904: , 1 COL05 -- to indicate that we should drilldown directly to run_result_values
905: , rr.run_result_id COL18
906: from pay_assignment_actions aa
907: , pay_run_results rr
908: , pay_run_result_values rrv
909: , pay_input_values_f iv
910: , pay_input_values_f_tl ivtl
911: , pay_element_types_f et

Line 1162: pay_run_results prr,

1158: ,ptp.period_num || '/' || to_char(ptp.start_date,'YYYY')
1159: FROM per_time_periods ptp,
1160: pay_payroll_actions ppa,
1161: pay_assignment_actions paa,
1162: pay_run_results prr,
1163: pay_element_entries_f pee
1164: WHERE pee.element_entry_id=c_element_entry_id
1165: and prr.run_result_id = pee.source_id
1166: and paa.assignment_action_id=prr.assignment_action_id

Line 1184: pay_run_results prr,

1180: ,ptp.period_num || '/' || to_char(ptp.start_date,'YYYY')
1181: FROM per_time_periods ptp,
1182: pay_payroll_actions ppa,
1183: pay_assignment_actions paa,
1184: pay_run_results prr,
1185: pay_element_entries_f pee
1186: WHERE pee.element_entry_id=c_element_entry_id
1187: and prr.run_result_id = pee.source_id
1188: and paa.assignment_action_id=prr.assignment_action_id

Line 1206: pay_run_results prr,

1202: ,ptp.period_num || '/' || to_char(ptp.start_date,'YYYY')
1203: FROM per_time_periods ptp,
1204: pay_payroll_actions ppa,
1205: pay_assignment_actions paa,
1206: pay_run_results prr,
1207: pay_element_entries_f pee
1208: WHERE pee.element_entry_id=c_element_entry_id
1209: and prr.run_result_id = pee.source_id
1210: and paa.assignment_action_id=prr.assignment_action_id