APPS.OKL_LEASE_QUOTE_WORKFLOW_PVT dependencies on FND_APPLICATION

Line 665: FROM fnd_application

661: -- Get the valid application id from FND
662: CURSOR c_get_app_id_csr
663: IS
664: SELECT application_id
665: FROM fnd_application
666: WHERE application_short_name = 'OKL';
667: -- added by venkatho END Bug: 15933691
668:
669: BEGIN

Line 760: l_application_id fnd_application.application_id%TYPE;

756: l_approved_message VARCHAR2(500);
757: l_rejected_message VARCHAR2(500);
758: l_reminder_message VARCHAR2(500);
759: l_user_name VARCHAR2(240);
760: l_application_id fnd_application.application_id%TYPE;
761: l_parent_code VARCHAR2(20);
762: l_parent_id NUMBER;
763: l_approver_role VARCHAR2(100); -- added for BUG16175322
764:

Line 790: FROM FND_APPLICATION

786: -- Get the valid application id from FND
787:
788: CURSOR c_get_app_id_csr IS
789: SELECT APPLICATION_ID
790: FROM FND_APPLICATION
791: WHERE APPLICATION_SHORT_NAME = G_APP_NAME;
792:
793:
794: CURSOR get_lease_app(lease_app_id IN NUMBER) IS