APPS.HR_NL_EXTRA_ASG_RULES dependencies on PER_ALL_PEOPLE_F

Line 42: l_mar_status per_all_people_f.marital_status%TYPE;

38: l_1_digit VARCHAR2(1);
39: l_2_digit VARCHAR2(1);
40: l_3_digit VARCHAR2(1);
41: l_valid BOOLEAN;
42: l_mar_status per_all_people_f.marital_status%TYPE;
43: l_lookup_desc hr_lookups.meaning%TYPE;
44: l_age NUMBER;
45: l_tax_code VARCHAR2(60);
46: l_tax_red_apply VARCHAR2(60);

Line 62: FROM per_all_people_f

58: --
59: CURSOR csr_get_marital_status(p_person_id NUMBER
60: ,p_effective_date DATE) IS
61: SELECT marital_status
62: FROM per_all_people_f
63: WHERE person_id = p_person_id
64: AND p_effective_date BETWEEN effective_start_date
65: AND effective_end_date;
66: --