DBA Data[Home] [Help]

APPS.PER_ACCRUAL_CALC_FUNCTIONS dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 374: per_absence_attendance_types abt,

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
378: and abt.input_value_id = ncr.input_value_id

Line 411: per_absence_attendance_types abt

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
415: from per_all_assignments_f asg