APPS.FND_CONCURRENT_PROG_ANNO_PKG dependencies on DBMS_LOB

Line 16: select dbms_lob.substr(PROGRAM_ANNOTATION,download_size,start_index ) into anno_text1

12: lcount := 1;
13:
14: LOOP
15:
16: select dbms_lob.substr(PROGRAM_ANNOTATION,download_size,start_index ) into anno_text1
17: from FND_CONC_PROG_ANNOTATIONS where CONCURRENT_PROGRAM_ID=X_CONCURRENT_PROGRAM_ID AND
18: APPLICATION_ID=X_APPLICATION_ID ;
19:
20: start_index := start_index+download_size;