DBA Data[Home] [Help]

APPS.PAY_NO_SC_ARCHIVE dependencies on PER_ALL_ASSIGNMENTS_F

Line 178: per_all_assignments_f paaf,

174: )
175: IS
176: SELECT paaf.assignment_id
177: FROM per_all_people_f papf,
178: per_all_assignments_f paaf,
179: per_assignment_status_types past,
180: hr_soft_coding_keyflex hsc,
181: hr_organization_information hoi
182: WHERE paaf.person_id = papf.person_id

Line 295: per_all_assignments_f paaf,

291: paaf.assignment_id,
292: count(paa.abs_information1) sc_days
293: from per_absence_attendances paa,
294: per_absence_attendance_types paat,
295: per_all_assignments_f paaf,
296: per_assignment_status_types past,
297: pay_assignment_actions paas,
298: per_all_people_f papf,
299: hr_soft_coding_keyflex hsc,