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_RESULTS

Line 115: pay_run_results prr,

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
117: where
118: prrv.input_value_id=piv.input_value_id
119: and piv.element_type_id=pet.element_type_id

Line 141: pay_run_results prr,

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
143: where
144: prrv.input_value_id=piv.input_value_id
145: and piv.element_type_id=pet.element_type_id

Line 158: from pay_run_results prr2,

154: and p_termination_date between piv.effective_start_date and piv.effective_end_date
155: and p_termination_date between pet.effective_start_date and Pet.effective_end_date
156: and prr.run_result_id in (
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,

Line 163: pay_run_results prr3

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
166: piv2.element_type_id = pee2.element_type_id and
167: prr2.run_result_id = prrv2.run_result_id and

Line 387: pay_run_results prr,

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
389: where
390: prrv.input_value_id=piv.input_value_id
391: and piv.element_type_id=pet.element_type_id

Line 411: pay_run_results prr,

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
413: where
414: prrv.input_value_id=piv.input_value_id
415: and piv.element_type_id=pet.element_type_id

Line 428: from pay_run_results prr2,

424: and p_termination_date between piv.effective_start_date and piv.effective_end_date
425: and p_termination_date between pet.effective_start_date and Pet.effective_end_date
426: and prr.run_result_id in (
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,

Line 433: pay_run_results prr3

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
436: piv2.element_type_id = pee2.element_type_id and
437: prr2.run_result_id = prrv2.run_result_id and

Line 452: pay_run_results prr,

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,
454: pay_element_entries_f pee,
455: pay_element_types_f pet2
456: where