DBA Data[Home] [Help]

APPS.PER_GB_ABSENCE_EVIDENCE_SWI dependencies on PER_ABSENCE_ATTENDANCES

Line 334: l_absence_attendance_type_id per_absence_attendances.absence_attendance_type_id%type;

330: --
331: -- Variables for IN/OUT parameters
332: l_object_version_number number;
333:
334: l_absence_attendance_type_id per_absence_attendances.absence_attendance_type_id%type;
335: l_business_group_id per_absence_attendances.business_group_id%type;
336:
337: Cursor c_is_gb_leg is
338: select absence_attendance_type_id, business_group_id

Line 335: l_business_group_id per_absence_attendances.business_group_id%type;

331: -- Variables for IN/OUT parameters
332: l_object_version_number number;
333:
334: l_absence_attendance_type_id per_absence_attendances.absence_attendance_type_id%type;
335: l_business_group_id per_absence_attendances.business_group_id%type;
336:
337: Cursor c_is_gb_leg is
338: select absence_attendance_type_id, business_group_id
339: from per_absence_attendances

Line 339: from per_absence_attendances

335: l_business_group_id per_absence_attendances.business_group_id%type;
336:
337: Cursor c_is_gb_leg is
338: select absence_attendance_type_id, business_group_id
339: from per_absence_attendances
340: where absence_attendance_id = p_absence_attendance_id;
341:
342: --
343: -- Other variables

Line 670: from per_absence_attendances

666: lv_action varchar2(30);
667:
668: Cursor c_get_dur(p_absence_attendance_id number) is
669: select absence_days, absence_hours
670: from per_absence_attendances
671: where absence_attendance_id = p_absence_attendance_id;
672:
673:
674: BEGIN