DBA Data[Home] [Help]

APPS.ZX_TDS_RATE_DETM_PKG dependencies on AP_SUPPLIER_SITES_ALL

Line 118: c_account_id ap_supplier_sites_all.vendor_id%TYPE) IS

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

Line 124: c_account_id ap_supplier_sites_all.vendor_id%TYPE,

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

Line 125: c_account_site_id ap_supplier_sites_all.vendor_site_id%TYPE) IS

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

Line 127: FROM ap_supplier_sites_all

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