DBA Data[Home] [Help]

APPS.OTA_FR_TRG_SUM dependencies on OTA_EVENTS

Line 426: ota_events oevent,

422: nvl(fnd_number.canonical_to_number(otpc.tp_cost_information3),0))C_W_TOT_HR --Total Hours
423: from per_all_people_f papf,
424: ota_delegate_bookings odb,
425: ota_booking_status_types obst,
426: ota_events oevent,
427: ota_events_tl oeventl,
428: ota_training_plan_costs otpc,
429: ota_tp_measurement_types otmt
430: where papf.person_id=l_p_person_id

Line 427: ota_events_tl oeventl,

423: from per_all_people_f papf,
424: ota_delegate_bookings odb,
425: ota_booking_status_types obst,
426: ota_events oevent,
427: ota_events_tl oeventl,
428: ota_training_plan_costs otpc,
429: ota_tp_measurement_types otmt
430: where papf.person_id=l_p_person_id
431: and papf.person_id=odb.delegate_person_id

Line 458: ota_events oevent

454: from per_all_people_f papf,
455: ota_delegate_bookings odb,
456: ota_training_plan_costs otpc,
457: ota_tp_measurement_types otmt,
458: ota_events oevent
459: where papf.person_id=l_p_person_id
460: and papf.person_id=odb.delegate_person_id
461: and odb.booking_id=otpc.booking_id
462: and otpc.tp_measurement_type_id = otmt.tp_measurement_type_id