APPS.PA_CI_SUPPLIER_UTILS dependencies on PO_HEADERS_ALL

Line 301: FROM po_headers_all po

297:
298: PROCEDURE validate_PO(c_vendor_id number,l_error_msg OUT NOCOPY varchar2) IS
299: cursor cur_po is
300: SELECT po.po_header_id
301: FROM po_headers_all po
302: WHERE po.segment1 = p_po_number
303: AND po.vendor_id = c_vendor_id
304: /* added this condition to cehck Po status is OPEN or APPRVOED */
305: AND NVL(po.closed_code,'XX') NOT in ('FINALLY CLOSED','CLOSED')

Line 353: ,po_headers_all poh

349: ,l_error_msg OUT NOCOPY varchar2) IS
350: cursor cur_po_line is
351: SELECT pol.po_line_id
352: FROM po_lines_all pol
353: ,po_headers_all poh
354: WHERE pol.po_header_id = poh.po_header_id
355: AND poh.po_header_id = c_po_header_id
356: AND pol.line_num = c_po_line_num
357: /* added this condition to cehck Po status is OPEN or APPRVOED */

Line 410: FROM po_headers_all po

406:
407: PROCEDURE Validate_Currency(c_po_header_id number,l_error_msg OUT NOCOPY varchar2) IS
408: cursor cur_po_currency IS
409: SELECT po.currency_code
410: FROM po_headers_all po
411: WHERE po.po_header_id = c_po_header_id
412: AND po.currency_code = p_currency_code;
413:
414: cursor cur_currency is

Line 1989: select start_date, end_date from po_headers_all

1985:
1986: l_budget_update_method varchar2(30);
1987:
1988: cursor get_po_dates(c_po_header_id NUMBER) is
1989: select start_date, end_date from po_headers_all
1990: where po_header_id = c_po_header_id;
1991:
1992: l_po_start_date date;
1993: l_po_end_date date;