APPS.POS_SPM_WF_PKG1 dependencies on FND_TERRITORIES

Line 1245: FROM ap_supplier_sites_all pvsa, fnd_territories ft

1241: l_user_name_rec l_user_name_cur%ROWTYPE;
1242:
1243: CURSOR l_cur IS
1244: SELECT pvsa.email_address, ft.nls_territory, pvsa.language
1245: FROM ap_supplier_sites_all pvsa, fnd_territories ft
1246: WHERE pvsa.email_address IS NOT NULL
1247: AND pvsa.vendor_id = p_vendor_id
1248: AND (pvsa.inactive_date IS NULL OR pvsa.inactive_date IS NOT NULL AND pvsa.inactive_date > Sysdate)
1249: AND pvsa.country = ft.territory_code (+);