DBA Data[Home] [Help]

APPS.GHR_CPDF_EHRIS dependencies on PER_ASSIGNMENTS_F

Line 109: g_assignment_id PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;

105:
106: g_ghr_cpdf_temp GHR_CPDF_TEMP%ROWTYPE;
107: g_agency VARCHAR2(04);
108: g_report_date DATE;
109: g_assignment_id PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
110: g_person_id PER_ASSIGNMENTS_F.PERSON_ID%TYPE;
111: g_position_id PER_ASSIGNMENTS_F.POSITION_ID%TYPE;
112: g_grade_id PER_ASSIGNMENTS_F.GRADE_ID%TYPE;
113: g_job_id PER_ASSIGNMENTS_F.JOB_ID%TYPE;

Line 110: g_person_id PER_ASSIGNMENTS_F.PERSON_ID%TYPE;

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

Line 111: g_position_id PER_ASSIGNMENTS_F.POSITION_ID%TYPE;

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

Line 112: g_grade_id PER_ASSIGNMENTS_F.GRADE_ID%TYPE;

108: g_report_date DATE;
109: g_assignment_id PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
110: g_person_id PER_ASSIGNMENTS_F.PERSON_ID%TYPE;
111: g_position_id PER_ASSIGNMENTS_F.POSITION_ID%TYPE;
112: g_grade_id PER_ASSIGNMENTS_F.GRADE_ID%TYPE;
113: g_job_id PER_ASSIGNMENTS_F.JOB_ID%TYPE;
114: g_location_id PER_ASSIGNMENTS_F.LOCATION_ID%TYPE;
115: g_appointment_date PER_PEOPLE_V.HIRE_DATE%TYPE;
116: g_business_group_id PER_ASSIGNMENTS_F.business_group_id%TYPE;

Line 113: g_job_id PER_ASSIGNMENTS_F.JOB_ID%TYPE;

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

Line 114: g_location_id PER_ASSIGNMENTS_F.LOCATION_ID%TYPE;

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

Line 116: g_business_group_id PER_ASSIGNMENTS_F.business_group_id%TYPE;

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