APPS.HR_QUA_AWARDS_UTIL_SS dependencies on PER_ESTABLISHMENTS

Line 222: from per_establishments

218: l_subject_count number;
219:
220: cursor csr_establishment(p_establishment_id in number) is
221: select name
222: from per_establishments
223: where establishment_id = p_establishment_id;
224:
225: l_changed boolean;
226:

Line 416: from per_establishments

412: where subjects_taken_id = p_subject_taken_id;
413:
414: cursor csr_establishment(p_establishment_id in number) is
415: select name
416: from per_establishments
417: where establishment_id = p_establishment_id;
418:
419: l_subject_count number;
420:

Line 2541: from per_establishments

2537: and nvl(pq.title,-1) = nvl(p_title,-1);
2538:
2539: cursor csr_get_establishment_id(p_establishment in varchar2) is
2540: select establishment_id
2541: from per_establishments
2542: where upper(name) = upper(p_establishment);
2543:
2544: cursor csr_ok_to_del_attendance(p_attendance_id in number) is
2545: select count(*)