APPS.HR_QUA_AWARDS_UTIL_SS dependencies on PER_ESTABLISHMENT_ATTENDANCES

Line 208: from per_establishment_attendances

204: where qualification_id=p_qualification_id;
205:
206: cursor csr_attendance(p_attendance_id in number) is
207: select *
208: from per_establishment_attendances
209: where attendance_id = p_attendance_id;
210:
211: cursor csr_subject(p_subject_taken_id in number) is
212: select *

Line 2268: per_establishment_attendances

2264: ,p_establishment_id in number)
2265: IS
2266: SELECT null
2267: FROM
2268: per_establishment_attendances
2269: WHERE
2270: attendance_id = p_attendance_id
2271: AND NVL(establishment_id,-1) = NVL(p_establishment_id,-1)
2272: AND NVL(UPPER(establishment),-1) = NVL(UPPER(p_establishment),-1);

Line 2282: per_establishment_attendances

2278: ,p_selected_person_id in number)
2279: IS
2280: SELECT attendance_id
2281: FROM
2282: per_establishment_attendances
2283: WHERE
2284: PERSON_ID = p_selected_person_id
2285: AND (attended_start_date is null
2286: and p_start_date is null

Line 2315: per_establishment_attendances per,

2311: ,p_selected_person_id in number) is
2312: select
2313: null
2314: from
2315: per_establishment_attendances per,
2316: per_qualifications pq
2317: where
2318: per.person_id = p_selected_person_id
2319: and (p_establishment is not null