APPS.FA_LEASE_PVT dependencies on FA_LOOKUPS

Line 536: FROM FA_LOOKUPS WHERE

532: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN AS
533:
534: CURSOR C_LEASE_TYPE IS
535: SELECT LOOKUP_CODE
536: FROM FA_LOOKUPS WHERE
537: LOOKUP_TYPE='LEASE TYPES'
538: AND LOOKUP_CODE = UPPER(P_LEASE_TYPE)
539: AND ENABLED_FLAG = 'Y'
540: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE,SYSDATE) AND NVL(END_DATE_ACTIVE,SYSDATE);