APPS.HZ_COMMON_PUB dependencies on AR_LOOKUPS

Line 166: FROM ar_lookups

162: ) IS
163:
164: CURSOR c_exist IS
165: SELECT 'Y'
166: FROM ar_lookups
167: WHERE lookup_type = p_lookup_type
168: AND lookup_code = p_column_value
169: AND ROWNUM = 1;
170:

Line 866: SELECT lookup_code FROM ar_lookups

862: p_data_source IN VARCHAR2
863: ) RETURN VARCHAR2 IS
864:
865: CURSOR c_content_source_type IS
866: SELECT lookup_code FROM ar_lookups
867: WHERE lookup_type = 'CONTENT_SOURCE_TYPE' and
868: ENABLED_FLAG = 'Y' AND
869: TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE,SYSDATE)) AND TRUNC(NVL(END_DATE_ACTIVE,SYSDATE));
870: