DBA Data[Home] [Help]

APPS.PO_LINES_SV dependencies on PO_LINE_LOCATIONS

Line 372: FROM po_line_locations pll

368: -- If it does, put a message on the stack
369: --
370: SELECT MAX('N')
371: INTO X_allow_delete
372: FROM po_line_locations pll
373: WHERE pll.po_line_id = X_po_line_id
374: AND pll.approved_flag IN ('Y','R');
375:
376: IF (X_allow_delete is NULL) THEN

Line 466: FROM po_line_locations pll

462: ** If it does, display message and prevent deletion.
463: */
464: SELECT MAX('N')
465: INTO X_allow_delete
466: FROM po_line_locations pll
467: WHERE pll.po_line_id = X_po_line_id
468: AND pll.approved_flag IN ('Y','R');
469:
470: IF (X_allow_delete is NULL) THEN