APPS.PER_ABS_BUS dependencies on PER_ABSENCE_ATTENDANCES

Line 80: from per_absence_attendances abs,

76: to_date('01/01/'||
77: to_char(abs.date_end,'YYYY'),'DD/MM/YYYY'),
78: abt.hours_or_days,
79: abt.increasing_or_decreasing_flag
80: from per_absence_attendances abs,
81: per_absence_attendance_types abt
82: where abs.person_id = p_person_id
83: and abs.absence_attendance_type_id = abt.absence_attendance_type_id
84: and abs.date_end is not null

Line 2279: from per_absence_attendances abs

2275: -- Added for Bug11902652
2276: cursor c_abs_overlap_another is
2277: select nvl(abs.time_start,'00:00') start_time,
2278: nvl(abs.time_end,'23:59') end_time
2279: from per_absence_attendances abs
2280: where abs.person_id = p_person_id
2281: and (p_absence_attendance_id is null or
2282: p_absence_attendance_id <> abs.absence_attendance_id)
2283: and abs.date_start is not null

Line 2293: from per_absence_attendances abs,

2289: -- Added for Bug11902652
2290:
2291: cursor c_abs_day_after_another is
2292: select null
2293: from per_absence_attendances abs,
2294: per_absence_attendance_types abt
2295: where abs.person_id = p_person_id
2296: and abs.absence_attendance_type_id = abt.absence_attendance_type_id
2297: and (p_absence_attendance_id is null or

Line 3208: , per_absence_attendances abs

3204: --
3205: cursor csr_sec_grp is
3206: select pbg.security_group_id
3207: from per_business_groups pbg
3208: , per_absence_attendances abs
3209: where abs.absence_attendance_id = p_absence_attendance_id
3210: and pbg.business_group_id = abs.business_group_id;
3211: --
3212: -- Declare local variables

Line 3268: , per_absence_attendances abs

3264: --
3265: cursor csr_leg_code is
3266: select pbg.legislation_code
3267: from per_business_groups pbg
3268: , per_absence_attendances abs
3269: where abs.absence_attendance_id = p_absence_attendance_id
3270: and pbg.business_group_id = abs.business_group_id;
3271: --
3272: -- Declare local variables

Line 3595: ,p_descflex_name => 'PER_ABSENCE_ATTENDANCES'

3591: -- b) During insert.
3592: --
3593: hr_dflex_utility.ins_or_upd_descflex_attribs
3594: (p_appl_short_name => 'PER'
3595: ,p_descflex_name => 'PER_ABSENCE_ATTENDANCES'
3596: ,p_attribute_category => p_rec.attribute_category
3597: ,p_attribute1_name => 'ATTRIBUTE1'
3598: ,p_attribute1_value => p_rec.attribute1
3599: ,p_attribute2_name => 'ATTRIBUTE2'