DBA Data[Home] [Help]

APPS.PAY_AU_TERM_REP dependencies on PAY_INPUT_VALUES_F

Line 113: pay_input_values_f piv,

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

Line 139: pay_input_values_f piv,

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

Line 159: pay_input_values_f piv2,

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

Line 385: pay_input_values_f piv,

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

Line 409: pay_input_values_f piv,

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

Line 429: pay_input_values_f piv2,

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

Line 450: pay_input_values_f piv,

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,
454: pay_element_entries_f pee,