DBA Data[Home] [Help]

APPS.BEN_EXT_PERSON dependencies on PER_POSITIONS

Line 255: g_position per_positions.name%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;
259: g_pay_basis_type per_pay_bases.pay_basis%TYPE;

Line 266: g_position_id per_positions.position_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;
270: g_payroll_period_type pay_all_payrolls_f.period_type%TYPE;

Line 1082: g_pos_flex_01 per_positions.attribute1%TYPE;

1078: g_prl_flex_08 pay_all_payrolls_f.attribute8%TYPE;
1079: g_prl_flex_09 pay_all_payrolls_f.attribute9%TYPE;
1080: g_prl_flex_10 pay_all_payrolls_f.attribute10%TYPE;
1081: --
1082: g_pos_flex_01 per_positions.attribute1%TYPE;
1083: g_pos_flex_02 per_positions.attribute2%TYPE;
1084: g_pos_flex_03 per_positions.attribute3%TYPE;
1085: g_pos_flex_04 per_positions.attribute4%TYPE;
1086: g_pos_flex_05 per_positions.attribute5%TYPE;

Line 1083: g_pos_flex_02 per_positions.attribute2%TYPE;

1079: g_prl_flex_09 pay_all_payrolls_f.attribute9%TYPE;
1080: g_prl_flex_10 pay_all_payrolls_f.attribute10%TYPE;
1081: --
1082: g_pos_flex_01 per_positions.attribute1%TYPE;
1083: g_pos_flex_02 per_positions.attribute2%TYPE;
1084: g_pos_flex_03 per_positions.attribute3%TYPE;
1085: g_pos_flex_04 per_positions.attribute4%TYPE;
1086: g_pos_flex_05 per_positions.attribute5%TYPE;
1087: g_pos_flex_06 per_positions.attribute6%TYPE;

Line 1084: g_pos_flex_03 per_positions.attribute3%TYPE;

1080: g_prl_flex_10 pay_all_payrolls_f.attribute10%TYPE;
1081: --
1082: g_pos_flex_01 per_positions.attribute1%TYPE;
1083: g_pos_flex_02 per_positions.attribute2%TYPE;
1084: g_pos_flex_03 per_positions.attribute3%TYPE;
1085: g_pos_flex_04 per_positions.attribute4%TYPE;
1086: g_pos_flex_05 per_positions.attribute5%TYPE;
1087: g_pos_flex_06 per_positions.attribute6%TYPE;
1088: g_pos_flex_07 per_positions.attribute7%TYPE;

Line 1085: g_pos_flex_04 per_positions.attribute4%TYPE;

1081: --
1082: g_pos_flex_01 per_positions.attribute1%TYPE;
1083: g_pos_flex_02 per_positions.attribute2%TYPE;
1084: g_pos_flex_03 per_positions.attribute3%TYPE;
1085: g_pos_flex_04 per_positions.attribute4%TYPE;
1086: g_pos_flex_05 per_positions.attribute5%TYPE;
1087: g_pos_flex_06 per_positions.attribute6%TYPE;
1088: g_pos_flex_07 per_positions.attribute7%TYPE;
1089: g_pos_flex_08 per_positions.attribute8%TYPE;

Line 1086: g_pos_flex_05 per_positions.attribute5%TYPE;

1082: g_pos_flex_01 per_positions.attribute1%TYPE;
1083: g_pos_flex_02 per_positions.attribute2%TYPE;
1084: g_pos_flex_03 per_positions.attribute3%TYPE;
1085: g_pos_flex_04 per_positions.attribute4%TYPE;
1086: g_pos_flex_05 per_positions.attribute5%TYPE;
1087: g_pos_flex_06 per_positions.attribute6%TYPE;
1088: g_pos_flex_07 per_positions.attribute7%TYPE;
1089: g_pos_flex_08 per_positions.attribute8%TYPE;
1090: g_pos_flex_09 per_positions.attribute9%TYPE;

Line 1087: g_pos_flex_06 per_positions.attribute6%TYPE;

1083: g_pos_flex_02 per_positions.attribute2%TYPE;
1084: g_pos_flex_03 per_positions.attribute3%TYPE;
1085: g_pos_flex_04 per_positions.attribute4%TYPE;
1086: g_pos_flex_05 per_positions.attribute5%TYPE;
1087: g_pos_flex_06 per_positions.attribute6%TYPE;
1088: g_pos_flex_07 per_positions.attribute7%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;

Line 1088: g_pos_flex_07 per_positions.attribute7%TYPE;

1084: g_pos_flex_03 per_positions.attribute3%TYPE;
1085: g_pos_flex_04 per_positions.attribute4%TYPE;
1086: g_pos_flex_05 per_positions.attribute5%TYPE;
1087: g_pos_flex_06 per_positions.attribute6%TYPE;
1088: g_pos_flex_07 per_positions.attribute7%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: --

Line 1089: g_pos_flex_08 per_positions.attribute8%TYPE;

1085: g_pos_flex_04 per_positions.attribute4%TYPE;
1086: g_pos_flex_05 per_positions.attribute5%TYPE;
1087: g_pos_flex_06 per_positions.attribute6%TYPE;
1088: g_pos_flex_07 per_positions.attribute7%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;

Line 1090: g_pos_flex_09 per_positions.attribute9%TYPE;

1086: g_pos_flex_05 per_positions.attribute5%TYPE;
1087: g_pos_flex_06 per_positions.attribute6%TYPE;
1088: g_pos_flex_07 per_positions.attribute7%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;

Line 1091: g_pos_flex_10 per_positions.attribute10%TYPE;

1087: g_pos_flex_06 per_positions.attribute6%TYPE;
1088: g_pos_flex_07 per_positions.attribute7%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;

Line 1275: g_CWB_Person_POSITION per_positions.name%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;
1274: g_CWB_Person_PERF_RATING_DATE ben_cwb_person_info.PERFORMANCE_RATING%type ;
1275: g_CWB_Person_POSITION per_positions.name%type ;
1276: g_CWB_Person_STATUS_TYPE varchar2(250) ;
1277: g_CWB_Person_SUP_BRIEF_NAME ben_cwb_person_info.SUPERVISOR_BRIEF_NAME%type ;
1278: g_CWB_Person_SUP_CUSTOM_NAME ben_cwb_person_info.SUPERVISOR_CUSTOM_NAME%type ;
1279: g_CWB_Person_SUP_FULL_NAME ben_cwb_person_info.SUPERVISOR_FULL_NAME%type ;

Line 1288: g_CWB_new_Postion_name per_positions.name%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 ;
1290: --- CWB person Groups
1291: g_CWB_Budget_PL_ID ben_cwb_person_groups.GROUP_PL_ID%type ;
1292: g_CWB_Budget_Access ben_cwb_person_groups.ACCESS_CD%type ;