DBA Data[Home] [Help]

APPS.ZX_TCM_GET_EXEMPT_PKG dependencies on FND_LOOKUPS

Line 293: from FND_LOOKUPS

289: IF x_exemption_rec.exempt_reason_code IS NOT NULL THEN
290: BEGIN
291: SELECT meaning
292: INTO x_exemption_rec.exempt_reason
293: from FND_LOOKUPS
294: where lookup_type = 'ZX_EXEMPTION_REASON_CODE'
295: and lookup_code = x_exemption_rec.exempt_reason_code;
296: EXCEPTION
297: WHEN NO_DATA_FOUND THEN

Line 354: from FND_LOOKUPS

350: IF x_exemption_rec.exempt_reason_code IS NOT NULL THEN
351: BEGIN
352: SELECT meaning
353: INTO x_exemption_rec.exempt_reason
354: from FND_LOOKUPS
355: where lookup_type = 'ZX_EXEMPTION_REASON_CODE'
356: and lookup_code = x_exemption_rec.exempt_reason_code;
357: EXCEPTION
358: WHEN NO_DATA_FOUND THEN

Line 414: from FND_LOOKUPS

410: IF x_exemption_rec.exempt_reason_code IS NOT NULL THEN
411: BEGIN
412: SELECT meaning
413: INTO x_exemption_rec.exempt_reason
414: from FND_LOOKUPS
415: where lookup_type = 'ZX_EXEMPTION_REASON_CODE'
416: and lookup_code = x_exemption_rec.exempt_reason_code;
417: EXCEPTION
418: WHEN NO_DATA_FOUND THEN