APPS.HZ_GNR_PKG dependencies on AR_LOOKUPS

Line 276: FROM ar_lookups

272: RAISE FND_API.G_EXC_ERROR;
273: ELSE
274: SELECT COUNT(*)
275: INTO l_run_type_count
276: FROM ar_lookups
277: WHERE lookup_type = 'HZ_GEO_GNR_RUN_TYPE'
278: AND lookup_code = p_run_type
279: AND TRUNC(SYSDATE) BETWEEN NVL(start_date_active,SYSDATE) AND NVL(end_date_active, SYSDATE+1)
280: AND enabled_flag = 'Y';

Line 289: -- Validate USAGE Type parameter from seeded usage from ar_lookups for

285: RAISE FND_API.G_EXC_ERROR;
286: END IF;
287: END IF;
288:
289: -- Validate USAGE Type parameter from seeded usage from ar_lookups for
290: -- lookup Type HZ_GEOGRAPHY_USAGE
291: IF (p_usage_code IS NOT NULL) THEN
292: SELECT COUNT(*)
293: INTO l_usage_count

Line 294: FROM ar_lookups

290: -- lookup Type HZ_GEOGRAPHY_USAGE
291: IF (p_usage_code IS NOT NULL) THEN
292: SELECT COUNT(*)
293: INTO l_usage_count
294: FROM ar_lookups
295: WHERE lookup_type = 'HZ_GEOGRAPHY_USAGE'
296: AND lookup_code = p_usage_code
297: AND TRUNC(SYSDATE) BETWEEN NVL(start_date_active,SYSDATE) AND NVL(end_date_active, SYSDATE+1)
298: AND enabled_flag = 'Y';