APPS.PO_INTERFACE_S dependencies on PO_VENDOR_SITES_ALL

Line 2820: l_retainage_rate PO_VENDOR_SITES_ALL.retainage_rate%type; --bug#5255878

2816: l_interface_line_id_tbl interface_line_id_tbl;
2817: --
2818:
2819: l_outsourced_assembly po_line_locations_all.outsourced_assembly%type; --
2820: l_retainage_rate PO_VENDOR_SITES_ALL.retainage_rate%type; --bug#5255878
2821: BEGIN
2822: l_outsourced_assembly :=2; --
2823: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >
2824: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);

Line 3952: FROM po_vendor_sites_all

3948: -- vendor_site_id is not null.
3949: IF(interface.vendor_site_id is not null)THEN
3950: SELECT retainage_rate
3951: into l_retainage_rate
3952: FROM po_vendor_sites_all
3953: WHERE vendor_site_id = interface.vendor_site_id;
3954: END IF;
3955: -- bug 4887900 END
3956:

Line 7790: FROM po_vendor_sites_all --

7786: l_progress := '010';
7787: /* Retrieve Invoice Match Option from Vendor site*/
7788: SELECT match_option
7789: INTO x_invoice_match_option
7790: FROM po_vendor_sites_all --
7791: WHERE vendor_site_id = X_vendor_site_id;
7792: end if;
7793:
7794: if(x_invoice_match_option is NULL) then