APPS.OKL_LEASE_APP_WF dependencies on FND_APPLICATION

Line 42: FROM FND_APPLICATION

38:
39: -- Get the valid application id from FND
40: CURSOR c_get_app_id_csr IS
41: SELECT APPLICATION_ID
42: FROM FND_APPLICATION
43: WHERE APPLICATION_SHORT_NAME = G_APP_NAME;
44:
45: CURSOR obj_name_csr(object_type IN VARCHAR2) IS
46: SELECT MEANING

Line 170: l_application_id fnd_application.application_id%TYPE;

166: x_msg_data VARCHAR2(32767);
167:
168: l_lease_app_id OKL_LEASE_APPLICATIONS_V.ID%TYPE;
169: l_user_name VARCHAR2(240);
170: l_application_id fnd_application.application_id%TYPE;
171:
172: CURSOR c_get_lease_app_details (cp_la_id OKL_LEASE_APPLICATIONS_V.ID%TYPE) IS
173: SELECT LAP.REFERENCE_NUMBER LEASE_APP_NAME
174: , LAP.APPLICATION_STATUS LEASE_APP_STATUS

Line 447: l_application_id fnd_application.application_id%TYPE;

443: x_msg_count NUMBER;
444: x_msg_data VARCHAR2(32767);
445:
446: l_user_name VARCHAR2(240);
447: l_application_id fnd_application.application_id%TYPE;
448: l_lat_version_id OKL_LEASEAPP_TEMPL_VERSIONS_V.ID%TYPE;
449:
450: CURSOR c_get_lat_details(cp_lat_ver_id OKL_LEASEAPP_TEMPL_VERSIONS_V.ID%TYPE) IS
451: SELECT LATV.NAME LAT_NAME