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 202: FROM FND_LOOKUPS FL

198: --Cursor to check for Approve or Reject recommendation for a
199: --given Lease Application
200: CURSOR credit_decision_csr(p_decision_code VARCHAR2) IS
201: SELECT MEANING
202: FROM FND_LOOKUPS FL
203: WHERE FL.LOOKUP_TYPE = 'OKL_LEASE_APP_STATUS'
204: AND FL.LOOKUP_CODE = p_decision_code;
205:
206: BEGIN