APPS.PAY_AU_TERM_REP dependencies on PAY_RUN_RESULTS

Line 96: pay_run_results prr,

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
98: where
99: prrv.input_value_id=piv.input_value_id
100: and piv.element_type_id=pet.element_type_id

Line 123: pay_run_results prr,

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
125: where
126: prrv.input_value_id=piv.input_value_id
127: and piv.element_type_id=pet.element_type_id

Line 141: from pay_run_results prr2,

137: and p_termination_date between piv.effective_start_date and piv.effective_end_date
138: and p_termination_date between pet.effective_start_date and Pet.effective_end_date
139: and prr.run_result_id in (
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,

Line 146: pay_run_results prr3

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

Line 306: pay_run_results prr,

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
308: where
309: prrv.input_value_id=piv.input_value_id
310: and piv.element_type_id=pet.element_type_id

Line 331: pay_run_results prr,

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
333: where
334: prrv.input_value_id=piv.input_value_id
335: and piv.element_type_id=pet.element_type_id

Line 349: from pay_run_results prr2,

345: and p_termination_date between piv.effective_start_date and piv.effective_end_date
346: and p_termination_date between pet.effective_start_date and Pet.effective_end_date
347: and prr.run_result_id in (
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,

Line 354: pay_run_results prr3

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