DBA Data[Home] [Help]

APPS.BEN_EXT_PERSON dependencies on PER_ABSENCE_ATTENDANCES

Line 312: g_abs_reason per_absence_attendances.abs_attendance_reason_id%TYPE;

308: g_asg_supervisor_id per_all_assignments_f.supervisor_id%TYPE;
309: g_asg_type per_all_assignments_f.ASSIGNMENT_TYPE%TYPE;
310: g_base_salary number ;
311: --
312: g_abs_reason per_absence_attendances.abs_attendance_reason_id%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

Line 314: g_abs_type per_absence_attendances.absence_attendance_type_id%TYPE;

310: g_base_salary number ;
311: --
312: g_abs_reason per_absence_attendances.abs_attendance_reason_id%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:

Line 322: g_abs_start_dt per_absence_attendances.date_start%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;
325: g_abs_flex_01 per_absence_attendances.attribute1%TYPE;
326: g_abs_flex_02 per_absence_attendances.attribute2%TYPE;

Line 323: g_abs_end_dt per_absence_attendances.date_end%TYPE;

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;
325: g_abs_flex_01 per_absence_attendances.attribute1%TYPE;
326: g_abs_flex_02 per_absence_attendances.attribute2%TYPE;
327: g_abs_flex_03 per_absence_attendances.attribute3%TYPE;

Line 324: g_abs_duration per_absence_attendances.absence_days%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;
325: g_abs_flex_01 per_absence_attendances.attribute1%TYPE;
326: g_abs_flex_02 per_absence_attendances.attribute2%TYPE;
327: g_abs_flex_03 per_absence_attendances.attribute3%TYPE;
328: g_abs_flex_04 per_absence_attendances.attribute4%TYPE;

Line 325: g_abs_flex_01 per_absence_attendances.attribute1%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;
325: g_abs_flex_01 per_absence_attendances.attribute1%TYPE;
326: g_abs_flex_02 per_absence_attendances.attribute2%TYPE;
327: g_abs_flex_03 per_absence_attendances.attribute3%TYPE;
328: g_abs_flex_04 per_absence_attendances.attribute4%TYPE;
329: g_abs_flex_05 per_absence_attendances.attribute5%TYPE;

Line 326: g_abs_flex_02 per_absence_attendances.attribute2%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;
325: g_abs_flex_01 per_absence_attendances.attribute1%TYPE;
326: g_abs_flex_02 per_absence_attendances.attribute2%TYPE;
327: g_abs_flex_03 per_absence_attendances.attribute3%TYPE;
328: g_abs_flex_04 per_absence_attendances.attribute4%TYPE;
329: g_abs_flex_05 per_absence_attendances.attribute5%TYPE;
330: g_abs_flex_06 per_absence_attendances.attribute6%TYPE;

Line 327: g_abs_flex_03 per_absence_attendances.attribute3%TYPE;

323: g_abs_end_dt per_absence_attendances.date_end%TYPE;
324: g_abs_duration per_absence_attendances.absence_days%TYPE;
325: g_abs_flex_01 per_absence_attendances.attribute1%TYPE;
326: g_abs_flex_02 per_absence_attendances.attribute2%TYPE;
327: g_abs_flex_03 per_absence_attendances.attribute3%TYPE;
328: g_abs_flex_04 per_absence_attendances.attribute4%TYPE;
329: g_abs_flex_05 per_absence_attendances.attribute5%TYPE;
330: g_abs_flex_06 per_absence_attendances.attribute6%TYPE;
331: g_abs_flex_07 per_absence_attendances.attribute7%TYPE;

Line 328: g_abs_flex_04 per_absence_attendances.attribute4%TYPE;

324: g_abs_duration per_absence_attendances.absence_days%TYPE;
325: g_abs_flex_01 per_absence_attendances.attribute1%TYPE;
326: g_abs_flex_02 per_absence_attendances.attribute2%TYPE;
327: g_abs_flex_03 per_absence_attendances.attribute3%TYPE;
328: g_abs_flex_04 per_absence_attendances.attribute4%TYPE;
329: g_abs_flex_05 per_absence_attendances.attribute5%TYPE;
330: g_abs_flex_06 per_absence_attendances.attribute6%TYPE;
331: g_abs_flex_07 per_absence_attendances.attribute7%TYPE;
332: g_abs_flex_08 per_absence_attendances.attribute8%TYPE;

