DBA Data[Home] [Help]

APPS.PAY_GB_COURT_ORDER_UPGRADE dependencies on PAY_ELEMENT_TYPES_F

Line 59: FROM pay_element_types_f et

55: ,rr.run_result_id
56: ,aa.assignment_action_id
57: ,aa.assignment_id
58: ,nvl(prrv.result_value,'Unknown') result_value
59: FROM pay_element_types_f et
60: ,pay_input_values_f iv
61: ,pay_run_results rr
62: ,per_assignments_f paf
63: ,pay_assignment_actions aa

Line 257: pay_element_types_f pet,

253: FROM per_assignments_f paf,
254: pay_assignment_actions paa,
255: pay_action_contexts pac,
256: ff_contexts fc,
257: pay_element_types_f pet,
258: pay_input_values_f piv,
259: pay_run_results prr,
260: pay_run_result_values prrv
261: ,pay_input_values_f piv1

Line 297: pay_element_types_f pet,

293: ,p_context_value varchar2) is
294: SELECT nvl(PRRV.result_value ,'0') result_value,
295: nvl((prrv.result_value - p_paid_value),'0') overpaid
296: FROM
297: pay_element_types_f pet,
298: pay_input_values_f piv,
299: pay_run_results prr,
300: pay_run_result_values prrv,
301: pay_input_values_f piv1,