DBA Data[Home] [Help]

APPS.PAY_ES_SS_CALCULATION dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 108: ,per_absence_attendance_types paat

104: SELECT GREATEST (paa.DATE_START,c_period_start_date) start_date
105: ,LEAST(c_period_end_date,nvl(paa.date_end,to_date('31/12/4712','dd/mm/yyyy'))) end_date
106: ,paa.abs_information3 ptm_perc
107: FROM per_absence_attendances paa
108: ,per_absence_attendance_types paat
109: ,per_all_people_f pap
110: ,per_all_assignments_f paaf
111: WHERE paaf.assignment_id = c_assignment_id
112: AND paaf.business_group_id = c_business_group_id

Line 204: ,per_absence_attendance_types paat

200: ,LEAST(c_period_end_date,nvl(paa.date_end,to_date('31/12/4712','dd/mm/yyyy'))) end_date
201: ,time_start
202: ,time_end
203: FROM per_absence_attendances paa
204: ,per_absence_attendance_types paat
205: ,per_all_people_f pap
206: ,per_all_assignments_f paaf
207: WHERE paaf.assignment_id = c_assignment_id
208: AND paaf.business_group_id = c_business_group_id