APPS.OKL_COPY_CONTRACT_PVT dependencies on OKC_RULES_V

Line 2086: FROM Okc_Rules_V

2082: ans_set_jtot_object_code,
2083: ans_set_jtot_object_id1,
2084: ans_set_jtot_object_id2,
2085: DISPLAY_SEQUENCE
2086: FROM Okc_Rules_V
2087: WHERE okc_rules_v.rgp_id = p_rgp_id
2088: AND okc_rules_v.object2_id1 = p_slh_id
2089: AND RULE_INFORMATION_CATEGORY = DECODE(p_rdf_code,NULL,RULE_INFORMATION_CATEGORY,p_rdf_code);
2090:

Line 2087: WHERE okc_rules_v.rgp_id = p_rgp_id

2083: ans_set_jtot_object_id1,
2084: ans_set_jtot_object_id2,
2085: DISPLAY_SEQUENCE
2086: FROM Okc_Rules_V
2087: WHERE okc_rules_v.rgp_id = p_rgp_id
2088: AND okc_rules_v.object2_id1 = p_slh_id
2089: AND RULE_INFORMATION_CATEGORY = DECODE(p_rdf_code,NULL,RULE_INFORMATION_CATEGORY,p_rdf_code);
2090:
2091: l_rulv_rec rulv_rec_type;

Line 2088: AND okc_rules_v.object2_id1 = p_slh_id

2084: ans_set_jtot_object_id2,
2085: DISPLAY_SEQUENCE
2086: FROM Okc_Rules_V
2087: WHERE okc_rules_v.rgp_id = p_rgp_id
2088: AND okc_rules_v.object2_id1 = p_slh_id
2089: AND RULE_INFORMATION_CATEGORY = DECODE(p_rdf_code,NULL,RULE_INFORMATION_CATEGORY,p_rdf_code);
2090:
2091: l_rulv_rec rulv_rec_type;
2092: i NUMBER DEFAULT 0;

Line 2237: FROM okc_rules_v

2233: AND rgd_code = 'LALEVL';
2234:
2235: CURSOR rule_csr(p_rgp_id NUMBER) IS
2236: SELECT id
2237: FROM okc_rules_v
2238: WHERE rgp_id = p_rgp_id
2239: --Bug# : 3124577 :11.5.10 Rule migration
2240: AND rule_information_category IN ('LASLH','LASLL');
2241: --AND rule_information_category IN ('SLH','SLL');