[Home] [Help]
341: OTHER_LEARN_DEDUCT_COST_INT
342: ,max(decode(tmt.tp_measurement_code,
343: 'FR_OTHER_LEARN_DEDUCT_EXT',TMT.tp_measurement_type_id))
344: OTHER_LEARN_DEDUCT_COST_EXT
345: from ota_tp_measurement_types tmt
346: where TMT.business_group_id = p_bg_id
347: and tmt.tp_measurement_code in ('FR_DEDUCT_EXT_TRN_PLAN',
348: 'FR_DEDUCT_EXT_TRN_PLAN_SA',
349: 'FR_DEDUCT_EXT_TRN_PLAN_VAE',
1080: hr_all_organization_units org,
1081: ota_training_plans TP,
1082: per_time_periods PTP,
1083: ota_training_plan_costs TPC,
1084: ota_tp_measurement_types TMT,
1085: ota_delegate_bookings ODB,
1086: per_all_people_f PER,
1087: ota_events EVT,
1088: per_all_assignments_f ass,
1775: hr_all_organization_units org,
1776: ota_training_plans tp,
1777: per_time_periods ptp,
1778: ota_training_plan_costs tp_cost,
1779: ota_tp_measurement_types meas_type,
1780: ota_delegate_bookings delegate,
1781: ota_events event,
1782: ota_events_tl event_tl,
1783: per_all_people_f per
2188: hr_all_organization_units org,
2189: ota_training_plans TP,
2190: per_time_periods PTP,
2191: ota_training_plan_costs TPC,
2192: ota_tp_measurement_types TMT,
2193: ota_delegate_bookings ODB,
2194: per_all_people_f PER
2195: where comp.organization_id = :p_company_id
2196: and comp.date_from <= :p_year_end
2541: hr_all_organization_units org,
2542: ota_training_plans TP,
2543: per_time_periods PTP,
2544: ota_training_plan_costs TPC,
2545: ota_tp_measurement_types TMT,
2546: ota_delegate_bookings ODB,
2547: per_all_people_f PER
2548: where comp.organization_id = :p_company_id
2549: and comp.date_from <= :p_year_end
2834: ota_training_plans TP,
2835: per_time_periods PTP,
2836: ota_training_plan_costs TPC_sal,
2837: ota_training_plan_costs TPC_hrs,
2838: ota_tp_measurement_types TMT,
2839: ota_delegate_bookings ODB,
2840: ota_events EVT,
2841: per_all_people_f PER,
2842: hr_lookups HLK_tmt,