APPS.HR_MEE_VIEWS_GEN dependencies on OTA_DELEGATE_BOOKINGS

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 158: 'FROM ota_delegate_bookings db, '||

154: ,p_eff_date IN DATE) IS
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 '||

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 1174: ota_delegate_bookings tdb

1170: CURSOR lc_get_other_classes (p_person_id IN per_people_f.person_id%TYPE)
1171: IS
1172: SELECT count(tdb.booking_id)
1173: FROM ota_booking_status_types bst,
1174: ota_delegate_bookings tdb
1175: WHERE tdb.booking_status_type_id = bst.booking_status_type_id
1176: AND bst.type IN ('R','C')
1177: AND tdb.delegate_person_id = p_person_id;
1178:

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 '||