DBA Data[Home] [Help]

APPS.PAY_DK_SOE dependencies on PAY_INPUT_VALUES_F

Line 368: , pay_input_values_f iv

364: cursor csr_get_pp_name(p_effective_date date ,p_run_result_id number) is
365: select hou.name
366: from
367: pay_run_result_values rrv
368: , pay_input_values_f iv
369: , hr_organization_units hou
370: where rrv.run_result_id = p_run_result_id
371: and rrv.input_value_id = iv.input_value_id
372: and iv.name = 'Third Party Payee'

Line 420: , pay_input_values_f iv

416: , decode(count(*),1,max(rr.run_result_id),max(et.element_type_id)) COL18
417: from pay_assignment_actions aa
418: , pay_run_results rr
419: , pay_run_result_values rrv
420: , pay_input_values_f iv
421: , pay_input_values_f_tl ivtl
422: , pay_element_types_f et
423: , pay_element_types_f_tl ettl
424: , pay_element_set_members esm

Line 421: , pay_input_values_f_tl ivtl

417: from pay_assignment_actions aa
418: , pay_run_results rr
419: , pay_run_result_values rrv
420: , pay_input_values_f iv
421: , pay_input_values_f_tl ivtl
422: , pay_element_types_f et
423: , pay_element_types_f_tl ettl
424: , pay_element_set_members esm
425: , pay_element_sets es

Line 535: l_inp_val_name pay_input_values_f.name%type;

531: l_assignment_id number;
532: l_business_group_id number;
533: l_legislation_code varchar2(30);
534: l_save_asg_run_bal varchar2(30);
535: l_inp_val_name pay_input_values_f.name%type;
536: l_si_needed_chr varchar2(10);
537: l_st_needed_chr varchar2(10);
538: l_sn_needed_chr varchar2(10);
539: l_st2_needed_chr varchar2(10);