APPS.PER_BOOKINGS_PKG dependencies on PER_PEOPLE_F

Line 36: FROM PER_PEOPLE_F PPF

32: l_New_Date date;
33:
34: CURSOR C1 IS
35: SELECT 1
36: FROM PER_PEOPLE_F PPF
37: WHERE PPF.PERSON_ID = to_number(P_Person_id)
38: AND PPF.CURRENT_EMPLOYEE_FLAG = 'Y'
39: AND l_New_Date between PPF.EFFECTIVE_START_DATE AND
40: PPF.EFFECTIVE_END_DATE;

Line 44: FROM PER_PEOPLE_F PPF

40: PPF.EFFECTIVE_END_DATE;
41:
42: CURSOR C2 IS
43: SELECT 1
44: FROM PER_PEOPLE_F PPF
45: WHERE PPF.PERSON_ID = to_number(P_Person_id)
46: AND PPF.CURRENT_APPLICANT_FLAG = 'Y'
47: AND l_New_Date between PPF.EFFECTIVE_START_DATE AND
48: PPF.EFFECTIVE_END_DATE;

Line 52: FROM PER_PEOPLE_F PPF

48: PPF.EFFECTIVE_END_DATE;
49:
50: CURSOR C3 IS
51: SELECT 1
52: FROM PER_PEOPLE_F PPF
53: WHERE PPF.PERSON_ID = to_number(P_Person_id)
54: AND PPF.CURRENT_APPLICANT_FLAG = 'Y'
55: AND PPF.CURRENT_EMPLOYEE_FLAG = 'Y'
56: AND l_New_Date between PPF.EFFECTIVE_START_DATE AND