DBA Data[Home] [Help]

APPS.BEN_EXT_PERSON dependencies on PER_JOBS

Line 251: g_job per_jobs.name%TYPE;

247: g_org_location_region3 hr_locations.REGION_3%TYPE;
248: g_org_location_phone hr_locations.Telephone_number_1%TYPE;
249: --
250:
251: g_job per_jobs.name%TYPE;
252: g_position per_positions.name%TYPE;
253: g_payroll pay_all_payrolls_f.payroll_name%TYPE;
254: g_people_group pay_people_groups.group_name%TYPE;
255: g_pay_basis per_pay_bases.name%TYPE;

Line 262: g_job_id per_jobs.job_id%TYPE;

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;
265: g_people_group_id pay_people_groups.people_group_id%TYPE;
266: g_pay_basis_id per_pay_bases.pay_basis_id%TYPE;

Line 1090: g_job_flex_01 per_jobs.attribute1%TYPE;

1086: g_pos_flex_08 per_positions.attribute8%TYPE;
1087: g_pos_flex_09 per_positions.attribute9%TYPE;
1088: g_pos_flex_10 per_positions.attribute10%TYPE;
1089: --
1090: g_job_flex_01 per_jobs.attribute1%TYPE;
1091: g_job_flex_02 per_jobs.attribute2%TYPE;
1092: g_job_flex_03 per_jobs.attribute3%TYPE;
1093: g_job_flex_04 per_jobs.attribute4%TYPE;
1094: g_job_flex_05 per_jobs.attribute5%TYPE;

Line 1091: g_job_flex_02 per_jobs.attribute2%TYPE;

1087: g_pos_flex_09 per_positions.attribute9%TYPE;
1088: g_pos_flex_10 per_positions.attribute10%TYPE;
1089: --
1090: g_job_flex_01 per_jobs.attribute1%TYPE;
1091: g_job_flex_02 per_jobs.attribute2%TYPE;
1092: g_job_flex_03 per_jobs.attribute3%TYPE;
1093: g_job_flex_04 per_jobs.attribute4%TYPE;
1094: g_job_flex_05 per_jobs.attribute5%TYPE;
1095: g_job_flex_06 per_jobs.attribute6%TYPE;

Line 1092: g_job_flex_03 per_jobs.attribute3%TYPE;

1088: g_pos_flex_10 per_positions.attribute10%TYPE;
1089: --
1090: g_job_flex_01 per_jobs.attribute1%TYPE;
1091: g_job_flex_02 per_jobs.attribute2%TYPE;
1092: g_job_flex_03 per_jobs.attribute3%TYPE;
1093: g_job_flex_04 per_jobs.attribute4%TYPE;
1094: g_job_flex_05 per_jobs.attribute5%TYPE;
1095: g_job_flex_06 per_jobs.attribute6%TYPE;
1096: g_job_flex_07 per_jobs.attribute7%TYPE;

Line 1093: g_job_flex_04 per_jobs.attribute4%TYPE;

1089: --
1090: g_job_flex_01 per_jobs.attribute1%TYPE;
1091: g_job_flex_02 per_jobs.attribute2%TYPE;
1092: g_job_flex_03 per_jobs.attribute3%TYPE;
1093: g_job_flex_04 per_jobs.attribute4%TYPE;
1094: g_job_flex_05 per_jobs.attribute5%TYPE;
1095: g_job_flex_06 per_jobs.attribute6%TYPE;
1096: g_job_flex_07 per_jobs.attribute7%TYPE;
1097: g_job_flex_08 per_jobs.attribute8%TYPE;

Line 1094: g_job_flex_05 per_jobs.attribute5%TYPE;

1090: g_job_flex_01 per_jobs.attribute1%TYPE;
1091: g_job_flex_02 per_jobs.attribute2%TYPE;
1092: g_job_flex_03 per_jobs.attribute3%TYPE;
1093: g_job_flex_04 per_jobs.attribute4%TYPE;
1094: g_job_flex_05 per_jobs.attribute5%TYPE;
1095: g_job_flex_06 per_jobs.attribute6%TYPE;
1096: g_job_flex_07 per_jobs.attribute7%TYPE;
1097: g_job_flex_08 per_jobs.attribute8%TYPE;
1098: g_job_flex_09 per_jobs.attribute9%TYPE;

Line 1095: g_job_flex_06 per_jobs.attribute6%TYPE;