Line 329: g_abs_flex_05 per_absence_attendances.attribute5%TYPE;

325: g_abs_flex_01 per_absence_attendances.attribute1%TYPE;
326: g_abs_flex_02 per_absence_attendances.attribute2%TYPE;
327: g_abs_flex_03 per_absence_attendances.attribute3%TYPE;
328: g_abs_flex_04 per_absence_attendances.attribute4%TYPE;
329: g_abs_flex_05 per_absence_attendances.attribute5%TYPE;
330: g_abs_flex_06 per_absence_attendances.attribute6%TYPE;
331: g_abs_flex_07 per_absence_attendances.attribute7%TYPE;
332: g_abs_flex_08 per_absence_attendances.attribute8%TYPE;
333: g_abs_flex_09 per_absence_attendances.attribute9%TYPE;

Line 330: g_abs_flex_06 per_absence_attendances.attribute6%TYPE;

326: g_abs_flex_02 per_absence_attendances.attribute2%TYPE;
327: g_abs_flex_03 per_absence_attendances.attribute3%TYPE;
328: g_abs_flex_04 per_absence_attendances.attribute4%TYPE;
329: g_abs_flex_05 per_absence_attendances.attribute5%TYPE;
330: g_abs_flex_06 per_absence_attendances.attribute6%TYPE;
331: g_abs_flex_07 per_absence_attendances.attribute7%TYPE;
332: g_abs_flex_08 per_absence_attendances.attribute8%TYPE;
333: g_abs_flex_09 per_absence_attendances.attribute9%TYPE;
334: g_abs_flex_10 per_absence_attendances.attribute10%TYPE;

Line 331: g_abs_flex_07 per_absence_attendances.attribute7%TYPE;

327: g_abs_flex_03 per_absence_attendances.attribute3%TYPE;
328: g_abs_flex_04 per_absence_attendances.attribute4%TYPE;
329: g_abs_flex_05 per_absence_attendances.attribute5%TYPE;
330: g_abs_flex_06 per_absence_attendances.attribute6%TYPE;
331: g_abs_flex_07 per_absence_attendances.attribute7%TYPE;
332: g_abs_flex_08 per_absence_attendances.attribute8%TYPE;
333: g_abs_flex_09 per_absence_attendances.attribute9%TYPE;
334: g_abs_flex_10 per_absence_attendances.attribute10%TYPE;
335: g_abs_last_update_date per_absence_attendances.last_update_date%TYPE;

Line 332: g_abs_flex_08 per_absence_attendances.attribute8%TYPE;

328: g_abs_flex_04 per_absence_attendances.attribute4%TYPE;
329: g_abs_flex_05 per_absence_attendances.attribute5%TYPE;
330: g_abs_flex_06 per_absence_attendances.attribute6%TYPE;
331: g_abs_flex_07 per_absence_attendances.attribute7%TYPE;
332: g_abs_flex_08 per_absence_attendances.attribute8%TYPE;
333: g_abs_flex_09 per_absence_attendances.attribute9%TYPE;
334: g_abs_flex_10 per_absence_attendances.attribute10%TYPE;
335: g_abs_last_update_date per_absence_attendances.last_update_date%TYPE;
336: g_abs_last_updated_by per_absence_attendances.last_updated_by%TYPE;

Line 333: g_abs_flex_09 per_absence_attendances.attribute9%TYPE;

329: g_abs_flex_05 per_absence_attendances.attribute5%TYPE;
330: g_abs_flex_06 per_absence_attendances.attribute6%TYPE;
331: g_abs_flex_07 per_absence_attendances.attribute7%TYPE;
332: g_abs_flex_08 per_absence_attendances.attribute8%TYPE;
333: g_abs_flex_09 per_absence_attendances.attribute9%TYPE;
334: g_abs_flex_10 per_absence_attendances.attribute10%TYPE;
335: g_abs_last_update_date per_absence_attendances.last_update_date%TYPE;
336: g_abs_last_updated_by per_absence_attendances.last_updated_by%TYPE;
337: g_abs_last_update_login per_absence_attendances.last_update_login%TYPE;

Line 334: g_abs_flex_10 per_absence_attendances.attribute10%TYPE;

