DBA Data[Home] [Help]

APPS.PAYPLNK dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 3004: from per_absence_attendance_types paat

3000: l_passed_start_date in date,
3001: l_passed_end_date in date) is
3002: select paat.absence_attendance_type_id
3003: , paat.hours_or_days
3004: from per_absence_attendance_types paat
3005: where paat.input_value_id = l_passed_inp_val
3006: and paat.business_group_id +0 = l_business_group_id
3007: and date_effective <= l_passed_start_date
3008: and (nvl(date_end,hr_general.end_of_time) >= l_passed_end_date

Line 3716: -- from per_absence_attendance_types paat

3712: -- select paat.absence_attendance_type_id
3713: -- , paat.hours_or_days
3714: -- into l_absence_attendance_type_id
3715: -- , l_hours_or_days
3716: -- from per_absence_attendance_types paat
3717: -- where paat.input_value_id = l_passed_inp_tbl(l)
3718: -- and paat.business_group_id +0 = p_business_group_id;
3719: -- exception
3720: -- when no_data_found then null;