APPS.OTA_TPC_BUS1 dependencies on OTA_TRAINING_PLANS

Line 81: from OTA_TRAINING_PLANS

77: l_proc varchar2(72) := g_package|| 'chk_training_plan_id';
78: --
79: cursor csr_training_plan_id is
80: select null
81: from OTA_TRAINING_PLANS
82: where training_plan_id = p_training_plan_id
83: and business_group_id = p_business_group_id;
84: Begin
85: --

Line 254: ,p_training_plan_id in ota_training_plans.training_plan_id%TYPE

250: --
251: Procedure chk_event_id
252: (p_event_id in ota_training_plan_costs.event_id%TYPE
253: ,p_business_group_id in ota_training_plan_costs.business_group_id%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;

Line 270: ,OTA_TRAINING_PLANS tps

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:
274: Begin