DBA Data[Home] [Help]

APPS.GHR_CPDF_EHRIS dependencies on PER_ASSIGNMENTS_F

Line 113: g_assignment_id PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;

109:
110: g_ghr_cpdf_temp GHR_CPDF_TEMP%ROWTYPE;
111: g_agency VARCHAR2(04);
112: g_report_date DATE;
113: g_assignment_id PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
114: g_person_id PER_ASSIGNMENTS_F.PERSON_ID%TYPE;
115: g_position_id PER_ASSIGNMENTS_F.POSITION_ID%TYPE;
116: g_grade_id PER_ASSIGNMENTS_F.GRADE_ID%TYPE;
117: g_job_id PER_ASSIGNMENTS_F.JOB_ID%TYPE;

Line 114: g_person_id PER_ASSIGNMENTS_F.PERSON_ID%TYPE;

110: g_ghr_cpdf_temp GHR_CPDF_TEMP%ROWTYPE;
111: g_agency VARCHAR2(04);
112: g_report_date DATE;
113: g_assignment_id PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
114: g_person_id PER_ASSIGNMENTS_F.PERSON_ID%TYPE;
115: g_position_id PER_ASSIGNMENTS_F.POSITION_ID%TYPE;
116: g_grade_id PER_ASSIGNMENTS_F.GRADE_ID%TYPE;
117: g_job_id PER_ASSIGNMENTS_F.JOB_ID%TYPE;
118: g_location_id PER_ASSIGNMENTS_F.LOCATION_ID%TYPE;

Line 115: g_position_id PER_ASSIGNMENTS_F.POSITION_ID%TYPE;

111: g_agency VARCHAR2(04);
112: g_report_date DATE;
113: g_assignment_id PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
114: g_person_id PER_ASSIGNMENTS_F.PERSON_ID%TYPE;
115: g_position_id PER_ASSIGNMENTS_F.POSITION_ID%TYPE;
116: g_grade_id PER_ASSIGNMENTS_F.GRADE_ID%TYPE;
117: g_job_id PER_ASSIGNMENTS_F.JOB_ID%TYPE;
118: g_location_id PER_ASSIGNMENTS_F.LOCATION_ID%TYPE;
119: g_appointment_date PER_PEOPLE_V.HIRE_DATE%TYPE;

Line 116: g_grade_id PER_ASSIGNMENTS_F.GRADE_ID%TYPE;

112: g_report_date DATE;
113: g_assignment_id PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
114: g_person_id PER_ASSIGNMENTS_F.PERSON_ID%TYPE;
115: g_position_id PER_ASSIGNMENTS_F.POSITION_ID%TYPE;
116: g_grade_id PER_ASSIGNMENTS_F.GRADE_ID%TYPE;
117: g_job_id PER_ASSIGNMENTS_F.JOB_ID%TYPE;
118: g_location_id PER_ASSIGNMENTS_F.LOCATION_ID%TYPE;
119: g_appointment_date PER_PEOPLE_V.HIRE_DATE%TYPE;
120: g_business_group_id PER_ASSIGNMENTS_F.business_group_id%TYPE;

Line 117: g_job_id PER_ASSIGNMENTS_F.JOB_ID%TYPE;

113: g_assignment_id PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
114: g_person_id PER_ASSIGNMENTS_F.PERSON_ID%TYPE;
115: g_position_id PER_ASSIGNMENTS_F.POSITION_ID%TYPE;
116: g_grade_id PER_ASSIGNMENTS_F.GRADE_ID%TYPE;
117: g_job_id PER_ASSIGNMENTS_F.JOB_ID%TYPE;
118: g_location_id PER_ASSIGNMENTS_F.LOCATION_ID%TYPE;
119: g_appointment_date PER_PEOPLE_V.HIRE_DATE%TYPE;
120: g_business_group_id PER_ASSIGNMENTS_F.business_group_id%TYPE;
121: -- Begin Bug# 4753092

Line 118: g_location_id PER_ASSIGNMENTS_F.LOCATION_ID%TYPE;

114: g_person_id PER_ASSIGNMENTS_F.PERSON_ID%TYPE;
115: g_position_id PER_ASSIGNMENTS_F.POSITION_ID%TYPE;
116: g_grade_id PER_ASSIGNMENTS_F.GRADE_ID%TYPE;
117: g_job_id PER_ASSIGNMENTS_F.JOB_ID%TYPE;
118: g_location_id PER_ASSIGNMENTS_F.LOCATION_ID%TYPE;
119: g_appointment_date PER_PEOPLE_V.HIRE_DATE%TYPE;
120: g_business_group_id PER_ASSIGNMENTS_F.business_group_id%TYPE;
121: -- Begin Bug# 4753092
122: g_message_name ghr_process_log.message_name%type;

Line 120: g_business_group_id PER_ASSIGNMENTS_F.business_group_id%TYPE;

116: g_grade_id PER_ASSIGNMENTS_F.GRADE_ID%TYPE;
117: g_job_id PER_ASSIGNMENTS_F.JOB_ID%TYPE;
118: g_location_id PER_ASSIGNMENTS_F.LOCATION_ID%TYPE;
119: g_appointment_date PER_PEOPLE_V.HIRE_DATE%TYPE;
120: g_business_group_id PER_ASSIGNMENTS_F.business_group_id%TYPE;
121: -- Begin Bug# 4753092
122: g_message_name ghr_process_log.message_name%type;
123: -- End Bug# 4753092
124: END ghr_cpdf_ehris;