DBA Data[Home] [Help]

APPS.PER_ES_COMP_CERT_ARCHIVE_PKG dependencies on PER_ABSENCE_ATTENDANCES

Line 212: ,per_absence_attendances paa

208: FROM per_all_assignments_f asl
209: ,hr_soft_coding_keyflex hr
210: ,hr_organization_information hoi
211: ,per_absence_attendance_types pat
212: ,per_absence_attendances paa
213: ,pay_payroll_actions ppa
214: where ppa.payroll_action_id = c_p_actid
215: AND asl.person_id BETWEEN stperson AND endperson
216: AND asl.primary_flag = 'Y'

Line 528: ,per_absence_attendances paat

524: ,per_periods_of_service pps
525: ,hr_soft_coding_keyflex hr
526: ,hr_organization_information hoi
527: ,per_absence_attendance_types pat
528: ,per_absence_attendances paat
529: WHERE paas.assignment_action_id = p_assactid
530: AND paas.payroll_action_id = ppa.payroll_action_id
531: AND paa.assignment_id = paas.assignment_id
532: AND pps.period_of_service_id (+)= paa.period_of_service_id