eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_ZA_WSP_ARCHIVE_PKG dependencies on OTA_LEARNING_PATHS

Line 880: from ota_learning_paths olp

876:
877: -- Get the Courses Linked to a Learning Path
878: cursor csr_get_lp_courses(p_learning_path_id number) is
879: select olpm.activity_version_id
880: from ota_learning_paths olp
881: , ota_lp_sections olps
882: , ota_learning_path_members olpm
883: where olp.learning_path_id = p_learning_path_id
884: and olp.learning_path_id = olps.learning_path_id

Line 2956: from ota_learning_paths olp

2952: --
2953: -- Learning Paths
2954: cursor csr_wsp_lp(p_person_id number) is
2955: select olp.learning_path_id, olp_tl.name
2956: from ota_learning_paths olp
2957: ,ota_learning_paths_tl olp_tl
2958: ,ota_lp_enrollments ole
2959: where ole.person_id = p_person_id
2960: and ole.learning_path_id = olp.learning_path_id

Line 2957: ,ota_learning_paths_tl olp_tl

2953: -- Learning Paths
2954: cursor csr_wsp_lp(p_person_id number) is
2955: select olp.learning_path_id, olp_tl.name
2956: from ota_learning_paths olp
2957: ,ota_learning_paths_tl olp_tl
2958: ,ota_lp_enrollments ole
2959: where ole.person_id = p_person_id
2960: and ole.learning_path_id = olp.learning_path_id
2961: and ole.path_status_code <> 'CANCELLED'

Line 3030: from ota_learning_paths olp

3026: --
3027: -- Get the Courses Linked to a Learning Path
3028: cursor csr_get_lp_courses(p_learning_path_id number) is
3029: select olpm.activity_version_id
3030: from ota_learning_paths olp
3031: , ota_lp_sections olps
3032: , ota_learning_path_members olpm
3033: where olp.learning_path_id = p_learning_path_id
3034: and olp.learning_path_id = olps.learning_path_id

Line 3064: from ota_learning_paths olp

3060: and pce.business_group_id = g_bg_id;
3061: --
3062: cursor csr_exists_lp_courses(p_learning_path_id number) is
3063: select count(olpm.activity_version_id)
3064: from ota_learning_paths olp
3065: , ota_lp_sections olps
3066: , ota_learning_path_members olpm
3067: where olp.learning_path_id = p_learning_path_id
3068: and olp.learning_path_id = olps.learning_path_id

Line 3594: from ota_learning_paths olp

3590: --
3591: -- Learning Paths
3592: cursor csr_atr_lp(p_person_id number) is
3593: select olp.learning_path_id, olp_tl.name, ole.completion_date, ole.path_status_code
3594: from ota_learning_paths olp
3595: ,ota_learning_paths_tl olp_tl
3596: ,ota_lp_enrollments ole
3597: where ole.person_id = p_person_id
3598: and ole.learning_path_id = olp.learning_path_id

Line 3595: ,ota_learning_paths_tl olp_tl

3591: -- Learning Paths
3592: cursor csr_atr_lp(p_person_id number) is
3593: select olp.learning_path_id, olp_tl.name, ole.completion_date, ole.path_status_code
3594: from ota_learning_paths olp
3595: ,ota_learning_paths_tl olp_tl
3596: ,ota_lp_enrollments ole
3597: where ole.person_id = p_person_id
3598: and ole.learning_path_id = olp.learning_path_id
3599: and ole.path_status_code = 'COMPLETED'