DBA Data[Home] [Help]

APPS.PAYPLNK dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 3012: from per_absence_attendance_types paat

3008: l_passed_start_date in date,
3009: l_passed_end_date in date) is
3010: select paat.absence_attendance_type_id
3011: , paat.hours_or_days
3012: from per_absence_attendance_types paat
3013: where paat.input_value_id = l_passed_inp_val
3014: and paat.business_group_id +0 = l_business_group_id
3015: and date_effective <= l_passed_start_date
3016: and (nvl(date_end,hr_general.end_of_time) >= l_passed_end_date

Line 3734: -- from per_absence_attendance_types paat

3730: -- select paat.absence_attendance_type_id
3731: -- , paat.hours_or_days
3732: -- into l_absence_attendance_type_id
3733: -- , l_hours_or_days
3734: -- from per_absence_attendance_types paat
3735: -- where paat.input_value_id = l_passed_inp_tbl(l)
3736: -- and paat.business_group_id +0 = p_business_group_id;
3737: -- exception
3738: -- when no_data_found then null;