APPS.OKL_LA_PROPERTY_TAX_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 34

	-- Start 4042157 fmiao 12/03/04 added update_from_contract --
    lv_update_from_contract okl_property_tax_setups.update_from_contract%TYPE;

Line: 36

	-- End 4042157 fmiao 12/03/04 added update_from_contract --

    l_api_name		CONSTANT VARCHAR2(30) := 'CREATE_EST_PROP_TAX_RULES';

Line: 40

	-- Start 4042157 fmiao 12/03/04 added update_from_contract --
    CURSOR get_est_prop_tax_info(p_chr_id  okc_k_headers_b.id%TYPE) IS
    SELECT enable_asset_default, property_tax_applicable,
		   bill_property_tax,update_from_contract
    FROM okl_property_tax_setups
    WHERE org_id = (SELECT authoring_org_id
                    FROM okc_k_headers_b
                    WHERE id = p_chr_id);

Line: 48

	-- End 4042157 fmiao 12/03/04 added update_from_contract --
  BEGIN

      x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line: 81

									   lv_update_from_contract;

Line: 144

		-- Start 4042157 fmiao 12/03/04 added update_from_contract --
		l_rulv_rec.rule_information_category := 'LAASTK';

Line: 147

        IF (lv_update_from_contract = 'YES') THEN
          l_rulv_rec.rule_information1 := 'Y';

Line: 166

		-- Start 4042157 fmiao 12/03/04 added update_from_contract --
      END IF;

Line: 239

    SELECT property_tax_applicable,
		   bill_property_tax
    FROM okl_property_tax_setups
    WHERE org_id = (SELECT authoring_org_id
                    FROM okc_k_headers_b
                    WHERE id = p_chr_id);

Line: 406

    SELECT rul.rule_information1, rul.rule_information2, rul.rule_information3
    FROM  OKC_RULES_V rul,
          OKC_RULE_GROUPS_V rgp
    WHERE rul.rgp_id = rgp.id
    AND   rgp.dnz_chr_id = p_chr_id
    AND   rgp.cle_id is NULL
    AND   rgp.rgd_code = 'LAHDTX'
    AND   rul.rule_information_category = 'LAPRTX';

Line: 416

    SELECT cle.id
    FROM   OKC_K_LINES_V cle,
           OKC_LINE_STYLES_V lse
    WHERE  cle.lse_id = lse.id
    AND    lse.lty_code = 'FREE_FORM1'
    AND    lse.lse_type = 'TLS'
    AND    cle.dnz_chr_id = p_chr_id;

Line: 426

    SELECT rul.rule_information1
    FROM  OKC_RULES_V rul,
          OKC_RULE_GROUPS_V rgp
    WHERE rul.rgp_id = rgp.id
    AND   rgp.dnz_chr_id = p_chr_id
    AND   rgp.cle_id = p_cle_id
    AND   rgp.rgd_code = 'LAASTX'
    AND   rul.rule_information_category = 'LAASTK';

Line: 437

    SELECT rul.id
    FROM  OKC_RULES_V rul,
          OKC_RULE_GROUPS_V rgp
    WHERE rul.rgp_id = rgp.id
    AND   rgp.dnz_chr_id = p_chr_id
    AND   rgp.cle_id = p_cle_id
    AND   rgp.rgd_code = 'LAASTX'
    AND   rul.rule_information_category = 'LAPRTX';

Line: 500

          OKL_RULE_PUB.update_rule(
            p_api_version         => p_api_version,
            p_init_msg_list       => p_init_msg_list,
            x_return_status       => x_return_status,
            x_msg_count           => x_msg_count,
            x_msg_data            => x_msg_data,
            p_rulv_rec            => l_rulv_rec,
            x_rulv_rec            => lx_rulv_rec);