DBA Data[Home] [Help]

APPS.CN_TRX_FACTOR_PVT dependencies on CN_LOOKUPS

Line 25: l_lkup_meaning cn_lookups.meaning%TYPE;

21: x_loading_status OUT NOCOPY VARCHAR2
22: )
23: IS
24: l_api_name CONSTANT VARCHAR2 (30) := 'Validate_trx_factors';
25: l_lkup_meaning cn_lookups.meaning%TYPE;
26: l_loading_status VARCHAR2 (80);
27: BEGIN
28: -- Initialize API return status to success
29: x_return_status := fnd_api.g_ret_sts_success;

Line 276: FROM cn_lookups

272: BEGIN
273: --clku bug 2376751
274: SELECT meaning
275: INTO l_trx_name
276: FROM cn_lookups
277: WHERE lookup_type = 'TRX TYPES' AND lookup_code = p_trx_factor.trx_type;
278: EXCEPTION
279: WHEN NO_DATA_FOUND
280: THEN