APPS.PAY_NO_ABS_VALIDATION dependencies on PER_ALL_PEOPLE_F

Line 21: SELECT sex FROM per_all_people_f

17: ,P_DATE_PROJECTED_END in DATE
18: ,P_ABS_ATTENDANCE_REASON_ID in NUMBER) is
19:
20: CURSOR csr_get_gender(l_person_id NUMBER, l_date DATE) IS
21: SELECT sex FROM per_all_people_f
22: WHERE person_id = l_person_id
23: AND l_date BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
24:
25: -- Cursor to fetch global values

Line 34: SELECT start_date,PER_INFORMATION7 FROM per_all_people_f where

30: AND legislation_code = 'NO'
31: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
32:
33: CURSOR csr_get_person_hire_date(p_person_id number,p_effective_date date) IS
34: SELECT start_date,PER_INFORMATION7 FROM per_all_people_f where
35: person_id = p_person_id
36: AND P_EFFECTIVE_DATE BETWEEN EFFECTIVE_START_DATE
37: AND EFFECTIVE_END_DATE;
38: