APPS.OTA_TDB_BUS dependencies on OTA_TRAINING_PLAN_COSTS

Line 1283: -- Checks if booking id is referenced in ota_training_plan_costs

1279: --
1280: -- PUBLIC
1281: -- Description: Check training plan costs
1282: --
1283: -- Checks if booking id is referenced in ota_training_plan_costs
1284: --
1285: Procedure check_training_plan_costs(p_booking_id in number) is
1286: --
1287: l_proc varchar2(72) := g_package||'check_training_plan_costs';

Line 1294: from OTA_TRAINING_PLAN_COSTS

1290: -- sql statment to check if the booking is referenced in training plan costs
1291: --
1292: Cursor Csr_chk_tpc_rows(p_booking_id Number) IS
1293: select 'Y'
1294: from OTA_TRAINING_PLAN_COSTS
1295: where booking_id = p_booking_id;
1296: --
1297: begin
1298: --

Line 4489: -- Check that booking id is not referenced in ota_training_plan_costs

4485: hr_utility.set_location('Entering:'||l_proc, 5);
4486: --
4487: -- Call all supporting business operations
4488: --
4489: -- Check that booking id is not referenced in ota_training_plan_costs
4490: --
4491: check_training_plan_costs(p_rec.booking_id);
4492: --
4493: -- Check if Line id is not null