APPS.PO_RFQS_SV dependencies on PO_HEADERS

Line 65: FROM po_headers poh

61: ** if it is, display message and prevent deletion.
62: */
63: SELECT MAX('N')
64: INTO X_delete_test
65: FROM po_headers poh
66: WHERE from_header_id = X_po_header_id;
67:
68: x_progress := '040';
69:

Line 271: FROM po_headers

267: X_progress := '010';
268:
269: SELECT MAX('N')
270: INTO X_allow_update
271: FROM po_headers
272: WHERE from_header_id = X_po_header_id
273: AND vendor_id = X_vendor_id
274: AND vendor_site_id = X_vendor_site_id
275: AND from_type_lookup_code = 'RFQ'

Line 319: CURSOR C2 IS SELECT po_headers_s.nextval FROM sys.dual;

315: CURSOR C IS SELECT rowid FROM PO_RFQ_VENDORS
316: WHERE po_header_id = X_po_header_id
317: AND sequence_num = X_max_sequence_num + 1;
318:
319: CURSOR C2 IS SELECT po_headers_s.nextval FROM sys.dual;
320:
321: /* Bug # 6161855 */
322: l_list_header_id NUMBER := X_list_header_id;
323: CURSOR C3 IS SELECT vendor_id FROM po_vendor_list_entries WHERE vendor_list_header_id= l_list_header_id ;