APPS.OTA_LP_ENROLLMENT_API dependencies on OTA_LEARNING_PATHS

Line 76: FROM ota_learning_paths lps

72: g_dummy varchar2(1);
73:
74: CURSOR get_info_for_comp IS
75: SELECT null
76: FROM ota_learning_paths lps
77: WHERE lps.learning_path_id = p_learning_path_id
78: AND lps.path_source_code = 'CATALOG';
79:
80: cursor get_lp_type is

Line 82: from ota_learning_paths

78: AND lps.path_source_code = 'CATALOG';
79:
80: cursor get_lp_type is
81: select path_source_code
82: from ota_learning_paths
83: where learning_path_id = p_learning_path_id;
84:
85: l_type ota_learning_paths.path_source_code%type;
86:

Line 85: l_type ota_learning_paths.path_source_code%type;

81: select path_source_code
82: from ota_learning_paths
83: where learning_path_id = p_learning_path_id;
84:
85: l_type ota_learning_paths.path_source_code%type;
86:
87: begin
88: hr_utility.set_location('Entering:'|| l_proc, 10);
89: --

Line 413: FROM ota_learning_paths lps,

409:
410: CURSOR get_info_for_comp IS
411: --Modified for Bug#3864084
412: SELECT lps.learning_path_id, lpe.person_id
413: FROM ota_learning_paths lps,
414: ota_lp_enrollments lpe
415: WHERE lps.learning_path_id = lpe.learning_path_id
416: AND lpe.lp_enrollment_id = p_lp_enrollment_id
417: AND lps.path_source_code = 'CATALOG';

Line 422: FROM ota_learning_paths lps,

418:
419: --- modified by dbatra for source_type='SUITABILITY'
420: Cursor is_suitability_LP is
421: SELECT lps.learning_path_id
422: FROM ota_learning_paths lps,
423: ota_lp_enrollments lpe
424: WHERE lps.learning_path_id = lpe.learning_path_id
425: AND lpe.lp_enrollment_id = p_lp_enrollment_id
426: AND lps.source_function_code = 'SUITABILITY';

Line 430: from ota_learning_paths lps, ota_lp_enrollments lpe

426: AND lps.source_function_code = 'SUITABILITY';
427:
428: cursor get_lp_type is
429: select lps.path_source_code , lpe.path_status_code
430: from ota_learning_paths lps, ota_lp_enrollments lpe
431: where lps.learning_path_id = lpe.learning_path_id
432: AND lpe.lp_enrollment_id = p_lp_enrollment_id;
433:
434: l_type ota_learning_paths.path_source_code%type;

Line 434: l_type ota_learning_paths.path_source_code%type;

430: from ota_learning_paths lps, ota_lp_enrollments lpe
431: where lps.learning_path_id = lpe.learning_path_id
432: AND lpe.lp_enrollment_id = p_lp_enrollment_id;
433:
434: l_type ota_learning_paths.path_source_code%type;
435:
436:
437: begin
438: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 855: from ota_learning_paths

851: l_total_number_of_courses number;
852:
853: CURSOR csr_get_lp_details IS
854: select duration
855: from ota_learning_paths
856: where learning_path_id = p_learning_path_id;
857:
858: CURSOR csr_get_lpms IS
859: select learning_path_member_id, activity_version_id, duration, learning_path_section_id