APPS.OTA_LRNG_PATH_MEMBER_UTIL dependencies on OTA_CATEGORY_USAGES

Line 1358: ota_category_usages ocu

1354: SELECT ocu.synchronous_flag,
1355: ocu.online_flag
1356: FROM ota_events oev,
1357: ota_offerings ofr,
1358: ota_category_usages ocu
1359: WHERE oev.parent_offering_id = ofr.offering_id
1360: AND ocu.category_usage_Id = ofr.delivery_mode_id
1361: AND oev.event_id = p_event_id;
1362:

Line 1370: ota_category_usages ocu,

1366: SELECT ota_timezone_util.get_dateDT(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), ocu.Online_Flag, ota_timezone_util.get_server_timezone_code) completion_date
1367: FROM ota_events oev,
1368: ota_offerings ofr,
1369: ota_performances opf,
1370: ota_category_usages ocu,
1371: ota_delegate_bookings odb,
1372: ota_booking_status_types obst
1373: WHERE oev.parent_offering_id = ofr.offering_id
1374: AND ofr.learning_object_id = opf.learning_object_id

Line 1392: ota_category_usages ocu,

1388: SELECT ota_timezone_util.get_dateDT(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), ocu.Online_Flag, ota_timezone_util.get_server_timezone_code) completion_date
1389: FROM ota_events oev,
1390: ota_offerings ofr,
1391: ota_performances opf,
1392: ota_category_usages ocu,
1393: ota_delegate_bookings odb,
1394: ota_booking_status_types obst
1395: WHERE oev.parent_offering_id = ofr.offering_id
1396: AND ofr.learning_object_id = opf.learning_object_id

Line 1447: l_sync_flag ota_category_usages.synchronous_flag%type;

1443: AND obst.type = 'A'
1444: AND odb.delegate_contact_id = p_contact_id
1445: AND odb.event_id = p_event_id;
1446:
1447: l_sync_flag ota_category_usages.synchronous_flag%type;
1448: l_online_flag ota_category_usages.online_flag%type;
1449: l_completion_date date:= null;
1450: l_user_id ota_attempts.user_id%type;
1451: l_user_type ota_attempts.user_type%type;

Line 1448: l_online_flag ota_category_usages.online_flag%type;

1444: AND odb.delegate_contact_id = p_contact_id
1445: AND odb.event_id = p_event_id;
1446:
1447: l_sync_flag ota_category_usages.synchronous_flag%type;
1448: l_online_flag ota_category_usages.online_flag%type;
1449: l_completion_date date:= null;
1450: l_user_id ota_attempts.user_id%type;
1451: l_user_type ota_attempts.user_type%type;
1452: