APPS.PA_BL_UTILS SQL Statements

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

Line: 31

       SELECT TO_NUMBER(system_reference1)
       INTO v_vendor_id
       FROM pa_cost_distribution_lines_all
       WHERE expenditure_item_id = v_expenditure_item_id
       AND   line_num = 1;

Line: 38

          SELECT vendor_name
          INTO v_vendor_name
          FROM po_vendors
          WHERE vendor_id = v_vendor_id;

Line: 51

       SELECT full_name
       INTO v_emp_name
       FROM per_people_f
       WHERE v_person_id = person_id
       AND   v_creation_date BETWEEN effective_start_date
             AND NVL(effective_end_date, v_creation_date)
       AND   ROWNUM < 2;

Line: 102

  SELECT name
  INTO v_org_name
  FROM hr_all_organization_units_tl
  WHERE organization_id = v_org_id
  AND   decode(organization_id, null, '1', language)
         = decode(organization_id, null, '1', userenv('lang'));