DBA Data[Home] [Help]

APPS.GHR_SF113_A dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 6: l_asgn_hist_data PER_ASSIGNMENT_EXTRA_INFO%ROWTYPE;

2: /* $Header: ghsf113a.pkb 120.2.12010000.2 2009/09/30 09:21:34 utokachi ship $ */
3: --
4: g_package varchar2(33) := 'GHR_SF113_A.';
5: --
6: l_asgn_hist_data PER_ASSIGNMENT_EXTRA_INFO%ROWTYPE;
7: l_people_hist_data PER_PEOPLE_EXTRA_INFO%ROWTYPE;
8: l_pos_hist_data PER_POSITION_EXTRA_INFO%ROWTYPE;
9: l_person_id PER_ASSIGNMENTS_F.PERSON_ID%TYPE;
10: l_assignment_id PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;

Line 16: l_tenure PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION4%TYPE;

12: l_grade_id PER_ASSIGNMENTS_F.GRADE_ID%TYPE;
13: l_loc_id PER_ASSIGNMENTS_F.LOCATION_ID%TYPE;
14: l_start_date PER_ASSIGNMENTS_F.EFFECTIVE_START_DATE%TYPE;
15: l_end_date PER_ASSIGNMENTS_F.EFFECTIVE_END_DATE%TYPE;
16: l_tenure PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION4%TYPE;
17: l_date_end HR_ALL_POSITIONS_F.DATE_END%TYPE;
18: l_date_effective HR_ALL_POSITIONS_F.DATE_END%TYPE;
19: l_work_schedule PER_POSITION_EXTRA_INFO. POEI_INFORMATION10%TYPE;
20: l_position_code PER_POSITION_EXTRA_INFO.POEI_INFORMATION3%TYPE;