APPS.PER_ZA_WSP_ARCHIVE_PKG dependencies on STANDARD

Line 465: select level_number, unit_standard_id --saqa_id

461: and puc.user_column_id = puci.user_column_id
462: and p_effective_date between puci.effective_start_date and puci.effective_end_date;
463:
464: cursor csr_get_comp_info(p_csr_trng_event_id number) is
465: select level_number, unit_standard_id --saqa_id
466: from per_competences
467: where competence_id = p_csr_trng_event_id;
468:
469: cursor csr_get_qual_info(p_csr_trng_event_id number) is