DBA Data[Home] [Help]

APPS.OKL_CONTRACT_REBOOK_PVT dependencies on OKC_RULES_B

Line 4494: OKC_RULES_B rule

4490: CURSOR chk_expense_info (p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
4491: p_cle_id IN OKC_K_LINES_B.ID%TYPE) IS
4492: SELECT 'Y'
4493: FROM OKC_RULE_GROUPS_B rgp,
4494: OKC_RULES_B rule
4495: WHERE rgp.id = rule.rgp_id
4496: AND rgp.rgd_code = 'LAFEXP'
4497: AND RULE_INFORMATION_CATEGORY IN ('LAFREQ', 'LAFEXP')
4498: AND rgp.dnz_chr_id = p_chr_id

Line 5305: FROM okc_rules_b rul_orig

5301: FROM okc_rules_v rul_rbk
5302: WHERE rul_rbk.dnz_chr_id = p_rebook_chr_id
5303: AND rul_rbk.rgp_id = p_rbk_rgp_id
5304: AND NOT EXISTS (SELECT 1
5305: FROM okc_rules_b rul_orig
5306: WHERE rul_orig.dnz_chr_id = p_orig_chr_id
5307: AND rul_orig.rgp_id = p_orig_rgp_id
5308: AND rul_orig.rule_information_category = rul_rbk.rule_information_category);
5309:

Line 6760: FROM okc_rules_b rul_orig

6756: FROM okc_rules_v rul_rbk
6757: WHERE rul_rbk.dnz_chr_id = p_rebook_chr_id
6758: AND rul_rbk.rgp_id = p_rbk_rgp_id
6759: AND NOT EXISTS (SELECT 1
6760: FROM okc_rules_b rul_orig
6761: WHERE rul_orig.dnz_chr_id = p_orig_chr_id
6762: AND rul_orig.rgp_id = p_orig_rgp_id
6763: AND rul_orig.rule_information_category = rul_rbk.rule_information_category);
6764:

Line 7290: FROM okc_rules_b rul,

7286:
7287: --Bug# 8351588
7288: CURSOR l_rbk_limit_date_csr(p_chr_id IN NUMBER) IS
7289: SELECT rul.rule_information1
7290: FROM okc_rules_b rul,
7291: okc_rule_groups_b rgp
7292: WHERE rgp.chr_id = p_chr_id
7293: AND rgp.dnz_chr_id = p_chr_id
7294: AND rgp.rgd_code = 'LAREBL'