DBA Data[Home] [Help]

APPS.GHR_EMPLOYEE_API dependencies on PER_PEOPLE_F

Line 115: l_employee_number per_people_f.employee_number%TYPE;

111: -- Declare cursors and local variables
112: --
113: l_proc varchar2(72) := g_package||'create_us_employee';
114: l_hire_date date;
115: l_employee_number per_people_f.employee_number%TYPE;
116: l_person_type_id per_people_f.person_type_id%TYPE;
117: l_person_id per_people_f.person_id%TYPE;
118: --l_application_id per_applications.application_id%TYPE;
119: l_assignment_id per_assignments_f.assignment_id%TYPE;

Line 116: l_person_type_id per_people_f.person_type_id%TYPE;

112: --
113: l_proc varchar2(72) := g_package||'create_us_employee';
114: l_hire_date date;
115: l_employee_number per_people_f.employee_number%TYPE;
116: l_person_type_id per_people_f.person_type_id%TYPE;
117: l_person_id per_people_f.person_id%TYPE;
118: --l_application_id per_applications.application_id%TYPE;
119: l_assignment_id per_assignments_f.assignment_id%TYPE;
120: --

Line 117: l_person_id per_people_f.person_id%TYPE;

113: l_proc varchar2(72) := g_package||'create_us_employee';
114: l_hire_date date;
115: l_employee_number per_people_f.employee_number%TYPE;
116: l_person_type_id per_people_f.person_type_id%TYPE;
117: l_person_id per_people_f.person_id%TYPE;
118: --l_application_id per_applications.application_id%TYPE;
119: l_assignment_id per_assignments_f.assignment_id%TYPE;
120: --
121: begin