APPS.OTA_TPC_BUS1 dependencies on OTA_TP_MEASUREMENT_TYPES

Line 25: from OTA_TP_MEASUREMENT_TYPES

21: l_proc varchar2(72) := g_package|| 'chk_tp_measurement_type_id';
22: --
23: cursor csr_tp_measurement_type is
24: select cost_level
25: from OTA_TP_MEASUREMENT_TYPES
26: where tp_measurement_type_id = p_tp_measurement_type_id
27: and business_group_id = p_business_group_id;
28: Begin
29: --

Line 179: l_cost_level ota_tp_measurement_types.cost_level%TYPE;

175: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE
176: ,p_tp_measurement_type_id in ota_training_plan_costs.tp_measurement_type_id%TYPE
177: ) is
178: --
179: l_cost_level ota_tp_measurement_types.cost_level%TYPE;
180: l_proc varchar2(72) := g_package|| 'chk_booking_event';
181: --
182: cursor csr_booking_event is
183: select cost_level

Line 184: from OTA_TP_MEASUREMENT_TYPES

180: l_proc varchar2(72) := g_package|| 'chk_booking_event';
181: --
182: cursor csr_booking_event is
183: select cost_level
184: from OTA_TP_MEASUREMENT_TYPES
185: where tp_measurement_type_id = p_tp_measurement_type_id
186: and business_group_id = p_business_group_id;
187: Begin
188: --

Line 345: l_unit ota_tp_measurement_types.unit%TYPE;

341: --
342: l_exists varchar2(1);
343: l_proc varchar2(72) := g_package|| 'chk_currency_value';
344: l_api_updating boolean;
345: l_unit ota_tp_measurement_types.unit%TYPE;
346: --
347: cursor csr_currency_code is
348: select null
349: from FND_CURRENCIES

Line 353: from OTA_TP_MEASUREMENT_TYPES

349: from FND_CURRENCIES
350: where currency_code = p_currency_code;
351: cursor csr_unit is
352: select unit
353: from OTA_TP_MEASUREMENT_TYPES
354: where tp_measurement_type_id = p_tp_measurement_type_id
355: and business_group_id = p_business_group_id;
356: --
357: Begin