DBA Data[Home] [Help]

APPS.CNSYSP_SYSTEM_PARAMETERS_PKG dependencies on CN_LOOKUPS

Line 45: FROM cn_lookups

41:
42: if (x_trx_rollup_method is not null) then
43: SELECT meaning
44: INTO x_trx_rollup_method_string
45: FROM cn_lookups
46: WHERE LOOKUP_CODE = x_trx_rollup_method
47: AND LOOKUP_TYPE = 'TRX_ROLLUP_METHOD';
48: end if;
49:

Line 52: FROM cn_lookups

48: end if;
49:
50: if (x_usage_flag is not null) then
51: SELECT meaning into x_usage_string
52: FROM cn_lookups
53: WHERE LOOKUP_CODE = x_usage_flag
54: AND LOOKUP_TYPE = 'REPOSITORY_USAGE';
55: end if;
56:

Line 59: FROM cn_lookups

55: end if;
56:
57: if (x_status is not null) then
58: SELECT meaning into x_status_string
59: FROM cn_lookups
60: WHERE LOOKUP_CODE = x_status
61: AND LOOKUP_TYPE = 'REPOSITORY_STATUS';
62: end if;
63: