APPS.OTA_CTU_BUS dependencies on OTA_ACTIVITY_VERSIONS

Line 471: ota_activity_versions tav,

467: select
468: tav.start_date,
469: tav.end_date
470: from
471: ota_activity_versions tav,
472: ota_act_cat_inclusions aci
473: where
474: tav.activity_version_id = aci.activity_version_id
475: and aci.primary_flag= 'Y'

Line 480: v_start_date ota_activity_versions.start_date%TYPE;

476: and aci.category_usage_id = p_category_usage_id;
477: --
478: -- Variables for API Boolean parameters
479: l_proc varchar2(72) := g_package ||'Chk_Act_Start_End_Date';
480: v_start_date ota_activity_versions.start_date%TYPE;
481: v_end_date ota_activity_versions.end_date%TYPE;
482: l_obj_cat varchar2(80);
483: l_obj_act varchar2(80);
484:

Line 481: v_end_date ota_activity_versions.end_date%TYPE;

477: --
478: -- Variables for API Boolean parameters
479: l_proc varchar2(72) := g_package ||'Chk_Act_Start_End_Date';
480: v_start_date ota_activity_versions.start_date%TYPE;
481: v_end_date ota_activity_versions.end_date%TYPE;
482: l_obj_cat varchar2(80);
483: l_obj_act varchar2(80);
484:
485: Begin