APPS.CN_UPG_PMT_REASONS_PKG dependencies on DBMS_LOB

Line 49: decode(r.lookup_type, 'ANALYST_NOTE_REASON', dbms_lob.substr(r.reason),

45:
46: cursor get_reasons is
47: select /*+ ROWID(r) */ r.upd_table_id,
48: r.updated_table,
49: decode(r.lookup_type, 'ANALYST_NOTE_REASON', dbms_lob.substr(r.reason),
50: l.meaning) note,
51: decode(r.lookup_type, 'ANALYST_NOTE_REASON',
52: decode(r.reason_code, 'USER_DEFINED', 'CN_USER', 'CN_SYSGEN'),
53: 'CN_SYSGEN') note_type,