APPS.PAY_KW_SOE dependencies on PAY_INPUT_VALUES_F

Line 81: l_inp_val_name pay_input_values_f.name%type;

77: l_assignment_id number;
78: l_business_group_id number;
79: l_legislation_code varchar2(30);
80: l_save_asg_run_bal varchar2(30);
81: l_inp_val_name pay_input_values_f.name%type;
82: l_si_needed_chr varchar2(10);
83: l_st_needed_chr varchar2(10);
84: l_sn_needed_chr varchar2(10);
85: l_st2_needed_chr varchar2(10);

Line 546: ,pay_input_values_f iv

542: CURSOR csr_loan_type IS
543: SELECT hr_general.decode_lookup('KW_LOAN_TYPE',result_value)
544: FROM pay_run_results rr
545: ,pay_run_result_values rrv
546: ,pay_input_values_f iv
547: ,pay_input_values_f_tl ivt
548: ,pay_element_types_f et
549: ,pay_element_types_f_tl ettl
550: WHERE rr.element_type_id = et.element_type_id

Line 547: ,pay_input_values_f_tl ivt

543: SELECT hr_general.decode_lookup('KW_LOAN_TYPE',result_value)
544: FROM pay_run_results rr
545: ,pay_run_result_values rrv
546: ,pay_input_values_f iv
547: ,pay_input_values_f_tl ivt
548: ,pay_element_types_f et
549: ,pay_element_types_f_tl ettl
550: WHERE rr.element_type_id = et.element_type_id
551: AND iv.input_value_id = rrv.input_value_id

Line 595: , pay_input_values_f iv

591: , decode(count(*),1,max(rr.run_result_id),max(et.element_type_id)) COL18
592: from pay_assignment_actions aa
593: , pay_run_results rr
594: , pay_run_result_values rrv
595: , pay_input_values_f iv
596: , pay_input_values_f_tl ivtl
597: , pay_element_types_f et
598: , pay_element_types_f_tl ettl
599: , pay_element_set_members esm

Line 596: , pay_input_values_f_tl ivtl

592: from pay_assignment_actions aa
593: , pay_run_results rr
594: , pay_run_result_values rrv
595: , pay_input_values_f iv
596: , pay_input_values_f_tl ivtl
597: , pay_element_types_f et
598: , pay_element_types_f_tl ettl
599: , pay_element_set_members esm
600: , pay_element_sets es