APPS.OTA_TPC_BUS1 dependencies on OTA_EVENTS

Line 259: l_event_start_date ota_events.course_start_date%TYPE;

255: ) is
256: --
257: l_business_group_id ota_training_plan_costs.business_group_id%TYPE;
258: l_plan_start_date per_time_periods.start_date%TYPE;
259: l_event_start_date ota_events.course_start_date%TYPE;
260: l_proc varchar2(72) := g_package|| 'chk_event_id';
261: --
262: cursor csr_event_id is
263: select business_group_id, course_start_date

Line 264: from OTA_EVENTS

260: l_proc varchar2(72) := g_package|| 'chk_event_id';
261: --
262: cursor csr_event_id is
263: select business_group_id, course_start_date
264: from OTA_EVENTS
265: where event_id = p_event_id;
266:
267: cursor csr_event_id_dates is
268: select ptp.start_date