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_AU_TERM_REP dependencies on PAY_RUN_RESULT_VALUES

Line 93: pay_run_result_values prrv,

89: cursor Term(p_Assignment_id In Number,P_Assignment_action_id in Number,Lv_Element_Name In varchar2,Lv_Input_Name In varchar2) is
90: select
91: To_Number( prrv.result_value)
92: from
93: pay_run_result_values prrv,
94: pay_input_values_f piv,
95: pay_element_types_f pet,
96: pay_run_results prr,
97: pay_assignment_Actions paa

Line 120: pay_run_result_values prrv,

116: cursor Term2(p_Assignment_id In Number,P_Assignment_action_id in Number,Lv_Element_Name In varchar2,Lv_Input_Name In varchar2) is
117: select
118: sum(To_Number( prrv.result_value))
119: from
120: pay_run_result_values prrv,
121: pay_input_values_f piv,
122: pay_element_types_f pet,
123: pay_run_results prr,
124: pay_assignment_Actions paa

Line 144: pay_run_result_values prrv2,

140: select unique(prr3.run_result_id)
141: from pay_run_results prr2,
142: pay_input_values_f piv2,
143: pay_element_entries_f pee2,
144: pay_run_result_values prrv2,
145: pay_assignment_actions paa2,
146: pay_run_results prr3
147: where
148: prr2.element_type_id = pee2.element_type_id and

Line 303: pay_run_result_values prrv,

299: cursor Term(p_Assignment_id In Number,P_Assignment_action_id in Number,Lv_Element_Name In varchar2,Lv_Input_Name In varchar2) is
300: select
301: sum(To_Number( prrv.result_value)) /* 6470561 */
302: from
303: pay_run_result_values prrv,
304: pay_input_values_f piv,
305: pay_element_types_f pet,
306: pay_run_results prr,
307: pay_assignment_Actions paa

Line 328: pay_run_result_values prrv,

324: cursor Term2(p_Assignment_id In Number,P_Assignment_action_id in Number,Lv_Element_Name In varchar2,Lv_Input_Name In varchar2,p_transitional in varchar2) is
325: select
326: sum(To_Number( prrv.result_value))
327: from
328: pay_run_result_values prrv,
329: pay_input_values_f piv,
330: pay_element_types_f pet,
331: pay_run_results prr,
332: pay_assignment_Actions paa

Line 352: pay_run_result_values prrv2,

348: select unique(prr3.run_result_id)
349: from pay_run_results prr2,
350: pay_input_values_f piv2,
351: pay_element_entries_f pee2,
352: pay_run_result_values prrv2,
353: pay_assignment_actions paa2,
354: pay_run_results prr3
355: where
356: prr2.element_type_id = pee2.element_type_id and