330: g_abs_flex_06 per_absence_attendances.attribute6%TYPE;
331: g_abs_flex_07 per_absence_attendances.attribute7%TYPE;
332: g_abs_flex_08 per_absence_attendances.attribute8%TYPE;
333: g_abs_flex_09 per_absence_attendances.attribute9%TYPE;
334: g_abs_flex_10 per_absence_attendances.attribute10%TYPE;
335: g_abs_last_update_date per_absence_attendances.last_update_date%TYPE;
336: g_abs_last_updated_by per_absence_attendances.last_updated_by%TYPE;
337: g_abs_last_update_login per_absence_attendances.last_update_login%TYPE;
338: g_abs_created_by per_absence_attendances.created_by%TYPE;

Line 335: g_abs_last_update_date per_absence_attendances.last_update_date%TYPE;

331: g_abs_flex_07 per_absence_attendances.attribute7%TYPE;
332: g_abs_flex_08 per_absence_attendances.attribute8%TYPE;
333: g_abs_flex_09 per_absence_attendances.attribute9%TYPE;
334: g_abs_flex_10 per_absence_attendances.attribute10%TYPE;
335: g_abs_last_update_date per_absence_attendances.last_update_date%TYPE;
336: g_abs_last_updated_by per_absence_attendances.last_updated_by%TYPE;
337: g_abs_last_update_login per_absence_attendances.last_update_login%TYPE;
338: g_abs_created_by per_absence_attendances.created_by%TYPE;
339: g_abs_creation_date per_absence_attendances.creation_date%TYPE;

Line 336: g_abs_last_updated_by per_absence_attendances.last_updated_by%TYPE;

332: g_abs_flex_08 per_absence_attendances.attribute8%TYPE;
333: g_abs_flex_09 per_absence_attendances.attribute9%TYPE;
334: g_abs_flex_10 per_absence_attendances.attribute10%TYPE;
335: g_abs_last_update_date per_absence_attendances.last_update_date%TYPE;
336: g_abs_last_updated_by per_absence_attendances.last_updated_by%TYPE;
337: g_abs_last_update_login per_absence_attendances.last_update_login%TYPE;
338: g_abs_created_by per_absence_attendances.created_by%TYPE;
339: g_abs_creation_date per_absence_attendances.creation_date%TYPE;
340: --

Line 337: g_abs_last_update_login per_absence_attendances.last_update_login%TYPE;

333: g_abs_flex_09 per_absence_attendances.attribute9%TYPE;
334: g_abs_flex_10 per_absence_attendances.attribute10%TYPE;
335: g_abs_last_update_date per_absence_attendances.last_update_date%TYPE;
336: g_abs_last_updated_by per_absence_attendances.last_updated_by%TYPE;
337: g_abs_last_update_login per_absence_attendances.last_update_login%TYPE;
338: g_abs_created_by per_absence_attendances.created_by%TYPE;
339: g_abs_creation_date per_absence_attendances.creation_date%TYPE;
340: --
341: g_flex_credit_provided ben_bnft_prvdd_ldgr_f.prvdd_val%TYPE;

Line 338: g_abs_created_by per_absence_attendances.created_by%TYPE;

334: g_abs_flex_10 per_absence_attendances.attribute10%TYPE;
335: g_abs_last_update_date per_absence_attendances.last_update_date%TYPE;
336: g_abs_last_updated_by per_absence_attendances.last_updated_by%TYPE;
337: g_abs_last_update_login per_absence_attendances.last_update_login%TYPE;
338: g_abs_created_by per_absence_attendances.created_by%TYPE;
339: g_abs_creation_date per_absence_attendances.creation_date%TYPE;
340: --
341: g_flex_credit_provided ben_bnft_prvdd_ldgr_f.prvdd_val%TYPE;
342: g_flex_credit_forfited ben_bnft_prvdd_ldgr_f.frftd_val%TYPE;

Line 339: g_abs_creation_date per_absence_attendances.creation_date%TYPE;

335: g_abs_last_update_date per_absence_attendances.last_update_date%TYPE;
336: g_abs_last_updated_by per_absence_attendances.last_updated_by%TYPE;
337: g_abs_last_update_login per_absence_attendances.last_update_login%TYPE;
338: g_abs_created_by per_absence_attendances.created_by%TYPE;
339: g_abs_creation_date per_absence_attendances.creation_date%TYPE;
340: --
341: g_flex_credit_provided ben_bnft_prvdd_ldgr_f.prvdd_val%TYPE;
342: g_flex_credit_forfited ben_bnft_prvdd_ldgr_f.frftd_val%TYPE;
343: g_flex_credit_used ben_bnft_prvdd_ldgr_f.used_val%TYPE;