APPS.OTA_LP_MEMBER_SWI dependencies on OTA_LEARNING_PATH_MEMBERS

Line 435: from ota_learning_path_members lpm

431: ) return VARCHAR2 IS
432:
433: cursor csr_course is
434: select NULL
435: from ota_learning_path_members lpm
436: where lpm.learning_path_id = p_learning_path_id
437: and lpm.activity_version_id = p_activity_version_id;
438:
439: l_exists varchar2(1) := 'N';

Line 463: FROM ota_learning_path_members

459: CURSOR csr_chk_duration IS
460: SELECT count(learning_path_member_id) lpm_num,
461: count(duration) duration_num,
462: max(duration) max_duration
463: FROM ota_learning_path_members
464: WHERE learning_path_id = p_learning_path_id;
465:
466: no_of_lpms NUMBER;
467: no_of_durations NUMBER;

Line 516: (p_associated_column1 => 'OTA_LEARNING_PATH_MEMBERS.DURATION') THEN

512:
513: WHEN app_exception.application_exception THEN
514:
515: IF hr_multi_message.exception_add
516: (p_associated_column1 => 'OTA_LEARNING_PATH_MEMBERS.DURATION') THEN
517:
518: hr_utility.set_location(' Leaving:'||l_proc, 42);
519: RAISE;
520: