DBA Data[Home] [Help]

APPS.OTA_FR_TRG_SUM dependencies on OTA_DELEGATE_BOOKINGS

Line 424: ota_delegate_bookings odb,

420: fnd_number.canonical_to_number(otpc.tp_cost_information4) C_W_O_HR , --Hours Outside working
421: decode(otmt.tp_measurement_code,'FR_ACTUAL_HOURS',nvl(otpc.amount,0),
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,

Line 455: ota_delegate_bookings odb,

451: decode(otmt.tp_measurement_code,'FR_ACTUAL_HOURS',
452: otpc.tp_cost_information3,
453: ' ') LEGAL_CATG --i)JOB_ADAPT ii) JOB_EVOL , iii)COMP_DEV
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