APPS.OTA_CTU_BUS dependencies on OTA_LEARNING_PATHS

Line 564: ota_learning_paths lps,

560: select
561: lps.start_date_active,
562: lps.end_date_active
563: from
564: ota_learning_paths lps,
565: ota_lp_cat_inclusions lci
566: where
567: lps.learning_path_id = lci.learning_path_id
568: and lci.primary_flag= 'Y'

Line 573: v_start_date ota_learning_paths.start_date_active%TYPE;

569: and lci.category_usage_id = p_category_usage_id;
570: --
571: -- Variables for API Boolean parameters
572: l_proc varchar2(72) := g_package ||'Chk_lp_Start_End_Date';
573: v_start_date ota_learning_paths.start_date_active%TYPE;
574: v_end_date ota_learning_paths.end_date_active%TYPE;
575: l_obj_cat varchar2(80);
576: l_obj_lp varchar2(80);
577:

Line 574: v_end_date ota_learning_paths.end_date_active%TYPE;

570: --
571: -- Variables for API Boolean parameters
572: l_proc varchar2(72) := g_package ||'Chk_lp_Start_End_Date';
573: v_start_date ota_learning_paths.start_date_active%TYPE;
574: v_end_date ota_learning_paths.end_date_active%TYPE;
575: l_obj_cat varchar2(80);
576: l_obj_lp varchar2(80);
577:
578: Begin