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 881: from ota_learning_paths olp

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

Line 2962: from ota_learning_paths olp

2958: --
2959: -- Learning Paths
2960: cursor csr_wsp_lp(p_person_id number) is
2961: select olp.learning_path_id, olp_tl.name
2962: from ota_learning_paths olp
2963: ,ota_learning_paths_tl olp_tl
2964: ,ota_lp_enrollments ole
2965: where ole.person_id = p_person_id
2966: and ole.learning_path_id = olp.learning_path_id

Line 2963: ,ota_learning_paths_tl olp_tl

2959: -- Learning Paths
2960: cursor csr_wsp_lp(p_person_id number) is
2961: select olp.learning_path_id, olp_tl.name
2962: from ota_learning_paths olp
2963: ,ota_learning_paths_tl olp_tl
2964: ,ota_lp_enrollments ole
2965: where ole.person_id = p_person_id
2966: and ole.learning_path_id = olp.learning_path_id
2967: and ole.path_status_code <> 'CANCELLED'

Line 3036: from ota_learning_paths olp

3032: --
3033: -- Get the Courses Linked to a Learning Path
3034: cursor csr_get_lp_courses(p_learning_path_id number) is
3035: select olpm.activity_version_id
3036: from ota_learning_paths olp
3037: , ota_lp_sections olps
3038: , ota_learning_path_members olpm
3039: where olp.learning_path_id = p_learning_path_id
3040: and olp.learning_path_id = olps.learning_path_id

Line 3070: from ota_learning_paths olp

3066: and pce.business_group_id = g_bg_id;
3067: --
3068: cursor csr_exists_lp_courses(p_learning_path_id number) is
3069: select count(olpm.activity_version_id)
3070: from ota_learning_paths olp
3071: , ota_lp_sections olps
3072: , ota_learning_path_members olpm
3073: where olp.learning_path_id = p_learning_path_id
3074: and olp.learning_path_id = olps.learning_path_id

Line 3600: from ota_learning_paths olp

3596: --
3597: -- Learning Paths
3598: cursor csr_atr_lp(p_person_id number) is
3599: select olp.learning_path_id, olp_tl.name, ole.completion_date, ole.path_status_code
3600: from ota_learning_paths olp
3601: ,ota_learning_paths_tl olp_tl
3602: ,ota_lp_enrollments ole
3603: where ole.person_id = p_person_id
3604: and ole.learning_path_id = olp.learning_path_id

Line 3601: ,ota_learning_paths_tl olp_tl

3597: -- Learning Paths
3598: cursor csr_atr_lp(p_person_id number) is
3599: select olp.learning_path_id, olp_tl.name, ole.completion_date, ole.path_status_code
3600: from ota_learning_paths olp
3601: ,ota_learning_paths_tl olp_tl
3602: ,ota_lp_enrollments ole
3603: where ole.person_id = p_person_id
3604: and ole.learning_path_id = olp.learning_path_id
3605: and ole.path_status_code = 'COMPLETED'