APPS.PO_CORE_S3 dependencies on PO_LINES_ALL

Line 499: FROM po_lines_all

495: SELECT clm_payment_instr_code,
496: po_line_id
497: BULK COLLECT INTO l_payment_instr_code_tbl,
498: l_po_line_id_tbl
499: FROM po_lines_all
500: WHERE po_header_id = p_po_header_id;
501:
502: honour_at_line_level := TRUE;
503:

Line 509: UPDATE po_lines_all pol

505:
506:
507: IF honour_at_line_level = FALSE THEN -- Honour paymnet instr code from headers level
508: -- Clear out if any payment instruction left at line level due to revert functionality.
509: UPDATE po_lines_all pol
510: SET pol.clm_payment_instr_code = NULL
511: WHERE pol.po_header_id = p_po_header_id;
512: -- Call PI geenration code only for automatic instructions.
513: IF ( l_payment_instr_code <> 'KO_SPECIFIED' AND