X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fsearch%2Funprovisioned_services.html;h=a7791ba867100fdeb8c28810e460c857a6e4e032;hb=8572f2347f879d414a60e8e0dc111fa927d66c14;hp=f85e4fb19ddb89bc4615307509f163a476d159c1;hpb=ce6cc16ab448ec7bf2fe2d493985bcbd324eabaf;p=freeside.git

diff --git a/httemplate/search/unprovisioned_services.html b/httemplate/search/unprovisioned_services.html
index f85e4fb19..a7791ba86 100644
--- a/httemplate/search/unprovisioned_services.html
+++ b/httemplate/search/unprovisioned_services.html
@@ -1,4 +1,4 @@
-<% include( 'elements/search.html',
+<& elements/search.html,
               'title'         => 'Unprovisioned Service Search Results',
               'name' => 'packages with unprovisioned services',
               'query'         => {
@@ -54,8 +54,8 @@
 			      '',
                               FS::UI::Web::cust_styles(),
 			    ],
-      )
-%>
+      
+&>
 <%init>
 
 die "access denied"
@@ -74,7 +74,8 @@ my $search = " where cust_pkg.cancel is null and pkg_svc.quantity > 0 and "
 	    . " cust_svc.pkgnum = cust_pkg.pkgnum and "
 	    . " cust_svc.svcpart = pkg_svc.svcpart) $svcpart_limit";
 
-my $addl_from = " join pkg_svc using (pkgpart) join cust_main using (custnum) ";
+my $addl_from = " join pkg_svc using (pkgpart) ".
+            FS::UI::Web::join_cust_main('cust_pkg', 'cust_pkg');
 
 # this was very painful to derive but it appears correct
 #select cust_pkg.custnum,cust_pkg.pkgpart,cust_pkg.pkgnum, pkg_svc.svcpart from cust_pkg join