DBA Data[Home] [Help]

APPS.PAY_NL_SOE dependencies on PAY_ELEMENT_TYPES_F

Line 126: pay_element_types_f pet,

122: lp_element_name VARCHAR2,lp_input_value_name VARCHAR2) IS
123: select prrv.result_value
124: from pay_run_result_values prrv,
125: pay_run_results prr,
126: pay_element_types_f pet,
127: pay_input_values_f piv,
128: pay_assignment_actions paa,
129: pay_payroll_actions ppa
130: where prrv.run_result_id = prr.run_result_id

Line 307: , pay_element_types_f et

303: , pay_run_results rr
304: , pay_run_result_values rrv
305: , pay_input_values_f iv
306: , pay_input_values_f_tl ivtl
307: , pay_element_types_f et
308: , pay_element_types_f_tl ettl
309: , pay_element_set_members esm
310: , pay_element_sets es
311: where aa.assignment_action_id :action_clause

Line 308: , pay_element_types_f_tl ettl

304: , pay_run_result_values rrv
305: , pay_input_values_f iv
306: , pay_input_values_f_tl ivtl
307: , pay_element_types_f et
308: , pay_element_types_f_tl ettl
309: , pay_element_set_members esm
310: , pay_element_sets es
311: where aa.assignment_action_id :action_clause
312: and aa.assignment_action_id = rr.assignment_action_id