1091: g_job_flex_02 per_jobs.attribute2%TYPE;
1092: g_job_flex_03 per_jobs.attribute3%TYPE;
1093: g_job_flex_04 per_jobs.attribute4%TYPE;
1094: g_job_flex_05 per_jobs.attribute5%TYPE;
1095: g_job_flex_06 per_jobs.attribute6%TYPE;
1096: g_job_flex_07 per_jobs.attribute7%TYPE;
1097: g_job_flex_08 per_jobs.attribute8%TYPE;
1098: g_job_flex_09 per_jobs.attribute9%TYPE;
1099: g_job_flex_10 per_jobs.attribute10%TYPE;

Line 1096: g_job_flex_07 per_jobs.attribute7%TYPE;

1092: g_job_flex_03 per_jobs.attribute3%TYPE;
1093: g_job_flex_04 per_jobs.attribute4%TYPE;
1094: g_job_flex_05 per_jobs.attribute5%TYPE;
1095: g_job_flex_06 per_jobs.attribute6%TYPE;
1096: g_job_flex_07 per_jobs.attribute7%TYPE;
1097: g_job_flex_08 per_jobs.attribute8%TYPE;
1098: g_job_flex_09 per_jobs.attribute9%TYPE;
1099: g_job_flex_10 per_jobs.attribute10%TYPE;
1100: --

Line 1097: g_job_flex_08 per_jobs.attribute8%TYPE;

1093: g_job_flex_04 per_jobs.attribute4%TYPE;
1094: g_job_flex_05 per_jobs.attribute5%TYPE;
1095: g_job_flex_06 per_jobs.attribute6%TYPE;
1096: g_job_flex_07 per_jobs.attribute7%TYPE;
1097: g_job_flex_08 per_jobs.attribute8%TYPE;
1098: g_job_flex_09 per_jobs.attribute9%TYPE;
1099: g_job_flex_10 per_jobs.attribute10%TYPE;
1100: --
1101: g_grd_flex_01 per_grades.attribute1%TYPE;

Line 1098: g_job_flex_09 per_jobs.attribute9%TYPE;

1094: g_job_flex_05 per_jobs.attribute5%TYPE;
1095: g_job_flex_06 per_jobs.attribute6%TYPE;
1096: g_job_flex_07 per_jobs.attribute7%TYPE;
1097: g_job_flex_08 per_jobs.attribute8%TYPE;
1098: g_job_flex_09 per_jobs.attribute9%TYPE;
1099: g_job_flex_10 per_jobs.attribute10%TYPE;
1100: --
1101: g_grd_flex_01 per_grades.attribute1%TYPE;
1102: g_grd_flex_02 per_grades.attribute2%TYPE;

Line 1099: g_job_flex_10 per_jobs.attribute10%TYPE;

1095: g_job_flex_06 per_jobs.attribute6%TYPE;
1096: g_job_flex_07 per_jobs.attribute7%TYPE;
1097: g_job_flex_08 per_jobs.attribute8%TYPE;
1098: g_job_flex_09 per_jobs.attribute9%TYPE;
1099: g_job_flex_10 per_jobs.attribute10%TYPE;
1100: --
1101: g_grd_flex_01 per_grades.attribute1%TYPE;
1102: g_grd_flex_02 per_grades.attribute2%TYPE;
1103: g_grd_flex_03 per_grades.attribute3%TYPE;

Line 1262: g_CWB_Person_JOB_name per_jobs.name%type ;

1258: g_CWB_Person_GRADE_name per_grades.name%type ;
1259: g_CWB_Person_Grade_QUARTILE hr_lookups.meaning%type ;
1260: g_CWB_Person_GRADE_ANN_FACTOR ben_cwb_person_info.GRADE_ANNULIZATION_FACTOR%type ;
1261: g_CWB_Person_Grade_COMPARATIO ben_cwb_person_info.Grd_COMPARATIO%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;

Line 1282: g_CWB_new_Job_name per_jobs.name%type ;

1278: g_CWB_Person_YEARS_IN_GRADE ben_cwb_person_info.YEARS_IN_GRADE%type ;
1279: g_CWB_Person_YEARS_IN_POS ben_cwb_person_info.YEARS_IN_POSITION%type ;
1280: g_CWB_Person_YEARS_IN_JOB ben_cwb_person_info.YEARS_IN_JOB%type ;
1281: g_cwb_nw_chg_reason hr_lookups.meaning%type ;
1282: g_CWB_new_Job_name per_jobs.name%type ;
1283: g_CWB_new_Grade_name per_grades.name%type ;
1284: g_CWB_new_Group_name ben_cwb_person_info.PEOPLE_GROUP_name%type ;
1285: g_CWB_new_Postion_name per_positions.name%Type ;
1286: g_CWB_new_Perf_rating hr_lookups.meaning%type ;