APPS.HR_H2PI_PERSON_UPLOAD dependencies on HR_H2PI_STATE_TAX_RULES_V

Line 1623: FROM hr_h2pi_state_tax_rules_v

1619: CURSOR csr_state_tax_rule (p_asg_id NUMBER,
1620: p_date DATE) IS
1621: SELECT emp_state_tax_rule_id,
1622: jurisdiction_code
1623: FROM hr_h2pi_state_tax_rules_v
1624: WHERE assignment_id = p_asg_id
1625: AND p_date BETWEEN effective_start_date
1626: AND effective_end_date;
1627:

Line 4172: FROM hr_h2pi_state_tax_rules_v sta

4168:
4169: CURSOR csr_ed_state_tax_rule (p_sta_id NUMBER,
4170: p_esd DATE) IS
4171: SELECT *
4172: FROM hr_h2pi_state_tax_rules_v sta
4173: WHERE sta.emp_state_tax_rule_id = p_sta_id
4174: AND p_esd BETWEEN sta.effective_start_date
4175: AND sta.effective_end_date;
4176:

Line 4190: v_ed_sta hr_h2pi_state_tax_rules_v%ROWTYPE;

4186:
4187: l_proc VARCHAR2(72) := g_package||'upload_state_tax_rule';
4188:
4189: v_ud_sta hr_h2pi_state_tax_rules%ROWTYPE;
4190: v_ed_sta hr_h2pi_state_tax_rules_v%ROWTYPE;
4191:
4192: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
4193: l_emp_state_tax_rule_id
4194: pay_us_emp_state_tax_rules_f.emp_state_tax_rule_id%TYPE;

Line 5133: FROM hr_h2pi_state_tax_rules_v

5129:
5130: CURSOR csr_element_entry (p_asg_id NUMBER) IS
5131: SELECT emp_state_tax_rule_id,
5132: jurisdiction_code
5133: FROM hr_h2pi_state_tax_rules_v
5134: WHERE assignment_id = p_asg_id;
5135:
5136: l_proc VARCHAR2(72) := g_package||'upload_tax_percentage';
5137: