APPS.POA_EDW_SPEND_PKG dependencies on PO_ACTION_HISTORY

Line 288: FROM po_action_history pah

284: BEGIN
285:
286: SELECT max(pah.sequence_num)
287: INTO v_sequence_num
288: FROM po_action_history pah
289: WHERE object_id = p_po_header_id
290: and object_type_code in ('PO', 'PA')
291: and action_code = 'APPROVE';
292:

Line 295: FROM po_action_history pah

291: and action_code = 'APPROVE';
292:
293: SELECT pah.employee_id
294: INTO v_employee_id
295: FROM po_action_history pah
296: WHERE pah.sequence_num = v_sequence_num
297: and pah.object_id = p_po_header_id
298: and pah.object_type_code in ('PO', 'PA')
299: and pah.action_code = 'APPROVE'

Line 359: FROM po_action_history pah

355:
356:
357: SELECT max(pah.action_date)
358: INTO v_approval_date
359: FROM po_action_history pah
360: WHERE pah.object_id = v_req_header_id
361: and pah.object_type_code = 'REQUISITION'
362: and pah.object_sub_type_code = 'PURCHASE'
363: and pah.action_code = 'APPROVE';