[Home] [Help]
225: g_person_type_id per_person_types.person_type_id%type ;
226: --
227: g_employee_status per_assignment_status_types.user_status%TYPE;
228: g_employee_grade per_grades.name%TYPE;
229: g_employee_organization per_all_organization_units.name%TYPE;
230: --
231: g_location_code hr_locations.location_code%TYPE;
232: g_location_addr1 hr_locations.ADDRESS_LINE_1%TYPE;
233: g_location_addr2 hr_locations.ADDRESS_LINE_2%TYPE;
259: g_pay_basis_type per_pay_bases.pay_basis%TYPE;
260: --
261: g_employee_status_id per_assignment_status_types.assignment_status_type_id%TYPE;
262: g_employee_grade_id per_grades.grade_id%TYPE;
263: g_employee_organization_id per_all_organization_units.organization_id%TYPE;
264: g_location_id hr_locations.location_id%TYPE;
265: g_job_id per_jobs.job_id%TYPE;
266: g_position_id per_positions.position_id%TYPE;
267: g_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
1265: g_CWB_Person_JOB_name per_jobs.name%type ;
1266: g_CWB_Person_LEGISLATION ben_cwb_person_info.LEGISLATION_CODE%type ;
1267: g_CWB_Person_LOCATION hr_locations.location_code%TYPE ;
1268: g_CWB_Person_NORMAL_HOURS ben_cwb_person_info.NORMAL_HOURS%type ;
1269: g_CWB_Person_ORG_name per_all_organization_units.name%TYPE;
1270: g_CWB_Person_ORIG_START_DATE ben_cwb_person_info.ORIGINAL_START_DATE%type ;
1271: g_CWB_Person_PAY_RATE varchar2(100) ;
1272: g_CWB_Person_PAY_ANNUL_FACTOR ben_cwb_person_info.PAY_ANNULIZATION_FACTOR%type ;
1273: g_CWB_Person_PAYROLL_NAME pay_all_payrolls_f.payroll_name%TYPE;