DBA Data[Home] [Help]

APPS.PAY_AE_GENERAL dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 872: ,per_absence_attendance_types paat

868:
869: SELECT SUM(paa.absence_days) --(NVL(paa.absence_days, (paa.DATE_END - paa.DATE_START))
870: INTO l_days
871: FROM per_absence_attendances paa
872: ,per_absence_attendance_types paat
873: ,per_all_assignments_f asg
874: WHERE paat.absence_category ='UL'
875: AND paat.business_group_id = paa.business_group_id
876: AND paat.business_group_id = p_business_group_id