APPS.PER_ZA_WSP_ARCHIVE_PKG dependencies on PER_COMPETENCES

Line 465: from per_competences

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

Line 3001: , per_competences pc

2997: -- Get the Competences Linked to a Course
2998: cursor csr_get_course_compts(p_course_id number) is
2999: select pce.competence_id ,pc.name
3000: from per_competence_elements pce
3001: , per_competences pc
3002: where pce.type = 'DELIVERY'
3003: and pce.activity_version_id = p_course_id
3004: and pce.business_group_id = g_bg_id
3005: and pce.competence_id = pc.competence_id;

Line 3011: , per_competences pc

3007: -- Get the Competences Linked to a Learning Path
3008: cursor csr_get_lp_compts(p_lp_id number) is
3009: select pce.competence_id,pc.name
3010: from per_competence_elements pce
3011: , per_competences pc
3012: where pce.type = 'OTA_LEARNING_PATH'
3013: and pce.object_id = p_lp_id
3014: and pce.business_group_id = g_bg_id
3015: and pce.competence_id = pc.competence_id;

Line 3021: , per_competences pc

3017: -- Get the Competences Linked to a Certification
3018: cursor csr_get_cert_compts(p_cert_id number) is
3019: select pce.competence_id,pc.name
3020: from per_competence_elements pce
3021: , per_competences pc
3022: where pce.type = 'OTA_CERTIFICATION'
3023: and pce.object_id = p_cert_id
3024: and pce.business_group_id = g_bg_id
3025: and pce.competence_id = pc.competence_id;

Line 3583: from per_competences pc

3579:
3580: -- Competencies
3581: cursor csr_atr_competency(p_person_id number) is
3582: select pc.competence_id, pc.name , pce.achieved_date , pce.status
3583: from per_competences pc
3584: , per_competence_elements pce
3585: where pce.person_id = p_person_id
3586: and pce.competence_id = pc.competence_id
3587: and pce.effective_date_from between g_atr_start_date and g_atr_end_date