APPS.PO_CHG_REQUEST_PVT dependencies on PO_ACCEPTANCES

Line 255: FROM po_acceptances

251: */
252: if p_po_release_id is null then
253: SELECT ACCEPTED_FLAG
254: INTO l_accepted_flag
255: FROM po_acceptances
256: WHERE po_header_id = p_po_header_id
257: AND REVISION_NUM = p_revision_num
258: AND PO_LINE_LOCATION_ID IS NULL
259: AND ACCEPTING_PARTY='S';

Line 263: FROM po_acceptances

259: AND ACCEPTING_PARTY='S';
260: ELSE
261: SELECT ACCEPTED_FLAG
262: INTO l_accepted_flag
263: FROM po_acceptances
264: WHERE po_release_id = p_po_release_id
265: AND REVISION_NUM = p_revision_num
266: AND PO_LINE_LOCATION_ID IS NULL
267: AND ACCEPTING_PARTY='S';

Line 2223: from po_acceptances

2219:
2220: if ( x_ack_stat in ('REJECTED','ACCEPTED')) then
2221: begin
2222: select note into x_note
2223: from po_acceptances
2224: where po_line_location_id=p_line_location_id and
2225: revision_num = x_revision;
2226: exception
2227: when others then

Line 2287: from po_acceptances

2283:
2284: if ( x_ack_stat = 'REJECTED') then
2285: begin
2286: select note into x_note
2287: from po_acceptances
2288: where po_line_location_id=p_line_location_id and
2289: revision_num = x_revision;
2290: exception
2291: when others then