APPS.PQP_GB_SWF_ARCHIVE dependencies on PER_SUBJECTS_TAKEN

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

Line 3436: l_subject1 per_subjects_taken.subject%type;

3432: and pcv.business_group_id = g_business_group_id;
3433:
3434: l_proc constant varchar2(50) := g_package || ' fetch_qualification_details';
3435: l_qual_rec get_qual_details%rowtype;
3436: l_subject1 per_subjects_taken.subject%type;
3437: l_subject2 per_subjects_taken.subject%type;
3438: l_qual_code_src pqp_configuration_values.pcv_information1%type;
3439: l_qual_code_dcsf pqp_configuration_values.pcv_information1%type;
3440: l_qual_tab_idx number := 1;

Line 3437: l_subject2 per_subjects_taken.subject%type;

3433:
3434: l_proc constant varchar2(50) := g_package || ' fetch_qualification_details';
3435: l_qual_rec get_qual_details%rowtype;
3436: l_subject1 per_subjects_taken.subject%type;
3437: l_subject2 per_subjects_taken.subject%type;
3438: l_qual_code_src pqp_configuration_values.pcv_information1%type;
3439: l_qual_code_dcsf pqp_configuration_values.pcv_information1%type;
3440: l_qual_tab_idx number := 1;
3441: l_invalid_qual_code varchar2(1) := 'N';