APPS.PO_EMPLOYEES_SV SQL Statements

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

Line: 107

        SELECT HR.EMPLOYEE_ID,
               HR.FULL_NAME,
               NVL(HR.LOCATION_ID,0)
        INTO   X_emp_id,
               X_emp_name,
               X_location_id
        FROM   FND_USER FND, PER_EMPLOYEES_CURRENT_X HR
        WHERE  FND.USER_ID = TO_NUMBER(X_user_id)
        AND    FND.EMPLOYEE_ID = HR.EMPLOYEE_ID
        AND    ROWNUM = 1;

Line: 123

    /* if no rows selected
       then user is not an employee
       else user is an employee */

    ELSE

        -- Bug 4664653
        -- Add to_number to x_user_id
         SELECT HR.PERSON_ID,
               HR.FULL_NAME,
               NVL(HR.LOCATION_ID,0)
        INTO   X_emp_id,
               X_emp_name,
               X_location_id
        FROM   FND_USER FND, PER_WORKFORCE_CURRENT_X HR
        WHERE  FND.USER_ID = TO_NUMBER(X_user_id)
        AND    FND.EMPLOYEE_ID = HR.PERSON_ID
        AND    ROWNUM = 1;

Line: 180

            SELECT HR.LOCATION_CODE
	    INTO   X_location_code
            FROM   HR_LOCATIONS HR,
		   ORG_ORGANIZATION_DEFINITIONS OOD
            WHERE  HR.LOCATION_ID = X_location_id
	    AND    HR.INVENTORY_ORGANIZATION_ID = OOD.ORGANIZATION_ID (+) ;

Line: 204

        SELECT 'Y'
        INTO   X_buyer_code
        FROM   PO_AGENTS
        WHERE  agent_id = X_emp_id
        AND    SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE - 1)
                       AND NVL(END_DATE_ACTIVE, SYSDATE + 1);

Line: 310

        SELECT count(*)
        INTO   x_data_exists
        FROM   fnd_user
        WHERE  employee_id = x_person_id
        AND    sysdate < nvl(end_date, sysdate + 1);

Line: 376

        SELECT full_name
        INTO   x_emp_name
        FROM   po_workforce_current_x   --
        WHERE  person_id = x_emp_id;

Line: 411

    sql_str := 'select hr_employees.full_name, hr_employees.employee_id from hr_employees where ';

Line: 530

    X_sql_str := 'select hr_employees.full_name, hr_employees.employee_id from hr_employees where ';

Line: 643

select distinct prf.full_name,prf.effective_start_date
from   per_all_people_f prf
where  prf.person_id = x_person_id
order by prf.effective_start_date desc;