APPS.PER_ACCRUAL_CALC_FUNCTIONS dependencies on PER_ABSENCE_ATTENDANCES

Line 374: from per_absence_attendances abs,

370: /* NOTE: This cursor has been tuned for the CBO. */
371:
372: cursor c_get_total_absence is
373: select nvl(sum(nvl(abs.absence_days, abs.absence_hours)), 0)
374: from per_absence_attendances abs,
375: per_absence_attendance_types abt,
376: pay_net_calculation_rules ncr
377: where abs.absence_attendance_type_id =
378: abt.absence_attendance_type_id

Line 398: from per_absence_attendances abs,

394: and ncr.accrual_plan_id = p_plan_id;
395: --
396: cursor c_get_abs_per_type is
397: select nvl(sum(nvl(abs.absence_days, abs.absence_hours)), 0)
398: from per_absence_attendances abs,
399: pay_net_calculation_rules ncr
400: where ncr.absence_attendance_type_id = p_absence_attendance_type_id
401: and ncr.absence_attendance_type_id = abs.absence_attendance_type_id
402: and exists (select 'Y'

Line 411: from per_absence_attendances abs,

407: and ncr.accrual_plan_id = p_plan_id;
408: --
409: cursor c_get_abs_per_iv is
410: select nvl(sum(nvl(abs.absence_days, abs.absence_hours)), 0)
411: from per_absence_attendances abs,
412: per_absence_attendance_types abt
413: where abs.absence_attendance_type_id = abt.absence_attendance_type_id
414: and abt.input_value_id = p_pto_input_value_id
415: and exists ( select 1