APPS.HRASSACT dependencies on PAY_INPUT_VALUES_F

Line 2951: pay_input_values_f piv,

2947: ) is
2948: select
2949: plb.latest_balance_id
2950: from
2951: pay_input_values_f piv,
2952: pay_balance_feeds_f pbf,
2953: pay_defined_balances pdb,
2954: pay_person_latest_balances plb,
2955: pay_assignment_actions paa,

Line 2978: pay_input_values_f piv

2974: pay_assignment_actions act,
2975: pay_payroll_actions pac,
2976: pay_defined_balances pdb,
2977: pay_balance_feeds_f pbf,
2978: pay_input_values_f piv
2979: where act.assignment_id = alb.assignment_id
2980: and alb.assignment_id in
2981: (select distinct asg.assignment_id
2982: from per_all_assignments_f asg

Line 3001: pay_input_values_f piv,

2997: ) is
2998: select
2999: plb.latest_balance_id
3000: from
3001: pay_input_values_f piv,
3002: pay_balance_feeds_f pbf,
3003: pay_defined_balances pdb,
3004: pay_latest_balances plb,
3005: pay_assignment_actions paa,

Line 5385: l_inp_val_name pay_input_values_f.name%type;

5381: rev_assact number; -- reversal assignment_action_id.
5382: leg_code per_business_groups_perf.legislation_code%type;
5383: l_process_path pay_assignment_actions.process_path%type;
5384: l_found boolean;
5385: l_inp_val_name pay_input_values_f.name%type;
5386: l_rev_lat_bal_maintenance boolean;
5387: l_rule_mode pay_legislation_rules.rule_mode%type;
5388: l_si_needed pay_legislation_rules.rule_mode%type;
5389: l_st_needed pay_legislation_rules.rule_mode%type;

Line 5762: pay_input_values_f piv

5758: 'ND' , rtrim(to_char((-1) * to_number(rrv.result_value, mask_36_dec_places), mask_36_dec_places), '.'),
5759: rrv.result_value)
5760: from pay_payroll_actions pac,
5761: pay_run_result_values rrv,
5762: pay_input_values_f piv
5763: where pac.payroll_action_id = pactid
5764: and rrv.run_result_id = oldrrid
5765: and piv.input_value_id = rrv.input_value_id
5766: and pac.effective_date between

Line 6208: pay_input_values_f piv

6204: prrv.input_value_id,
6205: prrv.run_result_id
6206: from pay_run_results prr,
6207: pay_run_result_values prrv,
6208: pay_input_values_f piv
6209: where prr.run_result_id = p_run_result_id
6210: and prrv.run_result_id = prr.run_result_id
6211: and piv.input_value_id = prrv.input_value_id
6212: and p_effective_date between piv.effective_start_date