APPS.HR_H2PI_PERSON_UPLOAD dependencies on HR_H2PI_FEDERAL_TAX_RULES_V

Line 2268: FROM hr_h2pi_federal_tax_rules_v

2264: hr_utility.set_location(l_proc, 200);
2265: BEGIN
2266: SELECT emp_fed_tax_rule_id
2267: INTO l_emp_fed_tax_rule_id
2268: FROM hr_h2pi_federal_tax_rules_v
2269: WHERE assignment_id = l_assignment_id
2270: AND v_ud_asg.effective_start_date BETWEEN effective_start_date
2271: AND effective_end_date;
2272:

Line 3938: FROM hr_h2pi_federal_tax_rules_v fed

3934:
3935: CURSOR csr_ed_federal_tax_rule (p_fed_id NUMBER,
3936: p_esd DATE) IS
3937: SELECT *
3938: FROM hr_h2pi_federal_tax_rules_v fed
3939: WHERE fed.emp_fed_tax_rule_id = p_fed_id
3940: AND p_esd BETWEEN fed.effective_start_date
3941: AND fed.effective_end_date;
3942:

Line 3956: v_ed_fed hr_h2pi_federal_tax_rules_v%ROWTYPE;

3952:
3953: l_proc VARCHAR2(72) := g_package||'upload_federal_tax_rule';
3954:
3955: v_ud_fed hr_h2pi_federal_tax_rules%ROWTYPE;
3956: v_ed_fed hr_h2pi_federal_tax_rules_v%ROWTYPE;
3957:
3958: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
3959: l_emp_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
3960: l_ovn pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;