APPS.PAY_AU_TERM_REP dependencies on PAY_INPUT_VALUES_F

Line 94: pay_input_values_f piv,

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
98: where

Line 121: pay_input_values_f piv,

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
125: where

Line 142: pay_input_values_f piv2,

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,
146: pay_run_results prr3

Line 304: pay_input_values_f piv,

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
308: where

Line 329: pay_input_values_f piv,

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
333: where

Line 350: pay_input_values_f piv2,

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,
354: pay_run_results prr3