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 112: pay_run_result_values prrv,

108: cursor Term(p_Assignment_id In Number,Lv_Element_Name In varchar2,Lv_Input_Name In varchar2) is
109: select
110: nvl(To_Number( prrv.result_value),0)
111: from
112: pay_run_result_values prrv,
113: pay_input_values_f piv,
114: pay_element_types_f pet,
115: pay_run_results prr,
116: pay_assignment_Actions paa

Line 138: pay_run_result_values prrv,

134: cursor Term2(p_Assignment_id In Number,Lv_Element_Name In varchar2,Lv_Input_Name In varchar2) is
135: select
136: sum(To_Number( prrv.result_value))
137: from
138: pay_run_result_values prrv,
139: pay_input_values_f piv,
140: pay_element_types_f pet,
141: pay_run_results prr,
142: pay_assignment_Actions paa

Line 161: pay_run_result_values prrv2,

157: select unique(prr3.run_result_id)
158: from pay_run_results prr2,
159: pay_input_values_f piv2,
160: pay_element_entries_f pee2,
161: pay_run_result_values prrv2,
162: pay_assignment_actions paa2,
163: pay_run_results prr3
164: where
165: prr2.element_type_id = pee2.element_type_id and

Line 384: pay_run_result_values prrv,

380: cursor Term(p_Assignment_id In Number,Lv_Element_Name In varchar2,Lv_Input_Name In varchar2) is
381: select
382: nvl(sum(To_Number( prrv.result_value)),0) /* 6470561 */
383: from
384: pay_run_result_values prrv,
385: pay_input_values_f piv,
386: pay_element_types_f pet,
387: pay_run_results prr,
388: pay_assignment_Actions paa

Line 408: pay_run_result_values prrv,

404: cursor Term2(p_Assignment_id In Number,Lv_Element_Name In varchar2,Lv_Input_Name In varchar2,p_transitional in varchar2) is
405: select
406: sum(To_Number( prrv.result_value))
407: from
408: pay_run_result_values prrv,
409: pay_input_values_f piv,
410: pay_element_types_f pet,
411: pay_run_results prr,
412: pay_assignment_Actions paa

Line 431: pay_run_result_values prrv2,

427: select unique(prr3.run_result_id)
428: from pay_run_results prr2,
429: pay_input_values_f piv2,
430: pay_element_entries_f pee2,
431: pay_run_result_values prrv2,
432: pay_assignment_actions paa2,
433: pay_run_results prr3
434: where
435: prr2.element_type_id = pee2.element_type_id and

Line 449: pay_run_result_values prrv,

445: cursor Term3(p_Assignment_id In Number,Lv_Element_Name In varchar2,Lv_Input_Name In varchar2) is
446: select
447: nvl(To_Number( prrv.result_value),0) result_value, nvl(pee.entry_information4,'N') entry_information
448: from
449: pay_run_result_values prrv,
450: pay_input_values_f piv,
451: pay_element_types_f pet,
452: pay_run_results prr,
453: pay_assignment_actions paa,