APPS.FUN_RULE_UTILITY_PKG dependencies on AR_LOOKUPS

Line 267: l_lookup_type AR_LOOKUPS.lookup_type%TYPE;

263: l_position1 NUMBER;
264: l_position2 NUMBER;
265:
266: l_lookup_table VARCHAR2(30);
267: l_lookup_type AR_LOOKUPS.lookup_type%TYPE;
268: l_lookup_code AR_LOOKUPS.lookup_code%TYPE;
269:
270: l_relationship_type VARCHAR2(30);
271: l_incl_unrelated_entities VARCHAR2(1);

Line 268: l_lookup_code AR_LOOKUPS.lookup_code%TYPE;

264: l_position2 NUMBER;
265:
266: l_lookup_table VARCHAR2(30);
267: l_lookup_type AR_LOOKUPS.lookup_type%TYPE;
268: l_lookup_code AR_LOOKUPS.lookup_code%TYPE;
269:
270: l_relationship_type VARCHAR2(30);
271: l_incl_unrelated_entities VARCHAR2(1);
272:

Line 294: IF UPPER( l_lookup_table ) = 'AR_LOOKUPS' THEN

290: l_lookup_type := SUBSTRB( p_val, l_position1 + G_LENGTH,
291: l_position2 - l_position1 - G_LENGTH );
292: l_lookup_code := SUBSTRB( p_val, l_position2 + G_LENGTH );
293:
294: IF UPPER( l_lookup_table ) = 'AR_LOOKUPS' THEN
295: BEGIN
296: SELECT meaning INTO x_lookup_meaning
297: FROM AR_LOOKUPS
298: WHERE LOOKUP_TYPE = l_lookup_type

Line 297: FROM AR_LOOKUPS

293:
294: IF UPPER( l_lookup_table ) = 'AR_LOOKUPS' THEN
295: BEGIN
296: SELECT meaning INTO x_lookup_meaning
297: FROM AR_LOOKUPS
298: WHERE LOOKUP_TYPE = l_lookup_type
299: AND LOOKUP_CODE = l_lookup_code
300: AND ( ENABLED_FLAG = 'Y' AND
301: TRUNC( SYSDATE ) BETWEEN