DBA Data[Home] [Help]

APPS.OKL_LA_PROPERTY_TAX_PVT dependencies on OKC_RULE_GROUPS_V

Line 408: OKC_RULE_GROUPS_V rgp

404:
405: CURSOR get_contract_property_tax_info(p_chr_id okc_k_headers_b.id%TYPE) IS
406: SELECT rul.rule_information1, rul.rule_information2, rul.rule_information3
407: FROM OKC_RULES_V rul,
408: OKC_RULE_GROUPS_V rgp
409: WHERE rul.rgp_id = rgp.id
410: AND rgp.dnz_chr_id = p_chr_id
411: AND rgp.cle_id is NULL
412: AND rgp.rgd_code = 'LAHDTX'

Line 428: OKC_RULE_GROUPS_V rgp

424: CURSOR get_asset_contract_tax_info(p_chr_id okc_k_headers_b.id%TYPE,
425: p_cle_id okc_k_lines_v.id%TYPE) IS
426: SELECT rul.rule_information1
427: FROM OKC_RULES_V rul,
428: OKC_RULE_GROUPS_V rgp
429: WHERE rul.rgp_id = rgp.id
430: AND rgp.dnz_chr_id = p_chr_id
431: AND rgp.cle_id = p_cle_id
432: AND rgp.rgd_code = 'LAASTX'

Line 439: OKC_RULE_GROUPS_V rgp

435: CURSOR get_asset_property_tax_info(p_chr_id okc_k_headers_b.id%TYPE,
436: p_cle_id okc_k_lines_v.id%TYPE) IS
437: SELECT rul.id
438: FROM OKC_RULES_V rul,
439: OKC_RULE_GROUPS_V rgp
440: WHERE rul.rgp_id = rgp.id
441: AND rgp.dnz_chr_id = p_chr_id
442: AND rgp.cle_id = p_cle_id
443: AND rgp.rgd_code = 'LAASTX'