DBA Data[Home] [Help]

APPS.PER_ACCRUAL_CALC_FUNCTIONS dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 375: per_absence_attendance_types abt,

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

Line 412: per_absence_attendance_types abt

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