[Home] [Help]
APPS.CNSYIN_REPOSITORY_PKG dependencies on CN_LOOKUPS
Line 21: FROM cn_lookups lookup1, cn_lookups lookup2
17: BEGIN
18:
19: SELECT lookup1.meaning, lookup2.meaning
20: INTO X_status_name, X_usage_name
21: FROM cn_lookups lookup1, cn_lookups lookup2
22: WHERE lookup1.lookup_type = 'REPOSITORY_STATUS'
23: AND lookup1.lookup_code = X_status
24: AND lookup2.lookup_type = 'REPOSITORY_USAGE'
25: AND lookup2.lookup_code = X_usage;