APPS.PER_ACCRUAL_CALC_FUNCTIONS dependencies on PER_ABSENCE_ATTENDANCES

Line 373: from per_absence_attendances abs,

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

Line 397: from per_absence_attendances abs,

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

Line 410: from per_absence_attendances abs,

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