DBA Data[Home] [Help]

APPS.PAY_AU_TERM_REP dependencies on PAY_ELEMENT_TYPES_F

Line 114: pay_element_types_f pet,

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
118: prrv.input_value_id=piv.input_value_id

Line 140: pay_element_types_f pet,

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
144: prrv.input_value_id=piv.input_value_id

Line 386: pay_element_types_f pet,

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
390: prrv.input_value_id=piv.input_value_id

Line 410: pay_element_types_f pet,

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
414: prrv.input_value_id=piv.input_value_id

Line 451: pay_element_types_f pet,

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,
455: pay_element_types_f pet2

Line 455: pay_element_types_f pet2

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
457: prrv.input_value_id=piv.input_value_id
458: and piv.element_type_id=pet.element_type_id
459: and prr.element_type_id = pet.element_type_id