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