APPS.PA_DCTN_APRV_NOTIFICATION SQL Statements

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

Line: 16

      SELECT  user_name
        FROM  FND_USER
        WHERE user_id = l_starter_user_id;

Line: 21

      SELECT  e.first_name||' '||e.last_name
        FROM  FND_USER f, PER_ALL_PEOPLE_F e
        WHERE f.user_id = l_starter_user_id
        AND   f.employee_id = e.person_id
        AND   e.effective_end_date = ( SELECT MAX(papf.effective_end_date)
                                       FROM per_all_people_f papf
                                       WHERE papf.person_id = e.person_id);

Line: 29

      SELECT SYSDATE FROM SYS.DUAL;

Line: 32

         SELECT pov.vendor_name Vendor_Name
         FROM   PO_VENDORS pov
	     WHERE  pov.vendor_id = c_vendor_id;

Line: 78

    SELECT pa_workflow_itemkey_s.nextval
    INTO   itemkey
    FROM   DUAL;

Line: 256

        PA_WORKFLOW_UTILS.Insert_WF_Processes (p_wf_type_code  => 'PADCTNWF'
                                              ,p_item_type     => ItemType
                                              ,p_item_key      => ItemKey
                                              ,p_entity_key1   => c_dctn_hdr_rec.deduction_req_id
                                              ,p_description   => c_dctn_hdr_rec.description
                                              ,p_err_code      => l_err_code
                                              ,p_err_stage     => l_err_stage
                                              ,p_err_stack     => l_err_stack
                                              );

Line: 294

      SELECT  name organization_name
        FROM  HR_ORGANIZATION_UNITS
        WHERE organization_id = p_carrying_out_organization_id;

Line: 299

         SELECT pov.vendor_name Vendor_Name,
                povs.vendor_site_code Vendor_Site
         FROM   PO_VENDORS pov,
                PO_VENDOR_SITES_ALL povs
	     WHERE  pov.vendor_id = povs.vendor_id
		 AND    pov.vendor_id = c_vendor_id
		 AND    povs.vendor_site_id = c_vendor_site_id;

Line: 308

        SELECT description
        FROM   PA_CONTROL_ITEMS
        WHERE  ci_id = p_dctn_hdr_rec.ci_id;

Line: 367

        SELECT  page_content
          INTO  l_clob
          FROM  PA_PAGE_CONTENTS
          WHERE page_content_id = l_page_content_id FOR UPDATE NOWAIT;

Line: 639

  PROCEDURE Select_Project_Manager (itemtype    IN VARCHAR2
                                   ,itemkey     IN VARCHAR2
                                   ,actid       IN NUMBER
                                   ,funcmode    IN VARCHAR2
                                   ,resultout   OUT NOCOPY VARCHAR2)
  IS

  l_err_code                  NUMBER := 0;

Line: 684

      PA_CE_AR_NOTIFY_WF.Select_Project_Manager (p_project_id               => l_project_id
                                                ,p_project_manager_id       => l_manager_employee_id
                                                ,p_return_status            => l_return_status);

Line: 734

          WF_CORE.CONTEXT('PA_PWP_NOTIFICATION','SELECT_PROJECT_MANAGER',itemtype, itemkey, to_char(actid), funcmode);

Line: 738

          WF_CORE.CONTEXT('PA_PWP_NOTIFICATION','SELECT_PROJECT_MANAGER',itemtype, itemkey, to_char(actid), funcmode);

Line: 742

          WF_CORE.CONTEXT('PA_PWP_NOTIFICATION','SELECT_PROJECT_MANAGER',itemtype, itemkey, to_char(actid), funcmode);

Line: 744

  END Select_Project_Manager;

Line: 755

   SELECT  page_content
     FROM  PA_PAGE_CONTENTS
     WHERE page_content_id = document_id
     AND   object_type = 'PA_DCTN_APRV_NOTIFY'
     AND   pk2_value IS NULL;

Line: 849

       SELECT * FROM PA_DEDUCTIONS_ALL WHERE deduction_req_num = c_dctn_req_num;