DBA Data[Home] [Help]

APPS.PAY_NL_SOE dependencies on PAY_INPUT_VALUES_F

Line 127: pay_input_values_f piv,

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
131: and paa.assignment_action_id=lp_assignment_action_id

Line 305: , pay_input_values_f iv

301: , decode(count(*),1,max(rr.run_result_id),max(et.element_type_id)) COL18
302: from pay_assignment_actions aa
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

Line 306: , pay_input_values_f_tl ivtl

302: from pay_assignment_actions aa
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

Line 390: l_inp_val_name pay_input_values_f.name%type;

386: l_assignment_id number;
387: l_business_group_id number;
388: l_legislation_code varchar2(30);
389: l_save_asg_run_bal varchar2(30);
390: l_inp_val_name pay_input_values_f.name%type;
391: l_si_needed_chr varchar2(10);
392: l_st_needed_chr varchar2(10);
393: l_sn_needed_chr varchar2(10);
394: l_st2_needed_chr varchar2(10);