APPS.OKL_CONTRACT_REBOOK_PVT dependencies on OKC_RULES_V

Line 1310: Okc_Rules_V rule

1306: rule.ans_set_jtot_object_id1,
1307: rule.ans_set_jtot_object_id2,
1308: rule.DISPLAY_SEQUENCE
1309: FROM OKC_RULE_GROUPS_V rgp,
1310: Okc_Rules_V rule
1311: WHERE rgp.id = rule.rgp_id
1312: AND rgp.rgd_code = p_rgd_code
1313: AND RULE_INFORMATION_CATEGORY = p_rule_code
1314: AND rgp.dnz_chr_id = p_chr_id

Line 1493: FROM Okc_Rules_V

1489: ans_set_jtot_object_code,
1490: ans_set_jtot_object_id1,
1491: ans_set_jtot_object_id2,
1492: DISPLAY_SEQUENCE
1493: FROM Okc_Rules_V
1494: WHERE okc_rules_v.rgp_id = p_rgp_id
1495: AND okc_rules_v.object2_id1 = p_slh_id
1496: AND RULE_INFORMATION_CATEGORY = DECODE(p_rdf_code,NULL,RULE_INFORMATION_CATEGORY,p_rdf_code);
1497:

Line 1494: WHERE okc_rules_v.rgp_id = p_rgp_id

1490: ans_set_jtot_object_id1,
1491: ans_set_jtot_object_id2,
1492: DISPLAY_SEQUENCE
1493: FROM Okc_Rules_V
1494: WHERE okc_rules_v.rgp_id = p_rgp_id
1495: AND okc_rules_v.object2_id1 = p_slh_id
1496: AND RULE_INFORMATION_CATEGORY = DECODE(p_rdf_code,NULL,RULE_INFORMATION_CATEGORY,p_rdf_code);
1497:
1498: l_rulv_rec rulv_rec_type;

Line 1495: AND okc_rules_v.object2_id1 = p_slh_id

1491: ans_set_jtot_object_id2,
1492: DISPLAY_SEQUENCE
1493: FROM Okc_Rules_V
1494: WHERE okc_rules_v.rgp_id = p_rgp_id
1495: AND okc_rules_v.object2_id1 = p_slh_id
1496: AND RULE_INFORMATION_CATEGORY = DECODE(p_rdf_code,NULL,RULE_INFORMATION_CATEGORY,p_rdf_code);
1497:
1498: l_rulv_rec rulv_rec_type;
1499: i NUMBER DEFAULT 0;

Line 1932: FROM okc_rules_v

1928: AND rgd_code = 'LALEVL';
1929:
1930: CURSOR rule_csr(p_rgp_id NUMBER) IS
1931: SELECT id
1932: FROM okc_rules_v
1933: WHERE rgp_id = p_rgp_id;
1934:
1935: --Bug# 4899328
1936: l_lalevl_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

Line 3849: l_orig_freq OKC_RULES_V.OBJECT1_ID1%TYPE;

3845: l_d_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
3846:
3847: l_orig_freq_rule_id NUMBER;
3848: l_orig_freq_rgp_id NUMBER;
3849: l_orig_freq OKC_RULES_V.OBJECT1_ID1%TYPE;
3850: l_orig_exp_rule_id NUMBER;
3851: l_orig_exp_rgp_id NUMBER;
3852: l_orig_exp_period NUMBER;
3853: l_orig_exp_amount NUMBER;

Line 4692: FROM okc_rules_v

4688: AND rgd_code = 'LALEVL';
4689:
4690: CURSOR rule_csr(p_rgp_id NUMBER) IS
4691: SELECT id
4692: FROM okc_rules_v
4693: WHERE rgp_id = p_rgp_id;
4694:
4695: CURSOR rebook_new_all_line_csr (p_top_line_id NUMBER) IS
4696: SELECT id,