APPS.OTFR2483 dependencies on OTA_TRAINING_PLANS

Line 165: plan_name ota_training_plans.name%TYPE,

161: emp_num per_all_people_f.employee_number%TYPE,
162: trn_start date,
163: trn_end date,
164: class_name ota_events_tl.title%TYPE,
165: plan_name ota_training_plans.name%TYPE,
166: supplier po_vendors.vendor_name%TYPE,
167: leave_cat hr_lookups.meaning%TYPE,
168: legal_cat hr_lookups.meaning%TYPE,
169: act_hrs_chr varchar2(150),

Line 1081: ota_training_plans TP,

1077: from
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,

Line 1543: ota_training_plans tp,

1539: l_sql := L_SELECT_OUTER||L_SELECT_INNER1||'FROM
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,

Line 1776: ota_training_plans tp,

1772: l_sql := L_SELECT_OUTER||L_SELECT_INNER1||'FROM
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,

Line 2189: ota_training_plans TP,

2185: l_sql := L_SELECT_OUTER||L_SELECT_INNER1||' from
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,

Line 2542: ota_training_plans TP,

2538: l_sql := L_SELECT_OUTER||L_SELECT_INNER1||' from
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,

Line 2834: ota_training_plans TP,

2830: l_sql := L_SELECT_OUTER||L_SELECT_INNER1||' from
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,

Line 3124: ota_training_plans TP,

3120: l_sql := L_SELECT_OUTER||' from
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

Line 3227: l_new_tp_string := '(SELECT training_plan_id FROM ota_training_plans WHERE time_period_id = ';

3223: l_select2 := '(SELECT organization_id establishment_id FROM hr_fr_establishments_v WHERE company_org_id = ''';
3224: l_select2 := l_select2 || to_char(p_company_id) || '''' || ' OR organization_id = ';
3225: l_select2 := l_select2 || to_char(p_company_id) || ') v ';
3226: --
3227: l_new_tp_string := '(SELECT training_plan_id FROM ota_training_plans WHERE time_period_id = ';
3228: l_new_tp_string := l_new_tp_string || to_char(p_time_period_id) || ' and ( ( organization_id in ( select organization_id ';
3229: l_new_tp_string := l_new_tp_string || ' from hr_fr_establishments_v where company_org_id = ''' ;
3230: l_new_tp_string := l_new_tp_string || to_char(p_company_id) || '''' || ')) or ( organization_id = ';
3231: l_new_tp_string := l_new_tp_string || to_char(p_company_id) || ' )))';