APPS.PO_COMPLEX_WORK_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 708: l_advance_amount PO_LINE_LOCATIONS_ALL.amount%TYPE;

704:
705: d_module VARCHAR2(70) := 'po.plsql.PO_COMPLEX_WORK_PVT.get_advance_amount';
706: d_progress NUMBER;
707:
708: l_advance_amount PO_LINE_LOCATIONS_ALL.amount%TYPE;
709:
710: BEGIN
711:
712: d_progress := 0;

Line 726: FROM po_line_locations_all poll

722: d_progress := 20;
723:
724: SELECT poll.amount
725: INTO l_advance_amount
726: FROM po_line_locations_all poll
727: WHERE poll.po_line_id = p_po_line_id
728: AND poll.payment_type = 'ADVANCE';
729:
730: ELSE