APPS.PAY_ES_ONLINE_SOE dependencies on PAY_INPUT_VALUES_F

Line 109: l_inp_val_name pay_input_values_f.name%TYPE;

105: l_assignment_id NUMBER;
106: l_business_group_id NUMBER;
107: l_legislation_code VARCHAR2(30);
108: l_save_asg_run_bal VARCHAR2(30);
109: l_inp_val_name pay_input_values_f.name%TYPE;
110: l_si_needed_chr VARCHAR2(10);
111: l_st_needed_chr VARCHAR2(10);
112: l_sn_needed_chr VARCHAR2(10);
113: l_st2_needed_chr VARCHAR2(10);

Line 547: , pay_input_values_f iv

543: , decode(count(*),1,max(rr.run_result_id),max(et.element_type_id)) COL18
544: from pay_assignment_actions aa
545: , pay_run_results rr
546: , pay_run_result_values rrv
547: , pay_input_values_f iv
548: , pay_input_values_f_tl ivtl
549: , pay_element_types_f et
550: , pay_element_types_f_tl ettl
551: , pay_element_set_members esm

Line 548: , pay_input_values_f_tl ivtl

544: from pay_assignment_actions aa
545: , pay_run_results rr
546: , pay_run_result_values rrv
547: , pay_input_values_f iv
548: , pay_input_values_f_tl ivtl
549: , pay_element_types_f et
550: , pay_element_types_f_tl ettl
551: , pay_element_set_members esm
552: , pay_element_sets es

Line 619: ,pay_input_values_f PIV

615: --
616: CURSOR csr_giv IS
617: SELECT hr_general.decode_lookup(p_lookup_name,PRRV.RESULT_VALUE ) name
618: FROM pay_run_results PRR
619: ,pay_input_values_f PIV
620: ,pay_run_result_values PRRV
621: WHERE PRR.element_type_id = p_element_type_id
622: AND PIV.name = p_name
623: AND PRR.RUN_RESULT_ID= p_run_result_id