[Home] [Help]
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
470: select level_number, qual_framework_id --saqa_id
3003: -- Get the Competences Linked to a Course
3004: cursor csr_get_course_compts(p_course_id number) is
3005: select pce.competence_id ,pc.name
3006: from per_competence_elements pce
3007: , per_competences pc
3008: where pce.type = 'DELIVERY'
3009: and pce.activity_version_id = p_course_id
3010: and pce.business_group_id = g_bg_id
3011: and pce.competence_id = pc.competence_id;
3013: -- Get the Competences Linked to a Learning Path
3014: cursor csr_get_lp_compts(p_lp_id number) is
3015: select pce.competence_id,pc.name
3016: from per_competence_elements pce
3017: , per_competences pc
3018: where pce.type = 'OTA_LEARNING_PATH'
3019: and pce.object_id = p_lp_id
3020: and pce.business_group_id = g_bg_id
3021: and pce.competence_id = pc.competence_id;
3023: -- Get the Competences Linked to a Certification
3024: cursor csr_get_cert_compts(p_cert_id number) is
3025: select pce.competence_id,pc.name
3026: from per_competence_elements pce
3027: , per_competences pc
3028: where pce.type = 'OTA_CERTIFICATION'
3029: and pce.object_id = p_cert_id
3030: and pce.business_group_id = g_bg_id
3031: and pce.competence_id = pc.competence_id;
3585:
3586: -- Competencies
3587: cursor csr_atr_competency(p_person_id number) is
3588: select pc.competence_id, pc.name , pce.achieved_date , pce.status
3589: from per_competences pc
3590: , per_competence_elements pce
3591: where pce.person_id = p_person_id
3592: and pce.competence_id = pc.competence_id
3593: and pce.effective_date_from between g_atr_start_date and g_atr_end_date