APPS.OTA_TPC_BUS1 dependencies on PER_TIME_PERIODS

Line 258: l_plan_start_date per_time_periods.start_date%TYPE;

254: ,p_training_plan_id in ota_training_plans.training_plan_id%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

Line 269: from PER_TIME_PERIODS ptp

265: where event_id = p_event_id;
266:
267: cursor csr_event_id_dates is
268: select ptp.start_date
269: from PER_TIME_PERIODS ptp
270: ,OTA_TRAINING_PLANS tps
271: where ptp.time_period_id = tps.time_period_id
272: and tps.training_plan_id = p_training_plan_id;
273: