APPS.PAY_SOE_GLB dependencies on PAY_INPUT_VALUES_F

Line 447: , pay_input_values_f iv

443: , decode(count(*),1,max(rr.run_result_id),max(et.element_type_id)) COL18
444: from pay_assignment_actions aa
445: , pay_run_results rr
446: , pay_run_result_values rrv
447: , pay_input_values_f iv
448: , pay_input_values_f_tl ivtl
449: , pay_element_types_f et
450: , pay_element_types_f_tl ettl
451: , hr_organization_information orginfo

Line 448: , pay_input_values_f_tl ivtl

444: from pay_assignment_actions aa
445: , pay_run_results rr
446: , pay_run_result_values rrv
447: , pay_input_values_f iv
448: , pay_input_values_f_tl ivtl
449: , pay_element_types_f et
450: , pay_element_types_f_tl ettl
451: , hr_organization_information orginfo
452: where aa.assignment_action_id :action_clause

Line 495: , pay_input_values_f iv

491: , decode(count(*),1,max(rr.run_result_id),max(et.element_type_id)) COL18
492: from pay_assignment_actions aa
493: , pay_run_results rr
494: , pay_run_result_values rrv
495: , pay_input_values_f iv
496: , pay_input_values_f_tl ivtl
497: , pay_element_types_f et
498: , pay_element_types_f_tl ettl
499: where aa.assignment_action_id :action_clause

Line 496: , pay_input_values_f_tl ivtl

492: from pay_assignment_actions aa
493: , pay_run_results rr
494: , pay_run_result_values rrv
495: , pay_input_values_f iv
496: , pay_input_values_f_tl ivtl
497: , pay_element_types_f et
498: , pay_element_types_f_tl ettl
499: where aa.assignment_action_id :action_clause
500: and aa.assignment_action_id = rr.assignment_action_id

Line 575: l_inp_val_name pay_input_values_f.name%type;

571: l_assignment_id number;
572: l_business_group_id number;
573: l_legislation_code varchar2(30);
574: l_save_asg_run_bal varchar2(30);
575: l_inp_val_name pay_input_values_f.name%type;
576: l_si_needed_chr varchar2(10);
577: l_st_needed_chr varchar2(10);
578: l_sn_needed_chr varchar2(10);
579: l_st2_needed_chr varchar2(10);

Line 909: , pay_input_values_f iv

905: , rr.run_result_id COL18
906: from pay_assignment_actions aa
907: , pay_run_results rr
908: , pay_run_result_values rrv
909: , pay_input_values_f iv
910: , pay_input_values_f_tl ivtl
911: , pay_element_types_f et
912: , pay_element_types_f_tl ettl
913: , hr_organization_information oi

Line 910: , pay_input_values_f_tl ivtl

906: from pay_assignment_actions aa
907: , pay_run_results rr
908: , pay_run_result_values rrv
909: , pay_input_values_f iv
910: , pay_input_values_f_tl ivtl
911: , pay_element_types_f et
912: , pay_element_types_f_tl ettl
913: , hr_organization_information oi
914: where aa.assignment_action_id :action_clause