APPS.HR_MEE_VIEWS_GEN dependencies on OTA_BOOKING_STATUS_TYPES

Line 131: 'FROM ota_booking_status_types bst, '||

127: query_str VARCHAR2(4000);
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 ';

Line 184: 'FROM ota_booking_status_types bst, '||

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

Line 1135: FROM ota_booking_status_types bst,

1131:
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

Line 1162: FROM ota_booking_status_types bst,

1158: ln_result NUMBER:= 0;
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

Line 1216: FROM ota_booking_status_types bst,

1212:
1213: CURSOR lc_get_other_classes (p_person_id IN per_people_f.person_id%TYPE)
1214: IS
1215: SELECT count(tdb.booking_id)
1216: FROM ota_booking_status_types bst,
1217: ota_delegate_bookings tdb
1218: WHERE tdb.booking_status_type_id = bst.booking_status_type_id
1219: AND bst.type IN ('R','C')
1220: AND tdb.delegate_person_id = p_person_id;

Line 2096: ',ota_booking_status_types bs , ota_booking_status_histories bsh '||

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 '||
2099: 'AND db.booking_id = bsh.booking_id(+) '||
2100: 'AND db.booking_status_type_id = bsh.booking_status_type_id (+) '||