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 868: SELECT lookup_code FROM ar_lookups

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