APPS.IRC_UTILITIES_PKG dependencies on PER_QUALIFICATIONS

Line 201: PER_QUALIFICATIONS QUAL,

197:
198: CURSOR c_qual_types(p_person PER_ALL_PEOPLE_F.PERSON_ID%TYPE) IS
199: SELECT QTYP.NAME,qtyp.rank
200: FROM PER_QUALIFICATION_TYPES QTYP,
201: PER_QUALIFICATIONS QUAL,
202: PER_ALL_PEOPLE_F ppf,
203: PER_ALL_PEOPLE_F ppf2
204: WHERE ppf.person_id = p_person
205: AND ppf.party_id = ppf2.party_id

Line 216: PER_QUALIFICATIONS QUAL,

212: CURSOR c_qual_types2(p_person PER_ALL_PEOPLE_F.PERSON_ID%TYPE
213: ,p_max_rank number) IS
214: SELECT QTYP.NAME
215: FROM PER_QUALIFICATION_TYPES QTYP,
216: PER_QUALIFICATIONS QUAL,
217: PER_ESTABLISHMENT_ATTENDANCES ESTAB,
218: PER_ALL_PEOPLE_F ppf,
219: PER_ALL_PEOPLE_F ppf2
220: WHERE ppf.person_id = p_person

Line 265: PER_QUALIFICATIONS QUAL,

261:
262: CURSOR c_qual_types IS
263: SELECT QTYP.NAME
264: FROM PER_QUALIFICATION_TYPES QTYP,
265: PER_QUALIFICATIONS QUAL,
266: PER_ALL_PEOPLE_F ppf
267: WHERE ppf.party_id = p_party_id
268: AND trunc(sysdate) BETWEEN ppf.effective_start_date and ppf.effective_end_date
269: AND ppf.person_id = QUAL.PERSON_ID

Line 276: PER_QUALIFICATIONS QUAL,

272:
273: CURSOR c_qual_types2 IS
274: SELECT /*+ FIRST_ROWS */ QTYP.NAME
275: FROM PER_QUALIFICATION_TYPES QTYP,
276: PER_QUALIFICATIONS QUAL,
277: PER_ESTABLISHMENT_ATTENDANCES ESTAB,
278: PER_ALL_PEOPLE_F ppf
279: WHERE ppf.party_id = p_party_id
280: AND trunc(sysdate) BETWEEN ppf.effective_start_date and ppf.effective_end_date

Line 284: and not exists (select 1 from per_qualifications qual2,per_qualification_types qtyp2

280: AND trunc(sysdate) BETWEEN ppf.effective_start_date and ppf.effective_end_date
281: AND ppf.person_id = ESTAB.PERSON_ID
282: AND estab.attendance_id=qual.attendance_id
283: AND QUAL.QUALIFICATION_TYPE_ID = QTYP.QUALIFICATION_TYPE_ID
284: and not exists (select 1 from per_qualifications qual2,per_qualification_types qtyp2
285: where qual2.person_id=ppf.person_id
286: and qtyp2.qualification_type_id=qual2.qualification_type_id
287: and nvl(qtyp2.rank,-1)>nvl(qtyp.rank,-1))
288: order by QTYP.RANK desc, qual.awarded_date desc, qual.creation_date desc;

Line 816: FROM per_qualifications pq

812: IS
813: --
814: CURSOR c_qualifications IS
815: SELECT pqt.name
816: FROM per_qualifications pq
817: ,per_qualification_types_vl pqt
818: WHERE pq.party_id = p_party_id
819: AND pq.attendance_id IS NOT NULL
820: AND pq.awarded_date IS NOT NULL