DBA Data[Home] [Help]

APPS.BEN_EXT_PERSON dependencies on PER_ABSENCE_ATTENDANCES

Line 315: g_abs_reason per_absence_attendances.abs_attendance_reason_id%TYPE;

311: g_asg_supervisor_id per_all_assignments_f.supervisor_id%TYPE;
312: g_asg_type per_all_assignments_f.ASSIGNMENT_TYPE%TYPE;
313: g_base_salary number ;
314: --
315: g_abs_reason per_absence_attendances.abs_attendance_reason_id%TYPE;
316: g_abs_category per_absence_attendance_types.absence_category%TYPE;
317: g_abs_type per_absence_attendances.absence_attendance_type_id%TYPE;
318:
319: -- 2841958

Line 317: g_abs_type per_absence_attendances.absence_attendance_type_id%TYPE;

313: g_base_salary number ;
314: --
315: g_abs_reason per_absence_attendances.abs_attendance_reason_id%TYPE;
316: g_abs_category per_absence_attendance_types.absence_category%TYPE;
317: g_abs_type per_absence_attendances.absence_attendance_type_id%TYPE;
318:
319: -- 2841958
320: g_abs_reason_cd hr_lookups.lookup_code%TYPE;
321:

Line 325: g_abs_start_dt per_absence_attendances.date_start%TYPE;

321:
322: g_abs_reason_name hr_lookups.meaning%TYPE;
323: g_abs_category_name hr_lookups.meaning%TYPE;
324: g_abs_type_name per_absence_attendance_types.name%TYPE;
325: g_abs_start_dt per_absence_attendances.date_start%TYPE;
326: g_abs_end_dt per_absence_attendances.date_end%TYPE;
327: g_abs_duration per_absence_attendances.absence_days%TYPE;
328: g_abs_flex_01 per_absence_attendances.attribute1%TYPE;
329: g_abs_flex_02 per_absence_attendances.attribute2%TYPE;

Line 326: g_abs_end_dt per_absence_attendances.date_end%TYPE;

322: g_abs_reason_name hr_lookups.meaning%TYPE;
323: g_abs_category_name hr_lookups.meaning%TYPE;
324: g_abs_type_name per_absence_attendance_types.name%TYPE;
325: g_abs_start_dt per_absence_attendances.date_start%TYPE;
326: g_abs_end_dt per_absence_attendances.date_end%TYPE;
327: g_abs_duration per_absence_attendances.absence_days%TYPE;
328: g_abs_flex_01 per_absence_attendances.attribute1%TYPE;
329: g_abs_flex_02 per_absence_attendances.attribute2%TYPE;
330: g_abs_flex_03 per_absence_attendances.attribute3%TYPE;

Line 327: g_abs_duration per_absence_attendances.absence_days%TYPE;

323: g_abs_category_name hr_lookups.meaning%TYPE;
324: g_abs_type_name per_absence_attendance_types.name%TYPE;
325: g_abs_start_dt per_absence_attendances.date_start%TYPE;
326: g_abs_end_dt per_absence_attendances.date_end%TYPE;
327: g_abs_duration per_absence_attendances.absence_days%TYPE;
328: g_abs_flex_01 per_absence_attendances.attribute1%TYPE;
329: g_abs_flex_02 per_absence_attendances.attribute2%TYPE;
330: g_abs_flex_03 per_absence_attendances.attribute3%TYPE;
331: g_abs_flex_04 per_absence_attendances.attribute4%TYPE;

Line 328: g_abs_flex_01 per_absence_attendances.attribute1%TYPE;

324: g_abs_type_name per_absence_attendance_types.name%TYPE;
325: g_abs_start_dt per_absence_attendances.date_start%TYPE;
326: g_abs_end_dt per_absence_attendances.date_end%TYPE;
327: g_abs_duration per_absence_attendances.absence_days%TYPE;
328: g_abs_flex_01 per_absence_attendances.attribute1%TYPE;
329: g_abs_flex_02 per_absence_attendances.attribute2%TYPE;
330: g_abs_flex_03 per_absence_attendances.attribute3%TYPE;
331: g_abs_flex_04 per_absence_attendances.attribute4%TYPE;
332: g_abs_flex_05 per_absence_attendances.attribute5%TYPE;

Line 329: g_abs_flex_02 per_absence_attendances.attribute2%TYPE;

325: g_abs_start_dt per_absence_attendances.date_start%TYPE;
326: g_abs_end_dt per_absence_attendances.date_end%TYPE;
327: g_abs_duration per_absence_attendances.absence_days%TYPE;
328: g_abs_flex_01 per_absence_attendances.attribute1%TYPE;
329: g_abs_flex_02 per_absence_attendances.attribute2%TYPE;
330: g_abs_flex_03 per_absence_attendances.attribute3%TYPE;
331: g_abs_flex_04 per_absence_attendances.attribute4%TYPE;
332: g_abs_flex_05 per_absence_attendances.attribute5%TYPE;
333: g_abs_flex_06 per_absence_attendances.attribute6%TYPE;

Line 330: g_abs_flex_03 per_absence_attendances.attribute3%TYPE;

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

Line 331: g_abs_flex_04 per_absence_attendances.attribute4%TYPE;

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

Line 332: g_abs_flex_05 per_absence_attendances.attribute5%TYPE;

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

Line 333: g_abs_flex_06 per_absence_attendances.attribute6%TYPE;

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

Line 334: g_abs_flex_07 per_absence_attendances.attribute7%TYPE;

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

Line 335: g_abs_flex_08 per_absence_attendances.attribute8%TYPE;

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

Line 336: g_abs_flex_09 per_absence_attendances.attribute9%TYPE;

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

Line 337: g_abs_flex_10 per_absence_attendances.attribute10%TYPE;

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

Line 338: g_abs_last_update_date per_absence_attendances.last_update_date%TYPE;

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

Line 339: g_abs_last_updated_by per_absence_attendances.last_updated_by%TYPE;

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

Line 340: g_abs_last_update_login per_absence_attendances.last_update_login%TYPE;

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

Line 341: g_abs_created_by per_absence_attendances.created_by%TYPE;

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

Line 342: g_abs_creation_date per_absence_attendances.creation_date%TYPE;

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