APPS.HR_QUA_AWARDS_UTIL_SS dependencies on PER_ESTABLISHMENT_ATTENDANCES

Line 216: from per_establishment_attendances

212: RETURN BOOLEAN IS
213:
214: cursor csr_attendance(p_attendance_id in number) is
215: select *
216: from per_establishment_attendances
217: where attendance_id = p_attendance_id;
218: l_subject_count number;
219:
220: cursor csr_establishment(p_establishment_id in number) is

Line 406: from per_establishment_attendances

402: where qualification_id=p_qualification_id;
403:
404: cursor csr_attendance(p_attendance_id in number) is
405: select *
406: from per_establishment_attendances
407: where attendance_id = p_attendance_id;
408:
409: cursor csr_subject(p_subject_taken_id in number) is
410: select *

Line 2466: per_establishment_attendances

2462: ,p_establishment_id in number)
2463: IS
2464: SELECT null
2465: FROM
2466: per_establishment_attendances
2467: WHERE
2468: attendance_id = p_attendance_id
2469: AND NVL(establishment_id,-1) = NVL(p_establishment_id,-1)
2470: AND NVL(UPPER(establishment),-1) = NVL(UPPER(p_establishment),-1);

Line 2480: per_establishment_attendances

2476: ,p_selected_person_id in number)
2477: IS
2478: SELECT attendance_id
2479: FROM
2480: per_establishment_attendances
2481: WHERE
2482: PERSON_ID = p_selected_person_id
2483: AND (/*
2484: Bug 8364149 Start Commented to allow

Line 2519: per_establishment_attendances per,

2515: ,p_selected_person_id in number) is
2516: select
2517: null
2518: from
2519: per_establishment_attendances per,
2520: per_qualifications pq
2521: where
2522: per.person_id = p_selected_person_id
2523: and (p_establishment is not null