DBA Data[Home] [Help]

APPS.ZX_TDS_RATE_DETM_PKG dependencies on AP_SUPPLIER_SITES_ALL

Line 121: c_account_id ap_supplier_sites_all.vendor_id%TYPE) IS

117:
118: -- bug 7208618
119: --
120: CURSOR get_ap_supplier_csr(
121: c_account_id ap_supplier_sites_all.vendor_id%TYPE) IS
122: SELECT offset_tax_flag
123: FROM ap_suppliers
124: WHERE vendor_id = c_account_id ;
125:

Line 127: c_account_id ap_supplier_sites_all.vendor_id%TYPE,

123: FROM ap_suppliers
124: WHERE vendor_id = c_account_id ;
125:
126: CURSOR get_ap_supplier_site_csr(
127: c_account_id ap_supplier_sites_all.vendor_id%TYPE,
128: c_account_site_id ap_supplier_sites_all.vendor_site_id%TYPE) IS
129: SELECT offset_tax_flag
130: FROM ap_supplier_sites_all
131: WHERE vendor_id = c_account_id

Line 128: c_account_site_id ap_supplier_sites_all.vendor_site_id%TYPE) IS

124: WHERE vendor_id = c_account_id ;
125:
126: CURSOR get_ap_supplier_site_csr(
127: c_account_id ap_supplier_sites_all.vendor_id%TYPE,
128: c_account_site_id ap_supplier_sites_all.vendor_site_id%TYPE) IS
129: SELECT offset_tax_flag
130: FROM ap_supplier_sites_all
131: WHERE vendor_id = c_account_id
132: AND vendor_site_id = c_account_site_id;

Line 130: FROM ap_supplier_sites_all

126: CURSOR get_ap_supplier_site_csr(
127: c_account_id ap_supplier_sites_all.vendor_id%TYPE,
128: c_account_site_id ap_supplier_sites_all.vendor_site_id%TYPE) IS
129: SELECT offset_tax_flag
130: FROM ap_supplier_sites_all
131: WHERE vendor_id = c_account_id
132: AND vendor_site_id = c_account_site_id;
133:
134: l_account_id hz_cust_accounts.cust_account_id%TYPE;