APPS.HR_H2PI_PERSON_UPLOAD dependencies on HR_H2PI_CITY_TAX_RULES_V

Line 1641: FROM hr_h2pi_city_tax_rules_v

1637: CURSOR csr_city_tax_rule (p_asg_id NUMBER,
1638: p_date DATE) IS
1639: SELECT emp_city_tax_rule_id,
1640: jurisdiction_code
1641: FROM hr_h2pi_city_tax_rules_v
1642: WHERE assignment_id = p_asg_id
1643: AND p_date BETWEEN effective_start_date
1644: AND effective_end_date;
1645:

Line 4708: FROM hr_h2pi_city_tax_rules_v cty

4704:
4705: CURSOR csr_ed_city_tax_rule (p_cty_id NUMBER,
4706: p_esd DATE) IS
4707: SELECT *
4708: FROM hr_h2pi_city_tax_rules_v cty
4709: WHERE cty.emp_city_tax_rule_id = p_cty_id
4710: AND p_esd BETWEEN cty.effective_start_date
4711: AND cty.effective_end_date;
4712:

Line 4726: v_ed_cty hr_h2pi_city_tax_rules_v%ROWTYPE;

4722:
4723: l_proc VARCHAR2(72) := g_package||'upload_city_tax_rule';
4724:
4725: v_ud_cty hr_h2pi_city_tax_rules%ROWTYPE;
4726: v_ed_cty hr_h2pi_city_tax_rules_v%ROWTYPE;
4727:
4728: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
4729: l_emp_city_tax_rule_id
4730: pay_us_emp_city_tax_rules_f.emp_city_tax_rule_id%TYPE;