[Home] [Help]
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
1919: where abt.absence_attendance_type_id = p_absence_attendance_type_id;
1920:
1921: cursor c_abs_overlap_another is
1922: select null
1923: from per_absence_attendances abs
1924: where abs.person_id = p_person_id
1925: and (p_absence_attendance_id is null or
1926: p_absence_attendance_id <> abs.absence_attendance_id)
1927: and abs.date_start is not null
1947: ));
1948:
1949: cursor c_abs_day_after_another is
1950: select null
1951: from per_absence_attendances abs,
1952: per_absence_attendance_types abt
1953: where abs.person_id = p_person_id
1954: and abs.absence_attendance_type_id = abt.absence_attendance_type_id
1955: and (p_absence_attendance_id is null or
2772: --
2773: cursor csr_sec_grp is
2774: select pbg.security_group_id
2775: from per_business_groups pbg
2776: , per_absence_attendances abs
2777: where abs.absence_attendance_id = p_absence_attendance_id
2778: and pbg.business_group_id = abs.business_group_id;
2779: --
2780: -- Declare local variables
2832: --
2833: cursor csr_leg_code is
2834: select pbg.legislation_code
2835: from per_business_groups pbg
2836: , per_absence_attendances abs
2837: where abs.absence_attendance_id = p_absence_attendance_id
2838: and pbg.business_group_id = abs.business_group_id;
2839: --
2840: -- Declare local variables
3159: -- b) During insert.
3160: --
3161: hr_dflex_utility.ins_or_upd_descflex_attribs
3162: (p_appl_short_name => 'PER'
3163: ,p_descflex_name => 'PER_ABSENCE_ATTENDANCES'
3164: ,p_attribute_category => p_rec.attribute_category
3165: ,p_attribute1_name => 'ATTRIBUTE1'
3166: ,p_attribute1_value => p_rec.attribute1
3167: ,p_attribute2_name => 'ATTRIBUTE2'