APPS.PO_COMPLEX_WORK_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 889: l_advance_amount PO_LINE_LOCATIONS_ALL.amount%TYPE;

885:
886: d_module VARCHAR2(70) := 'po.plsql.PO_COMPLEX_WORK_PVT.get_advance_amount';
887: d_progress NUMBER;
888:
889: l_advance_amount PO_LINE_LOCATIONS_ALL.amount%TYPE;
890:
891: BEGIN
892:
893: d_progress := 0;

Line 907: FROM po_line_locations_all poll

903: d_progress := 20;
904:
905: SELECT poll.amount
906: INTO l_advance_amount
907: FROM po_line_locations_all poll
908: WHERE poll.po_line_id = p_po_line_id
909: AND poll.payment_type = 'ADVANCE';
910:
911: ELSE