APPS.CN_UPG_PMT_REASONS_PKG dependencies on CN_LOOKUPS

Line 55: from cn_reasons_all r, cn_lookups l

51: decode(r.lookup_type, 'ANALYST_NOTE_REASON',
52: decode(r.reason_code, 'USER_DEFINED', 'CN_USER', 'CN_SYSGEN'),
53: 'CN_SYSGEN') note_type,
54: r.reason_id, r.created_by, r.creation_date, 0 id, r.rowid rowid1
55: from cn_reasons_all r, cn_lookups l
56: where r.rowid between l_start_rowid and l_end_rowid
57: and r.attribute1 is null
58: and l.lookup_type (+) = r.lookup_type
59: and l.lookup_code (+) = r.reason_code;