APPS.PO_AUTO_LINE_PROCESS_PVT dependencies on PO_VENDOR_SITES_ALL

Line 1673: l_retainage_rate PO_VENDOR_SITES_ALL.retainage_rate%type;

1669: l_ga_uom PO_LINES.unit_meas_lookup_code%TYPE;
1670: l_quantity_in_ga_uom PO_LINES_INTERFACE.quantity%TYPE;
1671: l_conversion_rate NUMBER :=1;
1672: l_outsourced_assembly po_line_locations_all.outsourced_assembly%type;
1673: l_retainage_rate PO_VENDOR_SITES_ALL.retainage_rate%type;
1674: --
1675: l_job_long_description PO_REQUISITION_LINES_ALL.job_long_description%TYPE;
1676: l_who_rec PO_NEGOTIATIONS_SV2.who_rec_type;
1677: l_return_status VARCHAR2(1);

Line 2799: FROM po_vendor_sites_all

2795: IF(p_lines.hd_vendor_site_id_tbl(i) IS NOT NULL)THEN
2796: l_progress := '490';
2797: SELECT retainage_rate
2798: INTO l_retainage_rate
2799: FROM po_vendor_sites_all
2800: WHERE vendor_site_id = p_lines.hd_vendor_site_id_tbl(i);
2801: END IF;
2802:
2803: l_progress := '500';