DBA Data[Home] [Help]

APPS.BEN_EXT_PERSON dependencies on HR_LOOKUPS

Line 317: g_abs_reason_cd hr_lookups.lookup_code%TYPE;

313: g_abs_category per_absence_attendance_types.absence_category%TYPE;
314: g_abs_type per_absence_attendances.absence_attendance_type_id%TYPE;
315:
316: -- 2841958
317: g_abs_reason_cd hr_lookups.lookup_code%TYPE;
318:
319: g_abs_reason_name hr_lookups.meaning%TYPE;
320: g_abs_category_name hr_lookups.meaning%TYPE;
321: g_abs_type_name per_absence_attendance_types.name%TYPE;

Line 319: g_abs_reason_name hr_lookups.meaning%TYPE;

315:
316: -- 2841958
317: g_abs_reason_cd hr_lookups.lookup_code%TYPE;
318:
319: g_abs_reason_name hr_lookups.meaning%TYPE;
320: g_abs_category_name hr_lookups.meaning%TYPE;
321: g_abs_type_name per_absence_attendance_types.name%TYPE;
322: g_abs_start_dt per_absence_attendances.date_start%TYPE;
323: g_abs_end_dt per_absence_attendances.date_end%TYPE;

Line 320: g_abs_category_name hr_lookups.meaning%TYPE;

316: -- 2841958
317: g_abs_reason_cd hr_lookups.lookup_code%TYPE;
318:
319: g_abs_reason_name hr_lookups.meaning%TYPE;
320: g_abs_category_name hr_lookups.meaning%TYPE;
321: g_abs_type_name per_absence_attendance_types.name%TYPE;
322: g_abs_start_dt per_absence_attendances.date_start%TYPE;
323: g_abs_end_dt per_absence_attendances.date_end%TYPE;
324: g_abs_duration per_absence_attendances.absence_days%TYPE;

Line 1171: g_CWB_Persom_PERF_RATING_TYPE hr_lookups.meaning%type;

1167: g_CWB_PEOPLE_GROUP_SEGMENT6 ben_cwb_person_info.PEOPLE_GROUP_SEGMENT1%type;
1168: g_CWB_PEOPLE_GROUP_SEGMENT7 ben_cwb_person_info.PEOPLE_GROUP_SEGMENT1%type;
1169: g_CWB_PEOPLE_GROUP_SEGMENT8 ben_cwb_person_info.PEOPLE_GROUP_SEGMENT1%type;
1170: g_CWB_PEOPLE_GROUP_SEGMENT9 ben_cwb_person_info.PEOPLE_GROUP_SEGMENT1%type;
1171: g_CWB_Persom_PERF_RATING_TYPE hr_lookups.meaning%type;
1172: g_CWB_Person_PERF_RATING ben_cwb_person_info.PERFORMANCE_RATING%type ;
1173: g_CWB_Person_BASE_SALARY_FREQ ben_cwb_person_info.BASE_SALARY_FREQUENCY%type;
1174: g_CWB_Person_EMPloyee_CATEGORY hr_lookups.meaning%type;
1175: g_CWB_Person_POST_PROCESS_Stat ben_cwb_person_info.POST_PROCESS_Stat_cd%type ;

Line 1174: g_CWB_Person_EMPloyee_CATEGORY hr_lookups.meaning%type;

1170: g_CWB_PEOPLE_GROUP_SEGMENT9 ben_cwb_person_info.PEOPLE_GROUP_SEGMENT1%type;
1171: g_CWB_Persom_PERF_RATING_TYPE hr_lookups.meaning%type;
1172: g_CWB_Person_PERF_RATING ben_cwb_person_info.PERFORMANCE_RATING%type ;
1173: g_CWB_Person_BASE_SALARY_FREQ ben_cwb_person_info.BASE_SALARY_FREQUENCY%type;
1174: g_CWB_Person_EMPloyee_CATEGORY hr_lookups.meaning%type;
1175: g_CWB_Person_POST_PROCESS_Stat ben_cwb_person_info.POST_PROCESS_Stat_cd%type ;
1176: g_CWB_Person_START_DATE ben_cwb_person_info.START_DATE%type ;
1177: g_CWB_Person_ADJUSTED_SVC_DATE ben_cwb_person_info.ADJUSTED_SVC_DATE%type ;
1178: g_CWB_Person_Assg_ATTRIBUTE1 ben_cwb_person_info.Ass_ATTRIBUTE1%type ;

Line 1259: g_CWB_Person_Grade_QUARTILE hr_lookups.meaning%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 ;
1263: g_CWB_Person_LEGISLATION ben_cwb_person_info.LEGISLATION_CODE%type ;

Line 1281: g_cwb_nw_chg_reason hr_lookups.meaning%type ;

1277: g_CWB_Person_YEARS_EMPLOYED ben_cwb_person_info.YEARS_EMPLOYED%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 ;

Line 1286: g_CWB_new_Perf_rating 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
1288: g_CWB_Budget_PL_ID ben_cwb_person_groups.GROUP_PL_ID%type ;
1289: g_CWB_Budget_Access ben_cwb_person_groups.ACCESS_CD%type ;
1290: g_CWB_Budget_Approval ben_cwb_person_groups.APPROVAL_CD%type ;