APPS.OKL_LA_PROPERTY_TAX_PVT dependencies on OKL_PROPERTY_TAX_SETUPS

Line 31: lv_enable_asset_default okl_property_tax_setups.enable_asset_default%TYPE;

27:
28: l_chr_id okc_k_headers_b.id%TYPE;
29: l_cle_id okc_k_lines_v.id%TYPE;
30: l_rgp_id NUMBER;
31: lv_enable_asset_default okl_property_tax_setups.enable_asset_default%TYPE;
32: lv_property_tax_applicable okl_property_tax_setups.property_tax_applicable%TYPE;
33: lv_bill_property_tax okl_property_tax_setups.bill_property_tax%TYPE;
34: -- Start 4042157 fmiao 12/03/04 added update_from_contract --
35: lv_update_from_contract okl_property_tax_setups.update_from_contract%TYPE;

Line 32: lv_property_tax_applicable okl_property_tax_setups.property_tax_applicable%TYPE;

28: l_chr_id okc_k_headers_b.id%TYPE;
29: l_cle_id okc_k_lines_v.id%TYPE;
30: l_rgp_id NUMBER;
31: lv_enable_asset_default okl_property_tax_setups.enable_asset_default%TYPE;
32: lv_property_tax_applicable okl_property_tax_setups.property_tax_applicable%TYPE;
33: lv_bill_property_tax okl_property_tax_setups.bill_property_tax%TYPE;
34: -- Start 4042157 fmiao 12/03/04 added update_from_contract --
35: lv_update_from_contract okl_property_tax_setups.update_from_contract%TYPE;
36: -- End 4042157 fmiao 12/03/04 added update_from_contract --

Line 33: lv_bill_property_tax okl_property_tax_setups.bill_property_tax%TYPE;

29: l_cle_id okc_k_lines_v.id%TYPE;
30: l_rgp_id NUMBER;
31: lv_enable_asset_default okl_property_tax_setups.enable_asset_default%TYPE;
32: lv_property_tax_applicable okl_property_tax_setups.property_tax_applicable%TYPE;
33: lv_bill_property_tax okl_property_tax_setups.bill_property_tax%TYPE;
34: -- Start 4042157 fmiao 12/03/04 added update_from_contract --
35: lv_update_from_contract okl_property_tax_setups.update_from_contract%TYPE;
36: -- End 4042157 fmiao 12/03/04 added update_from_contract --
37:

Line 35: lv_update_from_contract okl_property_tax_setups.update_from_contract%TYPE;

31: lv_enable_asset_default okl_property_tax_setups.enable_asset_default%TYPE;
32: lv_property_tax_applicable okl_property_tax_setups.property_tax_applicable%TYPE;
33: lv_bill_property_tax okl_property_tax_setups.bill_property_tax%TYPE;
34: -- Start 4042157 fmiao 12/03/04 added update_from_contract --
35: lv_update_from_contract okl_property_tax_setups.update_from_contract%TYPE;
36: -- End 4042157 fmiao 12/03/04 added update_from_contract --
37:
38: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_EST_PROP_TAX_RULES';
39:

Line 44: FROM okl_property_tax_setups

40: -- Start 4042157 fmiao 12/03/04 added update_from_contract --
41: CURSOR get_est_prop_tax_info(p_chr_id okc_k_headers_b.id%TYPE) IS
42: SELECT enable_asset_default, property_tax_applicable,
43: bill_property_tax,update_from_contract
44: FROM okl_property_tax_setups
45: WHERE org_id = (SELECT authoring_org_id
46: FROM okc_k_headers_b
47: WHERE id = p_chr_id);
48: -- End 4042157 fmiao 12/03/04 added update_from_contract --

Line 234: lv_property_tax_applicable okl_property_tax_setups.property_tax_applicable%TYPE;

230: lx_rulv_rec rulv_rec_type;
231:
232: l_chr_id okc_k_headers_b.id%TYPE;
233: l_rgp_id NUMBER;
234: lv_property_tax_applicable okl_property_tax_setups.property_tax_applicable%TYPE;
235: lv_bill_property_tax okl_property_tax_setups.bill_property_tax%TYPE;
236: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_EST_PROP_TAX_RULES';
237:
238: CURSOR get_est_prop_tax_info(p_chr_id okc_k_headers_b.id%TYPE) IS

Line 235: lv_bill_property_tax okl_property_tax_setups.bill_property_tax%TYPE;

231:
232: l_chr_id okc_k_headers_b.id%TYPE;
233: l_rgp_id NUMBER;
234: lv_property_tax_applicable okl_property_tax_setups.property_tax_applicable%TYPE;
235: lv_bill_property_tax okl_property_tax_setups.bill_property_tax%TYPE;
236: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_EST_PROP_TAX_RULES';
237:
238: CURSOR get_est_prop_tax_info(p_chr_id okc_k_headers_b.id%TYPE) IS
239: SELECT property_tax_applicable,

Line 241: FROM okl_property_tax_setups

237:
238: CURSOR get_est_prop_tax_info(p_chr_id okc_k_headers_b.id%TYPE) IS
239: SELECT property_tax_applicable,
240: bill_property_tax
241: FROM okl_property_tax_setups
242: WHERE org_id = (SELECT authoring_org_id
243: FROM okc_k_headers_b
244: WHERE id = p_chr_id);
245: