DBA Data[Home] [Help]

APPS.GHR_EEOC_STATUS_REPORT dependencies on PER_PEOPLE_EXTRA_INFO

Line 14: l_peopei_data PER_PEOPLE_EXTRA_INFO%ROWTYPE;

10: ,p_agency_code IN VARCHAR2
11: ,p_agency_sub_code IN VARCHAR2) IS
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);

Line 226: l_perei_data PER_PEOPLE_EXTRA_INFO%ROWTYPE;

222:
223: PROCEDURE FETCH_PEREI_DETAILS(p_person_id in NUMBER,
224: p_report_date in DATE) IS
225: l_proc VARCHAR2(30) := 'fetch_perei_details';
226: l_perei_data PER_PEOPLE_EXTRA_INFO%ROWTYPE;
227: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
228: BEGIN
229: hr_utility.set_location('Entering:'||l_proc,5);
230: