APPS.OTA_LO_UTILITY dependencies on OTA_PREREQUISITES

Line 1009: from ota_prerequisites preq,

1005: -- The cursor below is replaced with two cursor since the below query causes a Full Table Scan
1006: /*
1007: cursor csr_chk_prereqs is
1008: select 1
1009: from ota_prerequisites preq,
1010: ota_performances perf
1011: where preq.parent_object_id = p_lo_id and
1012: preq.object_id = perf.learning_object_id(+) and
1013: perf.user_id(+) = p_user_id and

Line 1028: FROM ota_prerequisites

1024: return l_return;
1025: */
1026: CURSOR csr_get_prereqs IS
1027: SELECT object_id
1028: FROM ota_prerequisites
1029: where parent_object_id = p_lo_id
1030: and parent_type = 'LO';
1031:
1032: CURSOR csr_get_performances(csr_lo_id NUMBER) IS