APPS.PO_LINE_LOCATIONS_AP_PKG SQL Statements

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

Line: 15

         SELECT MAX(transaction_date)
         INTO   last_receipt_date
         FROM   rcv_transactions
         WHERE  po_line_location_id = l_line_location_id
         AND    transaction_type = 'RECEIVE';

Line: 41

         SELECT HE.full_name
         FROM   hr_employees     HE,
		po_distributions PD
         WHERE  PD.line_location_id = l_line_location_id
	 AND    PD.deliver_to_person_id = HE.employee_id;

Line: 94

	 SELECT count(*)
	 INTO   num_distributions
	 FROM   po_distributions PD
	 WHERE  PD.line_location_id = l_line_location_id;