APPS.OTA_LO_UTILITY dependencies on OTA_PREREQUISITES

Line 1316: from ota_prerequisites preq,

1312: -- The cursor below is replaced with two cursor since the below query causes a Full Table Scan
1313: /*
1314: cursor csr_chk_prereqs is
1315: select 1
1316: from ota_prerequisites preq,
1317: ota_performances perf
1318: where preq.parent_object_id = p_lo_id and
1319: preq.object_id = perf.learning_object_id(+) and
1320: perf.user_id(+) = p_user_id and

Line 1335: FROM ota_prerequisites

1331: return l_return;
1332: */
1333: CURSOR csr_get_prereqs IS
1334: SELECT object_id
1335: FROM ota_prerequisites
1336: where parent_object_id = p_lo_id
1337: and parent_type = 'LO';
1338:
1339: CURSOR csr_get_performances(csr_lo_id NUMBER) IS