APPS.PA_PROJECT_SEARCH_UTILS SQL Statements

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

Line: 26

      SELECT customer_id
      FROM pa_customers_v
      WHERE upper(customer_name) = upper(p_customer_name) and status = 'A';

Line: 96

       SELECT person_id
       FROM per_all_people_f
       WHERE full_name = p_resource_name
       AND trunc(sysdate) between trunc(effective_start_date) and trunc(effective_end_date);

Line: 102

       SELECT party_id
       FROM pa_party_resource_details_v
       WHERE party_name = p_resource_name
       AND party_type = 'PERSON'   -- Added for Bug 4745885
       AND trunc(sysdate) between trunc(start_date)
       and trunc(nvl(end_date, to_date('31-12-4712', 'DD-MM-YYYY')));

Line: 110

       SELECT employee_id
       FROM fnd_user
       WHERE user_id = FND_GLOBAL.user_id;

Line: 208

       SELECT person_id
       FROM per_all_people_f
       WHERE full_name = p_person_name;

Line: 213

       SELECT employee_id
       FROM fnd_user
       WHERE user_id = FND_GLOBAL.user_id;