DBA Data[Home] [Help]

APPS.AP_CHECKS_PKG dependencies on FND_TERRITORIES

Line 141: l_Address_Style fnd_territories.address_style%type;

137: l_Address_Line1 hz_locations.address1%type;
138: l_Address_Line2 hz_locations.address2%type;
139: l_Address_Line3 hz_locations.address3%type;
140: l_Address_Line4 hz_locations.address4%type;
141: l_Address_Style fnd_territories.address_style%type;
142: l_City hz_locations.city%type;
143: l_County hz_locations.county%type;
144: l_State hz_locations.state%type;
145: l_Province hz_locations.province%type;

Line 187: fnd_territories_tl ft,

183: , l_Zip
184: , l_Country
185: FROM ap_supplier_sites a,
186: hz_locations hzl ,
187: fnd_territories_tl ft,
188: FND_TERRITORIES B
189: WHERE a.pay_site_flag = 'Y'
190: AND a.vendor_id = X_Remit_To_Supplier_Id
191: AND a.vendor_site_id = X_Remit_To_Supplier_Site_Id

Line 188: FND_TERRITORIES B

184: , l_Country
185: FROM ap_supplier_sites a,
186: hz_locations hzl ,
187: fnd_territories_tl ft,
188: FND_TERRITORIES B
189: WHERE a.pay_site_flag = 'Y'
190: AND a.vendor_id = X_Remit_To_Supplier_Id
191: AND a.vendor_site_id = X_Remit_To_Supplier_Site_Id
192: AND a.location_id = hzl.location_id