DBA Data[Home] [Help]

APPS.DPP_MIG_ADJ_PARA_APPROVAL_PVT dependencies on AP_SUPPLIER_SITES_ALL

Line 182: from ap_suppliers aps, ap_supplier_sites_all apss, hr_operating_units hr

178: CURSOR supplier_details_cur(p_vendor_id IN NUMBER, p_vendor_site_id IN NUMBER, p_org_id IN NUMBER)
179: IS
180: select aps.vendor_id, aps.vendor_name, apss.vendor_site_id, apss.vendor_site_code,
181: apss.org_id, hr.name
182: from ap_suppliers aps, ap_supplier_sites_all apss, hr_operating_units hr
183: where aps.vendor_id = p_vendor_id
184: and aps.vendor_id = apss.vendor_id
185: and apss.vendor_site_id = p_vendor_site_id
186: and apss.org_id = p_org_id