DBA Data[Home] [Help]

APPS.PO_HEADERS_SV4 dependencies on PO_LINES_ALL

Line 342: l_price_break_lookup_code PO_LINES_ALL.price_break_lookup_code%TYPE;

338: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
339: )
340: RETURN BOOLEAN
341: IS
342: l_price_break_lookup_code PO_LINES_ALL.price_break_lookup_code%TYPE;
343:
344: CURSOR l_cumulative_csr IS SELECT price_break_lookup_code
345: FROM po_lines_all
346: WHERE po_header_id = p_po_header_id;

Line 345: FROM po_lines_all

341: IS
342: l_price_break_lookup_code PO_LINES_ALL.price_break_lookup_code%TYPE;
343:
344: CURSOR l_cumulative_csr IS SELECT price_break_lookup_code
345: FROM po_lines_all
346: WHERE po_header_id = p_po_header_id;
347: BEGIN
348:
349: OPEN l_cumulative_csr;

Line 384: FROM po_lines_all

380: RETURN BOOLEAN
381: IS
382: CURSOR l_reference_csr IS
383: SELECT from_header_id, from_line_id
384: FROM po_lines_all
385: WHERE po_header_id = p_po_header_id;
386:
387: l_from_header_id PO_LINES_ALL.from_header_id%TYPE;
388: l_from_line_id PO_LINES_ALL.from_line_id%TYPE;

Line 387: l_from_header_id PO_LINES_ALL.from_header_id%TYPE;

383: SELECT from_header_id, from_line_id
384: FROM po_lines_all
385: WHERE po_header_id = p_po_header_id;
386:
387: l_from_header_id PO_LINES_ALL.from_header_id%TYPE;
388: l_from_line_id PO_LINES_ALL.from_line_id%TYPE;
389:
390: BEGIN
391:

Line 388: l_from_line_id PO_LINES_ALL.from_line_id%TYPE;

384: FROM po_lines_all
385: WHERE po_header_id = p_po_header_id;
386:
387: l_from_header_id PO_LINES_ALL.from_header_id%TYPE;
388: l_from_line_id PO_LINES_ALL.from_line_id%TYPE;
389:
390: BEGIN
391:
392: OPEN l_reference_csr;