DBA Data[Home] [Help]

APPS.PAY_MIX_ROLLBACK_PKG dependencies on PER_ABSENCE_ATTENDANCES

Line 131: from per_absence_attendances paa,

127: and l_ele_class_chk is null
128: union all
129: select pee.element_entry_id, pee.creator_type,
130: pee.creator_id, pee.effective_start_date
131: from per_absence_attendances paa,
132: pay_element_entries_f pee,
133: pay_element_links_f pel,
134: pay_element_types_f pet
135: where paa.batch_id = p_batch_header_id

Line 183: from per_absence_attendances paa,

179: and l_batch_line.element_type_id is null
180: union all
181: select pee.element_entry_id, pee.creator_type,
182: pee.creator_id, pee.effective_start_date
183: from per_absence_attendances paa,
184: pay_element_entries_f pee
185: where paa.batch_id = p_batch_header_id
186: and pee.creator_id = paa.absence_attendance_id
187: and pee.creator_type = 'A'

Line 420: delete from per_absence_attendances

416:
417: -- in the case of an absence remove the absence record
418: if (l_creator_type = 'A') then
419:
420: delete from per_absence_attendances
421: where absence_attendance_id = l_creator_id;
422:
423: end if;
424: