APPS.PQP_GB_SWF_ARCHIVE dependencies on PER_QUALIFICATIONS

Line 863: and exists (select 1 from per_qualifications qual -- valid only if qual data is included

859: or abs.date_start between g_cont_data_st_date and g_cont_data_end_date))
860: )
861: or (g_exclude_qual = 'No' -- Qualification present or not?
862: and g_census_day between min_max.effective_start_date and min_max.effective_end_date -- check if contract is still
863: and exists (select 1 from per_qualifications qual -- valid only if qual data is included
864: where qual.person_id = asg.person_id )
865: )
866: )
867:

Line 957: and exists (select 1 from per_qualifications qual -- valid only if qual data is included

953: )
954:
955: or (g_exclude_qual = 'No' -- Qualification present or not?
956: and g_census_day between min_max.effective_start_date and min_max.effective_end_date -- check if contract is still
957: and exists (select 1 from per_qualifications qual -- valid only if qual data is included
958: where qual.person_id = asg.person_id )
959: )
960:
961: )

Line 1120: from per_qualifications

1116: function get_teachers_number(p_person_id in number
1117: , p_effective_date in date) return varchar2 is
1118: cursor qual_mbr_num is
1119: select membership_number
1120: from per_qualifications
1121: where person_id = p_person_id
1122: and membership_number is not null;
1123: ---
1124: e_teacher_no_nt_found exception;

Line 3395: from per_qualifications qual, per_qualification_types qualtyp

3391: decode(qua_information_category, 'GB', qua_information1, null) qual_code_dff,
3392: decode(qua_information_category, 'GB', qua_information2, null) subject1_dff,
3393: decode(qua_information_category, 'GB', qua_information3, null) subject2_dff,
3394: decode(qua_information_category, 'GB', decode(qua_information4,'Y','true','false'), null) verified_dff
3395: from per_qualifications qual, per_qualification_types qualtyp
3396: where qual.person_id = p_person_id
3397: and qual.qualification_type_id = qualtyp.qualification_type_id;
3398:
3399: cursor subject_taken(p_qual_id in number) is

Line 3404: from per_qualifications qual, per_subjects_taken sub,

3400: select max(decode(seq, 1, subject_dcsf, null)) subject_1,
3401: max(decode(seq, 2, subject_dcsf, null)) subject_2
3402: from (select subject_dcsf, seq
3403: from (select pcv.pcv_information2 subject_dcsf, row_number() over(order by major desc) seq
3404: from per_qualifications qual, per_subjects_taken sub,
3405: pqp_configuration_values pcv
3406: where qual.qualification_id = sub.qualification_id
3407: and qual.person_id = p_person_id
3408: and qual.qualification_id = p_qual_id