APPS.HRASSACT dependencies on PAY_INPUT_VALUES_F

Line 2934: pay_input_values_f piv,

2930: ) is
2931: select
2932: plb.latest_balance_id
2933: from
2934: pay_input_values_f piv,
2935: pay_balance_feeds_f pbf,
2936: pay_defined_balances pdb,
2937: pay_person_latest_balances plb,
2938: pay_assignment_actions paa,

Line 2961: pay_input_values_f piv

2957: pay_assignment_actions act,
2958: pay_payroll_actions pac,
2959: pay_defined_balances pdb,
2960: pay_balance_feeds_f pbf,
2961: pay_input_values_f piv
2962: where act.assignment_id = alb.assignment_id
2963: and alb.assignment_id in
2964: (select distinct asg.assignment_id
2965: from per_all_assignments_f asg

Line 2984: pay_input_values_f piv,

2980: ) is
2981: select
2982: plb.latest_balance_id
2983: from
2984: pay_input_values_f piv,
2985: pay_balance_feeds_f pbf,
2986: pay_defined_balances pdb,
2987: pay_latest_balances plb,
2988: pay_assignment_actions paa,

Line 5153: l_inp_val_name pay_input_values_f.name%type;

5149: rev_assact number; -- reversal assignment_action_id.
5150: leg_code per_business_groups_perf.legislation_code%type;
5151: l_process_path pay_assignment_actions.process_path%type;
5152: l_found boolean;
5153: l_inp_val_name pay_input_values_f.name%type;
5154: l_rev_lat_bal_maintenance boolean;
5155: l_rule_mode pay_legislation_rules.rule_mode%type;
5156: l_si_needed pay_legislation_rules.rule_mode%type;
5157: l_st_needed pay_legislation_rules.rule_mode%type;

Line 5526: pay_input_values_f piv

5522: 'ND' , rtrim(to_char((-1) * to_number(rrv.result_value, mask_38_dec_places), mask_38_dec_places), '.'),
5523: rrv.result_value)
5524: from pay_payroll_actions pac,
5525: pay_run_result_values rrv,
5526: pay_input_values_f piv
5527: where pac.payroll_action_id = pactid
5528: and rrv.run_result_id = oldrrid
5529: and piv.input_value_id = rrv.input_value_id
5530: and pac.effective_date between

Line 5944: pay_input_values_f piv

5940: prrv.input_value_id,
5941: prrv.run_result_id
5942: from pay_run_results prr,
5943: pay_run_result_values prrv,
5944: pay_input_values_f piv
5945: where prr.run_result_id = p_run_result_id
5946: and prrv.run_result_id = prr.run_result_id
5947: and piv.input_value_id = prrv.input_value_id
5948: and p_effective_date between piv.effective_start_date