APPS.AP_NOTES_PVT SQL Statements

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

Line: 41

   )IS SELECT employee_id
       ,      customer_id
       ,      supplier_id
       ,      description
       ,      user_name
       FROM fnd_user
       WHERE user_id = b_user_id;

Line: 55

   )IS SELECT full_name
       ,      employee_number
       FROM per_people_x -- Bug 4730292/4890523
       WHERE person_id = b_employee_id;

Line: 66

   )IS SELECT party_name
       ,      party_number
       FROM hz_parties
       WHERE party_id = b_party_id;

Line: 164

	SELECT approval_type INTO l_approval_type
        FROM AP_EXPENSE_REPORT_HEADERS_ALL
        WHERE report_header_id = p_source_object_id;

Line: 170

		SELECT display_name
		   INTO l_display_name
		   FROM wf_roles
		  WHERE orig_system = l_approval_type
		AND orig_system_id  = p_user_id
		AND rownum = 1;