APPS.OKL_REQ_WF SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 27

      SELECT cure_report_id
      FROM   OKL_CURE_REPORTS
      WHERE approval_status='COMPLETE';

Line: 62

	SELECT OKL_CURE_WF_S.nextval
	FROM  dual;

Line: 82

      l_parameter_list.DELETE;

Line: 121

	SELECT REPORT_NUMBER,REPORT_DATE,VENDOR_ID,VENDOR_CONTACT_ID,VENDOR_SITE_ID,CREATED_BY
	FROM OKL_CURE_REPORTS
	WHERE CURE_REPORT_ID=  a_trans_id;

Line: 127

	SELECT VENDOR_NAME
	FROM PO_VENDORS
	WHERE VENDOR_ID = a_vendor_id;

Line: 133

	SELECT ADDRESS_LINE1 || ' '||
               ADDRESS_LINE2 || ' '||
               ADDRESS_LINE3 || ' '||
               CITY          || ' '||
               STATE         || ' '||
               ZIP           || ' '||
               PROVINCE      || ' '||
               COUNTRY AS Address
	FROM PO_VENDOR_SITES_ALL
	WHERE VENDOR_ID = a_vendor_id
	AND VENDOR_SITE_ID = a_vendor_site_id;

Line: 147

	SELECT PREFIX     || ' '||
	       FIRST_NAME || ' '||
	       LAST_NAME AS VENDOR_CONTACT
	FROM PO_VENDOR_CONTACTS
	WHERE  VENDOR_CONTACT_ID = a_vendor_contact_id;

Line: 155

         SELECT b.user_name
         FROM JTF_RS_RESOURCE_EXTNS a,
              JTF_RS_RESOURCE_EXTNS b
         WHERE b.source_id = a.source_mgr_id
         AND   a.user_id
         IN
           (SELECT created_by
    	    FROM OKL_CURE_REPORTS
	        WHERE CURE_REPORT_ID = a_trans_id);

Line: 288

	SELECT REPORT_NUMBER,REPORT_DATE,VENDOR_ID,OBJECT_VERSION_NUMBER
	FROM OKL_CURE_REPORTS
	WHERE CURE_REPORT_ID=  a_trans_id;

Line: 313

       OKL_cure_reports_pub.update_cure_reports(
                             p_api_version => l_api_version
                            ,p_init_msg_list => fnd_api.g_false
                            ,x_return_status => l_return_status
                            ,x_msg_count => l_msg_count
                            ,x_msg_data => l_msg_data
                            ,p_crtv_rec => l_crtv_rec
                            ,x_crtv_rec => lx_crtv_rec);

Line: 377

	SELECT REPORT_NUMBER,REPORT_DATE,VENDOR_ID,OBJECT_VERSION_NUMBER
	FROM OKL_CURE_REPORTS
	WHERE CURE_REPORT_ID=  a_trans_id;

Line: 402

       OKL_cure_reports_pub.update_cure_reports(
                             p_api_version => l_api_version
                            ,p_init_msg_list => fnd_api.g_false
                            ,x_return_status => l_return_status
                            ,x_msg_count => l_msg_count
                            ,x_msg_data => l_msg_data
                            ,p_crtv_rec => l_crtv_rec
                            ,x_crtv_rec => lx_crtv_rec);