DBA Data[Home] [Help]

APPS.BEN_EXT_PERSON dependencies on PER_GRADES

Line 225: g_employee_grade per_grades.name%TYPE;

221: g_person_types per_person_types.user_person_type%type ;
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;

Line 259: g_employee_grade_id per_grades.grade_id%TYPE;

255: g_pay_basis per_pay_bases.name%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;

Line 1101: g_grd_flex_01 per_grades.attribute1%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;
1104: g_grd_flex_04 per_grades.attribute4%TYPE;
1105: g_grd_flex_05 per_grades.attribute5%TYPE;

Line 1102: g_grd_flex_02 per_grades.attribute2%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;
1104: g_grd_flex_04 per_grades.attribute4%TYPE;
1105: g_grd_flex_05 per_grades.attribute5%TYPE;
1106: g_grd_flex_06 per_grades.attribute6%TYPE;

Line 1103: g_grd_flex_03 per_grades.attribute3%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;
1104: g_grd_flex_04 per_grades.attribute4%TYPE;
1105: g_grd_flex_05 per_grades.attribute5%TYPE;
1106: g_grd_flex_06 per_grades.attribute6%TYPE;
1107: g_grd_flex_07 per_grades.attribute7%TYPE;

Line 1104: g_grd_flex_04 per_grades.attribute4%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;
1104: g_grd_flex_04 per_grades.attribute4%TYPE;
1105: g_grd_flex_05 per_grades.attribute5%TYPE;
1106: g_grd_flex_06 per_grades.attribute6%TYPE;
1107: g_grd_flex_07 per_grades.attribute7%TYPE;
1108: g_grd_flex_08 per_grades.attribute8%TYPE;

Line 1105: g_grd_flex_05 per_grades.attribute5%TYPE;

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;
1104: g_grd_flex_04 per_grades.attribute4%TYPE;
1105: g_grd_flex_05 per_grades.attribute5%TYPE;
1106: g_grd_flex_06 per_grades.attribute6%TYPE;
1107: g_grd_flex_07 per_grades.attribute7%TYPE;
1108: g_grd_flex_08 per_grades.attribute8%TYPE;
1109: g_grd_flex_09 per_grades.attribute9%TYPE;

Line 1106: g_grd_flex_06 per_grades.attribute6%TYPE;

1102: g_grd_flex_02 per_grades.attribute2%TYPE;
1103: g_grd_flex_03 per_grades.attribute3%TYPE;
1104: g_grd_flex_04 per_grades.attribute4%TYPE;
1105: g_grd_flex_05 per_grades.attribute5%TYPE;
1106: g_grd_flex_06 per_grades.attribute6%TYPE;
1107: g_grd_flex_07 per_grades.attribute7%TYPE;
1108: g_grd_flex_08 per_grades.attribute8%TYPE;
1109: g_grd_flex_09 per_grades.attribute9%TYPE;
1110: g_grd_flex_10 per_grades.attribute10%TYPE;

Line 1107: g_grd_flex_07 per_grades.attribute7%TYPE;

1103: g_grd_flex_03 per_grades.attribute3%TYPE;
1104: g_grd_flex_04 per_grades.attribute4%TYPE;
1105: g_grd_flex_05 per_grades.attribute5%TYPE;
1106: g_grd_flex_06 per_grades.attribute6%TYPE;
1107: g_grd_flex_07 per_grades.attribute7%TYPE;
1108: g_grd_flex_08 per_grades.attribute8%TYPE;
1109: g_grd_flex_09 per_grades.attribute9%TYPE;
1110: g_grd_flex_10 per_grades.attribute10%TYPE;
1111: --

Line 1108: g_grd_flex_08 per_grades.attribute8%TYPE;

1104: g_grd_flex_04 per_grades.attribute4%TYPE;
1105: g_grd_flex_05 per_grades.attribute5%TYPE;
1106: g_grd_flex_06 per_grades.attribute6%TYPE;
1107: g_grd_flex_07 per_grades.attribute7%TYPE;
1108: g_grd_flex_08 per_grades.attribute8%TYPE;
1109: g_grd_flex_09 per_grades.attribute9%TYPE;
1110: g_grd_flex_10 per_grades.attribute10%TYPE;
1111: --
1112: g_pbs_flex_01 per_pay_bases.attribute1%TYPE;

Line 1109: g_grd_flex_09 per_grades.attribute9%TYPE;

1105: g_grd_flex_05 per_grades.attribute5%TYPE;
1106: g_grd_flex_06 per_grades.attribute6%TYPE;
1107: g_grd_flex_07 per_grades.attribute7%TYPE;
1108: g_grd_flex_08 per_grades.attribute8%TYPE;
1109: g_grd_flex_09 per_grades.attribute9%TYPE;
1110: g_grd_flex_10 per_grades.attribute10%TYPE;
1111: --
1112: g_pbs_flex_01 per_pay_bases.attribute1%TYPE;
1113: g_pbs_flex_02 per_pay_bases.attribute2%TYPE;

Line 1110: g_grd_flex_10 per_grades.attribute10%TYPE;

1106: g_grd_flex_06 per_grades.attribute6%TYPE;
1107: g_grd_flex_07 per_grades.attribute7%TYPE;
1108: g_grd_flex_08 per_grades.attribute8%TYPE;
1109: g_grd_flex_09 per_grades.attribute9%TYPE;
1110: g_grd_flex_10 per_grades.attribute10%TYPE;
1111: --
1112: g_pbs_flex_01 per_pay_bases.attribute1%TYPE;
1113: g_pbs_flex_02 per_pay_bases.attribute2%TYPE;
1114: g_pbs_flex_03 per_pay_bases.attribute3%TYPE;

Line 1258: g_CWB_Person_GRADE_name per_grades.name%type ;

1254: g_CWB_Person_FREQUENCY ben_cwb_person_info.FREQUENCY%type ;
1255: g_CWB_Person_Grade_MAX_VAL ben_cwb_person_info.GRD_MAX_VAL%type ;
1256: g_CWB_Person_Grade_MID_POINT ben_cwb_person_info.GRD_MID_POINT%type ;
1257: g_CWB_Person_Grade_MIN_VAL ben_cwb_person_info.GRD_MIN_VAL%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 ;

Line 1283: g_CWB_new_Grade_name per_grades.name%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 ;
1287: --- CWB person Groups