APPS.ZX_TDS_TAX_ROUNDING_PKG dependencies on AP_SUPPLIER_SITES_ALL

Line 7762: FROM ap_supplier_sites_all povs

7758: 'L','LINE',
7759: 'H','HEADER',
7760: 'T','HEADER',
7761: NULL) tax_rounding_level
7762: FROM ap_supplier_sites_all povs
7763: WHERE povs.vendor_id = c_account_id
7764: AND povs.vendor_site_id = c_account_site_id;
7765:
7766: l_ap_tax_rounding_rule VARCHAR2(10);

Line 7767: l_auto_tax_calc_flag ap_supplier_sites_all.auto_tax_calc_flag%TYPE;

7763: WHERE povs.vendor_id = c_account_id
7764: AND povs.vendor_site_id = c_account_site_id;
7765:
7766: l_ap_tax_rounding_rule VARCHAR2(10);
7767: l_auto_tax_calc_flag ap_supplier_sites_all.auto_tax_calc_flag%TYPE;
7768: l_vat_code ap_supplier_sites_all.vat_code%TYPE;
7769: l_vat_registration_num ap_supplier_sites_all.vat_registration_num%TYPE;
7770: l_tax_rounding_level VARCHAR2(10);
7771:

Line 7768: l_vat_code ap_supplier_sites_all.vat_code%TYPE;

7764: AND povs.vendor_site_id = c_account_site_id;
7765:
7766: l_ap_tax_rounding_rule VARCHAR2(10);
7767: l_auto_tax_calc_flag ap_supplier_sites_all.auto_tax_calc_flag%TYPE;
7768: l_vat_code ap_supplier_sites_all.vat_code%TYPE;
7769: l_vat_registration_num ap_supplier_sites_all.vat_registration_num%TYPE;
7770: l_tax_rounding_level VARCHAR2(10);
7771:
7772: BEGIN

Line 7769: l_vat_registration_num ap_supplier_sites_all.vat_registration_num%TYPE;

7765:
7766: l_ap_tax_rounding_rule VARCHAR2(10);
7767: l_auto_tax_calc_flag ap_supplier_sites_all.auto_tax_calc_flag%TYPE;
7768: l_vat_code ap_supplier_sites_all.vat_code%TYPE;
7769: l_vat_registration_num ap_supplier_sites_all.vat_registration_num%TYPE;
7770: l_tax_rounding_level VARCHAR2(10);
7771:
7772: BEGIN
7773: IF (g_level_procedure >= g_current_runtime_level ) THEN