DBA Data[Home] [Help]

APPS.HR_SUIT_MATCH_UTILITY_WEB dependencies on PER_PEOPLE_F

Line 6: person_id per_people_f.person_id%type

2: /* $Header: hrsmutlw.pkh 120.3 2005/12/13 13:42:55 svittal noship $ */
3:
4:
5: TYPE g_people_rec IS RECORD(
6: person_id per_people_f.person_id%type
7: ,employee_number per_people_f.employee_number%type
8: ,applicant_number per_people_f.applicant_number%type
9: ,name per_people_f.full_name%type
10: ,work_phone per_people_f.work_telephone%type

Line 7: ,employee_number per_people_f.employee_number%type

3:
4:
5: TYPE g_people_rec IS RECORD(
6: person_id per_people_f.person_id%type
7: ,employee_number per_people_f.employee_number%type
8: ,applicant_number per_people_f.applicant_number%type
9: ,name per_people_f.full_name%type
10: ,work_phone per_people_f.work_telephone%type
11: ,hire_date per_periods_of_service.date_start%type

Line 8: ,applicant_number per_people_f.applicant_number%type

4:
5: TYPE g_people_rec IS RECORD(
6: person_id per_people_f.person_id%type
7: ,employee_number per_people_f.employee_number%type
8: ,applicant_number per_people_f.applicant_number%type
9: ,name per_people_f.full_name%type
10: ,work_phone per_people_f.work_telephone%type
11: ,hire_date per_periods_of_service.date_start%type
12: ,location_code per_people_f.internal_location%type

Line 9: ,name per_people_f.full_name%type

5: TYPE g_people_rec IS RECORD(
6: person_id per_people_f.person_id%type
7: ,employee_number per_people_f.employee_number%type
8: ,applicant_number per_people_f.applicant_number%type
9: ,name per_people_f.full_name%type
10: ,work_phone per_people_f.work_telephone%type
11: ,hire_date per_periods_of_service.date_start%type
12: ,location_code per_people_f.internal_location%type
13: ,person_type varchar2(2000) );

Line 10: ,work_phone per_people_f.work_telephone%type

6: person_id per_people_f.person_id%type
7: ,employee_number per_people_f.employee_number%type
8: ,applicant_number per_people_f.applicant_number%type
9: ,name per_people_f.full_name%type
10: ,work_phone per_people_f.work_telephone%type
11: ,hire_date per_periods_of_service.date_start%type
12: ,location_code per_people_f.internal_location%type
13: ,person_type varchar2(2000) );
14: TYPE g_person_table IS TABLE of g_people_rec

Line 12: ,location_code per_people_f.internal_location%type

8: ,applicant_number per_people_f.applicant_number%type
9: ,name per_people_f.full_name%type
10: ,work_phone per_people_f.work_telephone%type
11: ,hire_date per_periods_of_service.date_start%type
12: ,location_code per_people_f.internal_location%type
13: ,person_type varchar2(2000) );
14: TYPE g_person_table IS TABLE of g_people_rec
15: INDEX BY BINARY_INTEGER;
16: