DBA Data[Home] [Help]

APPS.CN_TRX_FACTORS_PKG dependencies on CN_LOOKUPS

Line 22: -- to run against cn_lookups for the trx type lookup

18: -- Purpose
19: -- Insert a factor for each trx type. Called on quota rule commit.
20: -- Notes
21: -- cn_trx_types will be removed before production. modify this statement
22: -- to run against cn_lookups for the trx type lookup
23:
24: PROCEDURE INSERT_RECORD(x_quota_id NUMBER, x_quota_rule_id NUMBER, x_revenue_class_id NUMBER)
25: IS
26: x_user_id NUMBER := fnd_global.user_id;

Line 58: FROM cn_lookups

54: x_user_id,
55: SYSDATE,
56: l_org_id,
57: 1
58: FROM cn_lookups
59: WHERE lookup_type = 'TRX TYPES'
60: AND lookup_code NOT IN ('BALANCE UPGRADE', 'UPGRADE');
61:
62: END INSERT_RECORD;