APPS.AP_PAY_SINGLE_INVOICE_PKG dependencies on HZ_LOCATIONS

Line 185: Address_Line1 HZ_LOCATIONS.Address1%TYPE

181: );
182:
183: TYPE r_ap_ven_sites_info IS RECORD
184: (
185: Address_Line1 HZ_LOCATIONS.Address1%TYPE
186: ,Address_Line2 HZ_LOCATIONS.Address2%TYPE
187: ,Address_Line3 HZ_LOCATIONS.Address3%TYPE
188: ,City HZ_LOCATIONS.City%TYPE
189: ,country HZ_LOCATIONS.Country%TYPE

Line 186: ,Address_Line2 HZ_LOCATIONS.Address2%TYPE

182:
183: TYPE r_ap_ven_sites_info IS RECORD
184: (
185: Address_Line1 HZ_LOCATIONS.Address1%TYPE
186: ,Address_Line2 HZ_LOCATIONS.Address2%TYPE
187: ,Address_Line3 HZ_LOCATIONS.Address3%TYPE
188: ,City HZ_LOCATIONS.City%TYPE
189: ,country HZ_LOCATIONS.Country%TYPE
190: ,Vendor_site_code AP_SUPPLIER_SITES_ALL.Vendor_Site_Code%TYPE

Line 187: ,Address_Line3 HZ_LOCATIONS.Address3%TYPE

183: TYPE r_ap_ven_sites_info IS RECORD
184: (
185: Address_Line1 HZ_LOCATIONS.Address1%TYPE
186: ,Address_Line2 HZ_LOCATIONS.Address2%TYPE
187: ,Address_Line3 HZ_LOCATIONS.Address3%TYPE
188: ,City HZ_LOCATIONS.City%TYPE
189: ,country HZ_LOCATIONS.Country%TYPE
190: ,Vendor_site_code AP_SUPPLIER_SITES_ALL.Vendor_Site_Code%TYPE
191: ,Zip HZ_LOCATIONS.Postal_Code%TYPE

Line 188: ,City HZ_LOCATIONS.City%TYPE

184: (
185: Address_Line1 HZ_LOCATIONS.Address1%TYPE
186: ,Address_Line2 HZ_LOCATIONS.Address2%TYPE
187: ,Address_Line3 HZ_LOCATIONS.Address3%TYPE
188: ,City HZ_LOCATIONS.City%TYPE
189: ,country HZ_LOCATIONS.Country%TYPE
190: ,Vendor_site_code AP_SUPPLIER_SITES_ALL.Vendor_Site_Code%TYPE
191: ,Zip HZ_LOCATIONS.Postal_Code%TYPE
192: ,Province HZ_LOCATIONS.Province%TYPE

Line 189: ,country HZ_LOCATIONS.Country%TYPE

185: Address_Line1 HZ_LOCATIONS.Address1%TYPE
186: ,Address_Line2 HZ_LOCATIONS.Address2%TYPE
187: ,Address_Line3 HZ_LOCATIONS.Address3%TYPE
188: ,City HZ_LOCATIONS.City%TYPE
189: ,country HZ_LOCATIONS.Country%TYPE
190: ,Vendor_site_code AP_SUPPLIER_SITES_ALL.Vendor_Site_Code%TYPE
191: ,Zip HZ_LOCATIONS.Postal_Code%TYPE
192: ,Province HZ_LOCATIONS.Province%TYPE
193: ,State HZ_LOCATIONS.State%TYPE

Line 191: ,Zip HZ_LOCATIONS.Postal_Code%TYPE

187: ,Address_Line3 HZ_LOCATIONS.Address3%TYPE
188: ,City HZ_LOCATIONS.City%TYPE
189: ,country HZ_LOCATIONS.Country%TYPE
190: ,Vendor_site_code AP_SUPPLIER_SITES_ALL.Vendor_Site_Code%TYPE
191: ,Zip HZ_LOCATIONS.Postal_Code%TYPE
192: ,Province HZ_LOCATIONS.Province%TYPE
193: ,State HZ_LOCATIONS.State%TYPE
194: ,Address_Line4 HZ_LOCATIONS.Address4%TYPE
195: ,County HZ_LOCATIONS.Country%TYPE

Line 192: ,Province HZ_LOCATIONS.Province%TYPE

188: ,City HZ_LOCATIONS.City%TYPE
189: ,country HZ_LOCATIONS.Country%TYPE
190: ,Vendor_site_code AP_SUPPLIER_SITES_ALL.Vendor_Site_Code%TYPE
191: ,Zip HZ_LOCATIONS.Postal_Code%TYPE
192: ,Province HZ_LOCATIONS.Province%TYPE
193: ,State HZ_LOCATIONS.State%TYPE
194: ,Address_Line4 HZ_LOCATIONS.Address4%TYPE
195: ,County HZ_LOCATIONS.Country%TYPE
196: ,Address_Style HZ_LOCATIONS.Address_Style%TYPE

Line 193: ,State HZ_LOCATIONS.State%TYPE

189: ,country HZ_LOCATIONS.Country%TYPE
190: ,Vendor_site_code AP_SUPPLIER_SITES_ALL.Vendor_Site_Code%TYPE
191: ,Zip HZ_LOCATIONS.Postal_Code%TYPE
192: ,Province HZ_LOCATIONS.Province%TYPE
193: ,State HZ_LOCATIONS.State%TYPE
194: ,Address_Line4 HZ_LOCATIONS.Address4%TYPE
195: ,County HZ_LOCATIONS.Country%TYPE
196: ,Address_Style HZ_LOCATIONS.Address_Style%TYPE
197: ,Vendor_Id AP_SUPPLIERS.Vendor_ID%TYPE

Line 194: ,Address_Line4 HZ_LOCATIONS.Address4%TYPE

190: ,Vendor_site_code AP_SUPPLIER_SITES_ALL.Vendor_Site_Code%TYPE
191: ,Zip HZ_LOCATIONS.Postal_Code%TYPE
192: ,Province HZ_LOCATIONS.Province%TYPE
193: ,State HZ_LOCATIONS.State%TYPE
194: ,Address_Line4 HZ_LOCATIONS.Address4%TYPE
195: ,County HZ_LOCATIONS.Country%TYPE
196: ,Address_Style HZ_LOCATIONS.Address_Style%TYPE
197: ,Vendor_Id AP_SUPPLIERS.Vendor_ID%TYPE
198: ,Vendor_Site_Id AP_SUPPLIER_SITES_ALL.Vendor_Site_ID%TYPE

Line 195: ,County HZ_LOCATIONS.Country%TYPE

191: ,Zip HZ_LOCATIONS.Postal_Code%TYPE
192: ,Province HZ_LOCATIONS.Province%TYPE
193: ,State HZ_LOCATIONS.State%TYPE
194: ,Address_Line4 HZ_LOCATIONS.Address4%TYPE
195: ,County HZ_LOCATIONS.Country%TYPE
196: ,Address_Style HZ_LOCATIONS.Address_Style%TYPE
197: ,Vendor_Id AP_SUPPLIERS.Vendor_ID%TYPE
198: ,Vendor_Site_Id AP_SUPPLIER_SITES_ALL.Vendor_Site_ID%TYPE
199: ,Pay_Site_Flag AP_SUPPLIER_SITES_ALL.Pay_Site_Flag%TYPE

Line 196: ,Address_Style HZ_LOCATIONS.Address_Style%TYPE

192: ,Province HZ_LOCATIONS.Province%TYPE
193: ,State HZ_LOCATIONS.State%TYPE
194: ,Address_Line4 HZ_LOCATIONS.Address4%TYPE
195: ,County HZ_LOCATIONS.Country%TYPE
196: ,Address_Style HZ_LOCATIONS.Address_Style%TYPE
197: ,Vendor_Id AP_SUPPLIERS.Vendor_ID%TYPE
198: ,Vendor_Site_Id AP_SUPPLIER_SITES_ALL.Vendor_Site_ID%TYPE
199: ,Pay_Site_Flag AP_SUPPLIER_SITES_ALL.Pay_Site_Flag%TYPE
200: ,Primary_Pay_Site AP_SUPPLIER_SITES_ALL.Primary_Pay_Site_Flag%TYPE

Line 660: hz_locations hzl

656: l_apvs_rec.Vendor_site_code,
657: l_apvs_rec.Pay_Site_Flag,
658: l_apvs_rec.Primary_Pay_Site
659: FROM ap_supplier_sites_all asus,
660: hz_locations hzl
661: WHERE asus.vendor_site_id = l_inv_rec.vendor_site_id
662: AND asus.location_id = hzl.location_id
663: AND nvl(trunc(asus.inactive_date),sysdate+1) > trunc(sysdate);
664:

Line 706: hz_locations hzl

702: l_apvs_rec.Vendor_site_code,
703: l_apvs_rec.Pay_Site_Flag,
704: l_apvs_rec.Primary_Pay_Site
705: FROM ap_supplier_sites_all asus,
706: hz_locations hzl
707: WHERE asus.vendor_site_id = l_inv_rec.vendor_site_id
708: AND asus.location_id = hzl.location_id
709: AND nvl(trunc(asus.inactive_date),sysdate+1)
710: > trunc(sysdate)

Line 753: hz_locations hzl

749: l_apvs_rec.Vendor_site_code,
750: l_apvs_rec.Pay_Site_Flag,
751: l_apvs_rec.Primary_Pay_Site
752: FROM ap_supplier_sites_all asus,
753: hz_locations hzl
754: WHERE asus.vendor_site_id = l_inv_rec.vendor_site_id
755: AND asus.location_id = hzl.location_id
756: AND nvl(trunc(asus.inactive_date),sysdate+1)
757: > trunc(sysdate)