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 882: , ota_lp_sections olps

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

Line 3037: , ota_lp_sections olps

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

Line 3071: , ota_lp_sections olps

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