[Home] [Help]
1078: hr_all_organization_units comp,
1079: hr_organization_information tp_org_info,
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,
1540: hr_all_organization_units comp,
1541: hr_organization_information tp_org_info,
1542: hr_all_organization_units org,
1543: ota_training_plans tp,
1544: per_time_periods ptp,
1545: ota_training_plan_costs tp_cost,
1546: ota_training_plan_costs tp_cost_hrs,
1547: ota_delegate_bookings delegate,
1548: per_all_people_f per,
1773: hr_all_organization_units comp,
1774: hr_organization_information tp_org_info,
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,
2186: hr_all_organization_units comp,
2187: hr_organization_information tp_org_info,
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
2539: hr_all_organization_units comp,
2540: hr_organization_information tp_org_info,
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
2831: hr_all_organization_units comp,
2832: hr_organization_information tp_org_info,
2833: hr_all_organization_units org,
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,
3121: hr_all_organization_units comp,
3122: hr_organization_information tp_org_info,
3123: hr_all_organization_units org,
3124: ota_training_plans TP,
3125: per_time_periods PTP,
3126: ota_training_plan_costs TPC
3127: where comp.organization_id = :p_company_id
3128: and comp.date_from <= :p_end_year
3129: and (comp.date_to is null or
3238: SELECT 'to_date('''||to_char(ptp.start_date,'YYYYMMDD')||''',''YYYYMMDD'')'
3239: , 'to_date('''||to_char(ptp.end_date,'YYYYMMDD')||''',''YYYYMMDD'')'
3240: INTO l_start_of_plan,
3241: l_end_of_plan
3242: FROM per_time_periods ptp
3243: WHERE ptp.time_period_id = p_time_period_id;
3244: exception
3245: when others then null;
3246: end;