DBA Data[Home] [Help]

APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKL_PROPERTY_TAX_SETUPS

Line 6170: lv_asset_default okl_property_tax_setups.enable_asset_default%TYPE;

6166: AND TRUNC(SYSDATE) BETWEEN NVL(TRUNC(start_date_active), TRUNC(SYSDATE)) AND
6167: NVL(TRUNC(end_date_active), TRUNC(SYSDATE));
6168:
6169: -- Added by rravikir (Fix for Bug 3947959)
6170: lv_asset_default okl_property_tax_setups.enable_asset_default%TYPE;
6171: CURSOR get_est_prop_tax_info(p_chr_id okc_k_headers_b.id%TYPE) IS
6172: SELECT enable_asset_default
6173: FROM okl_property_tax_setups
6174: WHERE org_id = (SELECT authoring_org_id

Line 6173: FROM okl_property_tax_setups

6169: -- Added by rravikir (Fix for Bug 3947959)
6170: lv_asset_default okl_property_tax_setups.enable_asset_default%TYPE;
6171: CURSOR get_est_prop_tax_info(p_chr_id okc_k_headers_b.id%TYPE) IS
6172: SELECT enable_asset_default
6173: FROM okl_property_tax_setups
6174: WHERE org_id = (SELECT authoring_org_id
6175: FROM okc_k_headers_b
6176: WHERE id = p_chr_id);
6177: -- End