APPS.HR_QUA_AWARDS_UTIL_SS dependencies on PER_ESTABLISHMENTS

Line 218: from per_establishments

214: where subjects_taken_id = p_subject_taken_id;
215:
216: cursor csr_establishment(p_establishment_id in number) is
217: select name
218: from per_establishments
219: where establishment_id = p_establishment_id;
220:
221: l_subject_count number;
222:

Line 2337: from per_establishments

2333: and nvl(pq.title,-1) = nvl(p_title,-1);
2334:
2335: cursor csr_get_establishment_id(p_establishment in varchar2) is
2336: select establishment_id
2337: from per_establishments
2338: where upper(name) = upper(p_establishment);
2339:
2340: cursor csr_ok_to_del_attendance(p_attendance_id in number) is
2341: select count(*)