DBA Data[Home] [Help]

APPS.PO_LINES_SV dependencies on PO_LINE_LOCATIONS

Line 412: FROM po_line_locations pll

408: -- If it does, put a message on the stack
409: --
410: SELECT MAX('N')
411: INTO X_allow_delete
412: FROM po_line_locations pll
413: WHERE pll.po_line_id = X_po_line_id
414: AND pll.approved_flag IN ('Y','R');
415:
416: IF (X_allow_delete is NULL) THEN

Line 506: FROM po_line_locations pll

502: ** If it does, display message and prevent deletion.
503: */
504: SELECT MAX('N')
505: INTO X_allow_delete
506: FROM po_line_locations pll
507: WHERE pll.po_line_id = X_po_line_id
508: AND pll.approved_flag IN ('Y','R');
509:
510: IF (X_allow_delete is NULL) THEN