APPS.HR_H2PI_PERSON_UPLOAD dependencies on HR_H2PI_EMPLOYEES_V

Line 692: FROM hr_h2pi_employees_v per

688: p_esd DATE) IS
689: SELECT per.person_type,
690: per.effective_start_date,
691: per.effective_end_date
692: FROM hr_h2pi_employees_v per
693: WHERE per.person_id = p_per_id
694: AND p_esd BETWEEN per.effective_start_date
695: AND per.effective_end_date;
696:

Line 1711: l_dummy_person_type hr_h2pi_employees_v.person_type%TYPE;

1707: l_emp_state_tax_rule_id hr_h2pi_state_tax_rules.emp_state_tax_rule_id%TYPE;
1708: l_emp_county_tax_rule_id hr_h2pi_county_tax_rules.emp_county_tax_rule_id%TYPE;
1709: l_emp_city_tax_rule_id hr_h2pi_city_tax_rules.emp_city_tax_rule_id%TYPE;
1710:
1711: l_dummy_person_type hr_h2pi_employees_v.person_type%TYPE;
1712: l_future_term_flag BOOLEAN := FALSE;
1713:
1714: BEGIN
1715: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 2015: FROM hr_h2pi_employees_v

2011:
2012: BEGIN
2013: SELECT DISTINCT person_type
2014: INTO l_dummy_person_type
2015: FROM hr_h2pi_employees_v
2016: WHERE person_id = l_person_id
2017: AND effective_start_date < v_ud_asg.effective_end_date
2018: AND effective_end_date > v_ud_asg.effective_start_date;
2019: EXCEPTION