APPS.POA_EDW_SPEND_PKG dependencies on PO_ACCEPTANCES

Line 318: FROM po_acceptances pac

314:
315: IF (p_type = 'P') THEN
316: SELECT max(pac.action_date)
317: INTO v_accept_date
318: FROM po_acceptances pac
319: WHERE pac.po_header_id = p_doc_id
320: and pac.accepted_flag = 'Y';
321: ELSE
322: SELECT max(pac.action_date)

Line 324: FROM po_acceptances pac

320: and pac.accepted_flag = 'Y';
321: ELSE
322: SELECT max(pac.action_date)
323: INTO v_accept_date
324: FROM po_acceptances pac
325: WHERE pac.po_release_id = p_doc_id
326: and pac.accepted_flag = 'Y';
327:
328: END IF;