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 1093: ota_events evt, ota_delegate_bookings db

1089: CURSOR c_classes (p_person_id IN per_people_f.person_id%TYPE)
1090: IS
1091: SELECT count(db.booking_id)
1092: FROM ota_booking_status_types bst,
1093: ota_events evt, ota_delegate_bookings db
1094: WHERE db.booking_status_type_id = bst.booking_status_type_id
1095: AND db.event_id = evt.event_id
1096: AND evt.course_start_date <= p_eff_date
1097: AND bst.type = 'A'

Line 1120: ota_events evt, ota_delegate_bookings tdb

1116:
1117: CURSOR c_classes (p_person_id IN NUMBER) IS
1118: SELECT count(tdb.booking_id)
1119: FROM ota_booking_status_types bst,
1120: ota_events evt, ota_delegate_bookings tdb
1121: WHERE tdb.booking_status_type_id = bst.booking_status_type_id
1122: AND tdb.event_id = evt.event_id
1123: AND evt.course_start_date > p_eff_date
1124: AND bst.type NOT IN ('C')

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

2047: query_str VARCHAR2(4000);
2048: BEGIN
2049: if( p_mode = 0) then
2050:
2051: query_str := 'Select db.score FROM ota_delegate_bookings db, ota_events evt '||
2052: ',ota_activity_versions av '||
2053: ',ota_booking_status_types bs , ota_booking_status_histories bsh '||
2054: 'WHERE db.booking_status_type_id = bs.booking_status_type_id '||
2055: 'and db.delegate_person_id = :1 '||

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

2063:
2064:
2065: ELSE
2066: query_str := 'select opr.score from ota_performances opr , ota_offerings ofr '||
2067: ', ota_learning_objects olo , ota_events evt '||
2068: 'where ofr.learning_object_id = olo.learning_object_id(+) '||
2069: 'and olo.learning_object_id = opr.learning_object_id(+) '||
2070: 'and opr.user_id(+) = :1 '||
2071: 'and evt.event_id = :2 '||

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

2130: cur_str VARCHAR2(4000);
2131: EndDate DATE;
2132: BEGIN
2133: cur_str := 'Select opf.completed_date EndDate '||
2134: 'From OTA_EVENTS oev, OTA_OFFERINGS ofr, OTA_PERFORMANCES opf, ota_category_usages ocu '||
2135: 'Where oev.parent_offering_id = ofr.offering_id '||
2136: 'And ofr.learning_object_id = opf.learning_object_id(+) '||
2137: 'And ocu.Category_Usage_Id = ofr.Delivery_Mode_Id '||
2138: 'and ocu.Online_Flag = ''Y'' '||