DBA Data[Home] [Help]

APPS.HR_MEE_VIEWS_GEN dependencies on OTA_EVENTS

Line 132: ' ota_events evt, ota_delegate_bookings db '||

128: BEGIN
129: query_str := 'SELECT '||
130: 'sum(hr_mee_views_gen.convertDuration(evt.duration_units, ''H'',evt.duration)) '||
131: 'FROM ota_booking_status_types bst, '||
132: ' ota_events evt, ota_delegate_bookings db '||
133: 'WHERE db.booking_status_type_id = bst.booking_status_type_id '||
134: 'AND db.event_id = evt.event_id '||
135: 'AND db.delegate_person_id = :1 ';
136:

Line 159: ' ota_events evt, ota_finance_lines fl '||

155: query_str VARCHAR2(4000);
156: BEGIN
157: query_str := 'SELECT SUM(hr_mee_views_gen.amtInLoginPrsnCurrency(evt.currency_code, fl.money_amount, evt.course_start_date)) '||
158: 'FROM ota_delegate_bookings db, '||
159: ' ota_events evt, ota_finance_lines fl '||
160: 'WHERE db.booking_id = fl.booking_id(+) '||
161: 'AND nvl(fl.cancelled_flag(+),''N'') = ''N'' '||
162: 'AND db.event_id = evt.event_id '||
163: 'AND db.delegate_person_id = :1 ';

Line 185: ' ota_events evt, ota_delegate_bookings db '||

181: query_str VARCHAR2(4000);
182: BEGIN
183: query_str := 'SELECT count(db.booking_id) '||
184: 'FROM ota_booking_status_types bst, '||
185: ' ota_events evt, ota_delegate_bookings db '||
186: 'WHERE db.booking_status_type_id = bst.booking_status_type_id '||
187: 'AND db.event_id = evt.event_id '||
188: 'AND EXISTS (SELECT ''e'' '||
189: 'FROM ota_training_plans tp, ota_training_plan_members tpm '||

Line 1136: ota_events evt, ota_delegate_bookings db

1132: CURSOR c_classes (p_person_id IN per_people_f.person_id%TYPE)
1133: IS
1134: SELECT count(db.booking_id)
1135: FROM ota_booking_status_types bst,
1136: ota_events evt, ota_delegate_bookings db
1137: WHERE db.booking_status_type_id = bst.booking_status_type_id
1138: AND db.event_id = evt.event_id
1139: AND evt.course_start_date <= p_eff_date
1140: AND bst.type = 'A'

Line 1163: ota_events evt, ota_delegate_bookings tdb

1159:
1160: CURSOR c_classes (p_person_id IN NUMBER) IS
1161: SELECT count(tdb.booking_id)
1162: FROM ota_booking_status_types bst,
1163: ota_events evt, ota_delegate_bookings tdb
1164: WHERE tdb.booking_status_type_id = bst.booking_status_type_id
1165: AND tdb.event_id = evt.event_id
1166: AND evt.course_start_date > p_eff_date
1167: AND bst.type NOT IN ('C')

Line 2094: query_str := 'Select db.score FROM ota_delegate_bookings db, ota_events evt '||

2090: query_str VARCHAR2(4000);
2091: BEGIN
2092: if( p_mode = 0) then
2093:
2094: query_str := 'Select db.score FROM ota_delegate_bookings db, ota_events evt '||
2095: ',ota_activity_versions av '||
2096: ',ota_booking_status_types bs , ota_booking_status_histories bsh '||
2097: 'WHERE db.booking_status_type_id = bs.booking_status_type_id '||
2098: 'and db.delegate_person_id = :1 '||

Line 2110: ', ota_learning_objects olo , ota_events evt '||

2106:
2107:
2108: ELSE
2109: query_str := 'select opr.score from ota_performances opr , ota_offerings ofr '||
2110: ', ota_learning_objects olo , ota_events evt '||
2111: 'where ofr.learning_object_id = olo.learning_object_id(+) '||
2112: 'and olo.learning_object_id = opr.learning_object_id(+) '||
2113: 'and opr.user_id(+) = :1 '||
2114: 'and evt.event_id = :2 '||

Line 2177: 'From OTA_EVENTS oev, OTA_OFFERINGS ofr, OTA_PERFORMANCES opf, ota_category_usages ocu '||

2173: cur_str VARCHAR2(4000);
2174: EndDate DATE;
2175: BEGIN
2176: cur_str := 'Select opf.completed_date EndDate '||
2177: 'From OTA_EVENTS oev, OTA_OFFERINGS ofr, OTA_PERFORMANCES opf, ota_category_usages ocu '||
2178: 'Where oev.parent_offering_id = ofr.offering_id '||
2179: 'And ofr.learning_object_id = opf.learning_object_id(+) '||
2180: 'And ocu.Category_Usage_Id = ofr.Delivery_Mode_Id '||
2181: 'and ocu.Online_Flag = ''Y'' '||