APPS.GHR_EEOC_DYNAMICS_REPORT dependencies on PER_ALL_PEOPLE

Line 17: l_full_name PER_ALL_PEOPLE.FULL_NAME%TYPE;

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

Line 18: l_emp_no PER_ALL_PEOPLE.EMPLOYEE_NUMBER%TYPE;

14: l_peopei_data PER_PEOPLE_EXTRA_INFO%ROWTYPE;
15: l_effective_start_date DATE;
16: l_value NUMBER;
17: l_full_name PER_ALL_PEOPLE.FULL_NAME%TYPE;
18: l_emp_no PER_ALL_PEOPLE.EMPLOYEE_NUMBER%TYPE;
19: l_log_text VARCHAR2(2000);
20: l_records_found BOOLEAN := FALSE;
21: l_mesgbuff1 VARCHAR2(4000);
22:

Line 28: per_all_people_f per

24: cursor get_par_actions
25: is
26: SELECT par.*, per.full_name, per.employee_number
27: FROM ghr_pa_requests par,
28: per_all_people_f per
29: WHERE NVL(par.agency_code,par.from_agency_code) LIKE p_agency_code||NVL(p_agency_sub_code,'%')
30: AND par.person_id = per.person_id
31: AND trunc(par.effective_date) BETWEEN p_report_st_dt AND p_report_end_dt
32: AND trunc(par.effective_date) BETWEEN per.effective_start_date AND per.effective_end_date