APPS.GHR_EEOC_STATUS_REPORT dependencies on PER_ALL_PEOPLE

Line 16: l_full_name PER_ALL_PEOPLE.FULL_NAME%TYPE;

12:
13: l_proc VARCHAR2(30) := 'populate_temp';
14: l_peopei_data PER_PEOPLE_EXTRA_INFO%ROWTYPE;
15: l_grade_id NUMBER;
16: l_full_name PER_ALL_PEOPLE.FULL_NAME%TYPE;
17: l_emp_no PER_ALL_PEOPLE.EMPLOYEE_NUMBER%TYPE;
18: l_log_text VARCHAR2(2000);
19: l_records_found BOOLEAN := FALSE;
20: l_mesgbuff1 VARCHAR2(4000);

Line 17: l_emp_no PER_ALL_PEOPLE.EMPLOYEE_NUMBER%TYPE;

13: l_proc VARCHAR2(30) := 'populate_temp';
14: l_peopei_data PER_PEOPLE_EXTRA_INFO%ROWTYPE;
15: l_grade_id NUMBER;
16: l_full_name PER_ALL_PEOPLE.FULL_NAME%TYPE;
17: l_emp_no PER_ALL_PEOPLE.EMPLOYEE_NUMBER%TYPE;
18: l_log_text VARCHAR2(2000);
19: l_records_found BOOLEAN := FALSE;
20: l_mesgbuff1 VARCHAR2(4000);
21:

Line 165: l_full_name PER_ALL_PEOPLE.FULL_NAME%TYPE;

161: p_employee_no OUT NOCOPY VARCHAR2
162: ) IS
163:
164: l_proc varchar2(30) := 'fetch_people_details';
165: l_full_name PER_ALL_PEOPLE.FULL_NAME%TYPE;
166: l_employee_number PER_ALL_PEOPLE.EMPLOYEE_NUMBER%TYPE;
167:
168: CURSOR c_per_det
169: IS

Line 166: l_employee_number PER_ALL_PEOPLE.EMPLOYEE_NUMBER%TYPE;

162: ) IS
163:
164: l_proc varchar2(30) := 'fetch_people_details';
165: l_full_name PER_ALL_PEOPLE.FULL_NAME%TYPE;
166: l_employee_number PER_ALL_PEOPLE.EMPLOYEE_NUMBER%TYPE;
167:
168: CURSOR c_per_det
169: IS
170: SELECT pap.sex,

Line 174: FROM per_all_people pap

170: SELECT pap.sex,
171: pap.date_of_birth,
172: pap.full_name,
173: pap.employee_number
174: FROM per_all_people pap
175: WHERE p_person_id = pap.person_id
176: AND p_report_date between pap.effective_start_date AND pap.effective_end_date;
177:
178: BEGIN

Line 423: FROM per_all_people PER ,

419: ,p_appointment_date OUT NOCOPY DATE) IS
420:
421: CURSOR cur_per IS
422: SELECT DECODE(PER.CURRENT_EMPLOYEE_FLAG, 'Y', PPS.DATE_START, DECODE(PER.CURRENT_NPW_FLAG, 'Y', PPP.DATE_START, NULL)) hire_date
423: FROM per_all_people PER ,
424: PER_PERIODS_OF_SERVICE PPS ,
425: PER_PERIODS_OF_PLACEMENT PPP
426: WHERE PPS.PERSON_ID (+) = PER.PERSON_ID AND
427: PPP.PERSON_ID (+) = PER.PERSON_ID AND