DBA Data[Home] [Help]

APPS.PAY_SOE_GLB dependencies on PAY_INPUT_VALUES_F

Line 436: , pay_input_values_f iv

432: , decode(count(*),1,max(rr.run_result_id),max(et.element_type_id)) COL18
433: from pay_assignment_actions aa
434: , pay_run_results rr
435: , pay_run_result_values rrv
436: , pay_input_values_f iv
437: , pay_input_values_f_tl ivtl
438: , pay_element_types_f et
439: , pay_element_types_f_tl ettl
440: where aa.assignment_action_id :action_clause

Line 437: , pay_input_values_f_tl ivtl

433: from pay_assignment_actions aa
434: , pay_run_results rr
435: , pay_run_result_values rrv
436: , pay_input_values_f iv
437: , pay_input_values_f_tl ivtl
438: , pay_element_types_f et
439: , pay_element_types_f_tl ettl
440: where aa.assignment_action_id :action_clause
441: and aa.assignment_action_id = rr.assignment_action_id

Line 509: l_inp_val_name pay_input_values_f.name%type;

505: l_assignment_id number;
506: l_business_group_id number;
507: l_legislation_code varchar2(30);
508: l_save_asg_run_bal varchar2(30);
509: l_inp_val_name pay_input_values_f.name%type;
510: l_si_needed_chr varchar2(10);
511: l_st_needed_chr varchar2(10);
512: l_sn_needed_chr varchar2(10);
513: l_st2_needed_chr varchar2(10);

Line 834: , pay_input_values_f iv

830: , rr.run_result_id COL18
831: from pay_assignment_actions aa
832: , pay_run_results rr
833: , pay_run_result_values rrv
834: , pay_input_values_f iv
835: , pay_input_values_f_tl ivtl
836: , pay_element_types_f et
837: , pay_element_types_f_tl ettl
838: , hr_organization_information oi

Line 835: , pay_input_values_f_tl ivtl

831: from pay_assignment_actions aa
832: , pay_run_results rr
833: , pay_run_result_values rrv
834: , pay_input_values_f iv
835: , pay_input_values_f_tl ivtl
836: , pay_element_types_f et
837: , pay_element_types_f_tl ettl
838: , hr_organization_information oi
839: where aa.assignment_action_id :action_clause