APPS.PO_CHORD_WF1 dependencies on PO_ACCEPTANCES

Line 617: FROM PO_ACCEPTANCES PA

613: -- SQL Why: Need the value for routing to reapproval
614: -- if there is a change
615: SELECT DISTINCT 'Y'
616: INTO x_header_control.po_acknowledged
617: FROM PO_ACCEPTANCES PA
618: WHERE PA.po_header_id = x_po_header_id;
619: EXCEPTION
620: WHEN NO_DATA_FOUND THEN
621: x_header_control.po_acknowledged:='N';

Line 630: FROM PO_ACCEPTANCES PA

626: -- SQL Why: Need the value for routing to reapproval
627: -- if there is a change
628: SELECT DISTINCT 'Y'
629: INTO x_header_control.po_accepted
630: FROM PO_ACCEPTANCES PA
631: WHERE PA.po_header_id = x_po_header_id
632: AND PA.accepted_flag = 'Y';
633: EXCEPTION
634: WHEN NO_DATA_FOUND THEN