APPS.IRC_UTILITIES_PKG dependencies on PER_QUALIFICATION_TYPES

Line 194: l_qual_type PER_QUALIFICATION_TYPES.NAME%TYPE;

190: RETURN VARCHAR2
191:
192: IS
193:
194: l_qual_type PER_QUALIFICATION_TYPES.NAME%TYPE;
195: l_qual_type2 PER_QUALIFICATION_TYPES.NAME%TYPE;
196: l_max_rank number;
197:
198: CURSOR c_qual_types(p_person PER_ALL_PEOPLE_F.PERSON_ID%TYPE) IS

Line 195: l_qual_type2 PER_QUALIFICATION_TYPES.NAME%TYPE;

191:
192: IS
193:
194: l_qual_type PER_QUALIFICATION_TYPES.NAME%TYPE;
195: l_qual_type2 PER_QUALIFICATION_TYPES.NAME%TYPE;
196: l_max_rank number;
197:
198: CURSOR c_qual_types(p_person PER_ALL_PEOPLE_F.PERSON_ID%TYPE) IS
199: SELECT QTYP.NAME,qtyp.rank

Line 200: FROM PER_QUALIFICATION_TYPES QTYP,

196: l_max_rank number;
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

Line 215: FROM PER_QUALIFICATION_TYPES QTYP,

211:
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

Line 260: l_qual_type PER_QUALIFICATION_TYPES.NAME%TYPE;

256: RETURN VARCHAR2
257:
258: IS
259:
260: l_qual_type PER_QUALIFICATION_TYPES.NAME%TYPE;
261:
262: CURSOR c_qual_types IS
263: SELECT QTYP.NAME
264: FROM PER_QUALIFICATION_TYPES QTYP,

Line 264: FROM PER_QUALIFICATION_TYPES QTYP,

260: l_qual_type PER_QUALIFICATION_TYPES.NAME%TYPE;
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

Line 275: FROM PER_QUALIFICATION_TYPES QTYP,

271: order by QTYP.RANK desc, qual.awarded_date desc, qual.creation_date desc;
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

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 817: ,per_qualification_types_vl pqt

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
821: AND pqt.qualification_type_id = pq.qualification_type_id

Line 824: l_qual_title per_qualification_types_vl.name%TYPE;

820: AND pq.awarded_date IS NOT NULL
821: AND pqt.qualification_type_id = pq.qualification_type_id
822: ORDER BY pq.awarded_date DESC;
823: --
824: l_qual_title per_qualification_types_vl.name%TYPE;
825: --
826: BEGIN
827: OPEN c_qualifications;
828: FETCH c_qualifications INTO l_qual_title;