DBA Data[Home] [Help]

APPS.OKL_LEASE_APP_PVT dependencies on FND_LOOKUPS

Line 126: FROM FND_LOOKUPS FL

122: --Cursor to check for Approve or Reject recommendation for a
123: --given Lease Application
124: CURSOR lkup_meaning_csr(p_lookup_type VARCHAR2, p_lookup_code VARCHAR2) IS
125: SELECT MEANING
126: FROM FND_LOOKUPS FL
127: WHERE FL.LOOKUP_TYPE = p_lookup_type
128: AND FL.LOOKUP_CODE = p_lookup_code;
129:
130: BEGIN

Line 244: FROM FND_LOOKUPS FL

240: --Cursor to check for Approve or Reject recommendation for a
241: --given Lease Application
242: CURSOR credit_decision_csr(p_decision_code VARCHAR2) IS
243: SELECT MEANING
244: FROM FND_LOOKUPS FL
245: WHERE FL.LOOKUP_TYPE = 'OKL_LEASE_APP_STATUS'
246: AND FL.LOOKUP_CODE = p_decision_code;
247:
248: BEGIN