APPS.PAY_AE_SOE dependencies on PAY_INPUT_VALUES_F

Line 85: l_inp_val_name pay_input_values_f.name%type;

81: l_assignment_id number;
82: l_business_group_id number;
83: l_legislation_code varchar2(30);
84: l_save_asg_run_bal varchar2(30);
85: l_inp_val_name pay_input_values_f.name%type;
86: l_si_needed_chr varchar2(10);
87: l_st_needed_chr varchar2(10);
88: l_sn_needed_chr varchar2(10);
89: l_st2_needed_chr varchar2(10);

Line 562: ,pay_input_values_f iv

558: CURSOR csr_loan_type IS
559: SELECT hr_general.decode_lookup('AE_LOAN_TYPE',result_value)
560: FROM pay_run_results rr
561: ,pay_run_result_values rrv
562: ,pay_input_values_f iv
563: ,pay_input_values_f_tl ivt
564: ,pay_element_types_f et
565: ,pay_element_types_f_tl ettl
566: WHERE rr.element_type_id = et.element_type_id

Line 563: ,pay_input_values_f_tl ivt

559: SELECT hr_general.decode_lookup('AE_LOAN_TYPE',result_value)
560: FROM pay_run_results rr
561: ,pay_run_result_values rrv
562: ,pay_input_values_f iv
563: ,pay_input_values_f_tl ivt
564: ,pay_element_types_f et
565: ,pay_element_types_f_tl ettl
566: WHERE rr.element_type_id = et.element_type_id
567: AND iv.input_value_id = rrv.input_value_id

Line 611: , pay_input_values_f iv

607: , decode(count(*),1,max(rr.run_result_id),max(et.element_type_id)) COL18
608: from pay_assignment_actions aa
609: , pay_run_results rr
610: , pay_run_result_values rrv
611: , pay_input_values_f iv
612: , pay_input_values_f_tl ivtl
613: , pay_element_types_f et
614: , pay_element_types_f_tl ettl
615: --, pay_element_set_members esm

Line 612: , pay_input_values_f_tl ivtl

608: from pay_assignment_actions aa
609: , pay_run_results rr
610: , pay_run_result_values rrv
611: , pay_input_values_f iv
612: , pay_input_values_f_tl ivtl
613: , pay_element_types_f et
614: , pay_element_types_f_tl ettl
615: --, pay_element_set_members esm
616: --, pay_element_sets es