APPS.OTA_LRNG_PATH_MEMBER_UTIL dependencies on OTA_PERFORMANCES

Line 1369: ota_performances opf,

1365: p_user_type IN ota_attempts.user_type%type) IS
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

Line 1391: ota_performances opf,

1387: p_user_type IN ota_attempts.user_type%type) IS
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

Line 1460: --get the compeltion date from ota_performances

1456: FETCH class_type into l_sync_flag, l_online_flag;
1457: CLOSE class_type;
1458:
1459: if(l_online_flag = 'Y') then
1460: --get the compeltion date from ota_performances
1461: l_user_id := nvl(p_person_id, p_contact_id);
1462: if(p_person_id is not null) then
1463: l_user_type := 'E';
1464: