APPS.PO_APPROVE_SV dependencies on PO_CHANGE_REQUESTS

Line 312: from po_change_requests

308: -- SQL Why: Need to concatenate these reasons to default
309: -- field change summary
310: -- SQL Join: po_header_id
311: select response_reason
312: from po_change_requests
313: where document_header_id = p_po_header_id
314: -- Bug 3711787
315: and change_active_flag = 'Y'
316: -- Bug 3326904

Line 326: from po_change_requests

322: -- SQL Why: Need to concatenate these reasons to default
323: -- field change summary
324: -- SQL Join: po_release_id
325: select response_reason
326: from po_change_requests
327: where po_release_id = p_po_release_id
328: -- Bug 3711787
329: and change_active_flag = 'Y';
330: -- Bug 3326904

Line 335: l_additional_changes PO_CHANGE_REQUESTS.additional_changes%TYPE := NULL;

331: -- and request_status = 'BUYER_APP';
332:
333: l_progress Varchar2(3);
334: l_reasons dbms_sql.varchar2_table;
335: l_additional_changes PO_CHANGE_REQUESTS.additional_changes%TYPE := NULL;
336: BEGIN
337:
338: l_progress := '000';
339: x_change_summary := '';