DBA Data[Home] [Help]

APPS.BEN_EXT_PERSON dependencies on PER_JOBS

Line 254: g_job per_jobs.name%TYPE;

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

Line 265: g_job_id per_jobs.job_id%TYPE;

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

Line 1093: g_job_flex_01 per_jobs.attribute1%TYPE;

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

Line 1094: g_job_flex_02 per_jobs.attribute2%TYPE;

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

Line 1095: g_job_flex_03 per_jobs.attribute3%TYPE;

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

Line 1096: g_job_flex_04 per_jobs.attribute4%TYPE;

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

Line 1097: g_job_flex_05 per_jobs.attribute5%TYPE;

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

Line 1098: g_job_flex_06 per_jobs.attribute6%TYPE;

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

Line 1099: g_job_flex_07 per_jobs.attribute7%TYPE;

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

Line 1100: g_job_flex_08 per_jobs.attribute8%TYPE;

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

Line 1101: g_job_flex_09 per_jobs.attribute9%TYPE;

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

Line 1102: g_job_flex_10 per_jobs.attribute10%TYPE;

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

Line 1265: g_CWB_Person_JOB_name per_jobs.name%type ;

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

Line 1285: g_CWB_new_Job_name per_jobs.name%type ;

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