APPS.HR_H2PI_PERSON_UPLOAD dependencies on HR_H2PI_COUNTY_TAX_RULES_V

Line 1632: FROM hr_h2pi_county_tax_rules_v

1628: CURSOR csr_county_tax_rule (p_asg_id NUMBER,
1629: p_date DATE) IS
1630: SELECT emp_county_tax_rule_id,
1631: jurisdiction_code
1632: FROM hr_h2pi_county_tax_rules_v
1633: WHERE assignment_id = p_asg_id
1634: AND p_date BETWEEN effective_start_date
1635: AND effective_end_date;
1636:

Line 4453: FROM hr_h2pi_county_tax_rules_v cnt

4449:
4450: CURSOR csr_ed_county_tax_rule (p_cnt_id NUMBER,
4451: p_esd DATE) IS
4452: SELECT *
4453: FROM hr_h2pi_county_tax_rules_v cnt
4454: WHERE cnt.emp_county_tax_rule_id = p_cnt_id
4455: AND p_esd BETWEEN cnt.effective_start_date
4456: AND cnt.effective_end_date;
4457:

Line 4471: v_ed_cnt hr_h2pi_county_tax_rules_v%ROWTYPE;

4467:
4468: l_proc VARCHAR2(72) := g_package||'upload_county_tax_rule';
4469:
4470: v_ud_cnt hr_h2pi_county_tax_rules%ROWTYPE;
4471: v_ed_cnt hr_h2pi_county_tax_rules_v%ROWTYPE;
4472:
4473: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
4474: l_emp_county_tax_rule_id
4475: pay_us_emp_county_tax_rules_f.emp_county_tax_rule_id%TYPE;