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_LP_SECTIONS

Line 881: , ota_lp_sections olps

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
885: and olps.learning_path_section_id = olpm.learning_path_section_id;

Line 3031: , ota_lp_sections olps

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
3035: and olps.learning_path_section_id = olpm.learning_path_section_id;

Line 3065: , ota_lp_sections olps

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
3069: and olps.learning_path_section_id = olpm.learning_path_section_id;