APPS.AP_PAY_SINGLE_INVOICE_PKG dependencies on AP_SUPPLIER_SITES_ALL

Line 92: l_active_pay_sites ap_supplier_sites_all.pay_site_flag%TYPE;

88: l_dummy_rowid VARCHAR2(18);
89: l_seq_num_profile VARCHAR2(80);
90:
91: l_hold_all_payments_flag ap_suppliers.hold_all_payments_flag%TYPE;
92: l_active_pay_sites ap_supplier_sites_all.pay_site_flag%TYPE;
93: l_accounting_event_id NUMBER(38);
94: l_quick_check_id AP_CHECKS.checkrun_name%type;
95: l_next_check_number AP_CHECKS.check_number%type;
96: l_check_number AP_CHECKS.check_number%type;

Line 190: ,Vendor_site_code AP_SUPPLIER_SITES_ALL.Vendor_Site_Code%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
194: ,Address_Line4 HZ_LOCATIONS.Address4%TYPE

Line 198: ,Vendor_Site_Id AP_SUPPLIER_SITES_ALL.Vendor_Site_ID%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
201: );
202:

Line 199: ,Pay_Site_Flag AP_SUPPLIER_SITES_ALL.Pay_Site_Flag%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
201: );
202:
203: TYPE r_vendor_info IS RECORD

Line 200: ,Primary_Pay_Site AP_SUPPLIER_SITES_ALL.Primary_Pay_Site_Flag%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
201: );
202:
203: TYPE r_vendor_info IS RECORD
204: (

Line 614: ap_supplier_sites_all assp

610: INTO l_hold_all_payments_flag,
611: l_active_pay_sites,
612: l_vendor_type_lookup_code
613: FROM ap_suppliers asup,
614: ap_supplier_sites_all assp
615: WHERE asup.vendor_id = l_inv_rec.vendor_id
616: AND asup.vendor_id = assp.vendor_id
617: AND assp.vendor_site_id = l_inv_rec.vendor_site_id;
618:

Line 660: FROM ap_supplier_sites_all asus,

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

Line 706: FROM ap_supplier_sites_all asus,

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

Line 753: FROM ap_supplier_sites_all asus,

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