APPS.OKL_COPY_CONTRACT_PVT dependencies on OKC_RULES_V

Line 2049: FROM Okc_Rules_V

2045: ans_set_jtot_object_code,
2046: ans_set_jtot_object_id1,
2047: ans_set_jtot_object_id2,
2048: DISPLAY_SEQUENCE
2049: FROM Okc_Rules_V
2050: WHERE okc_rules_v.rgp_id = p_rgp_id
2051: AND okc_rules_v.object2_id1 = p_slh_id
2052: AND RULE_INFORMATION_CATEGORY = DECODE(p_rdf_code,NULL,RULE_INFORMATION_CATEGORY,p_rdf_code);
2053:

Line 2050: WHERE okc_rules_v.rgp_id = p_rgp_id

2046: ans_set_jtot_object_id1,
2047: ans_set_jtot_object_id2,
2048: DISPLAY_SEQUENCE
2049: FROM Okc_Rules_V
2050: WHERE okc_rules_v.rgp_id = p_rgp_id
2051: AND okc_rules_v.object2_id1 = p_slh_id
2052: AND RULE_INFORMATION_CATEGORY = DECODE(p_rdf_code,NULL,RULE_INFORMATION_CATEGORY,p_rdf_code);
2053:
2054: l_rulv_rec rulv_rec_type;

Line 2051: AND okc_rules_v.object2_id1 = p_slh_id

2047: ans_set_jtot_object_id2,
2048: DISPLAY_SEQUENCE
2049: FROM Okc_Rules_V
2050: WHERE okc_rules_v.rgp_id = p_rgp_id
2051: AND okc_rules_v.object2_id1 = p_slh_id
2052: AND RULE_INFORMATION_CATEGORY = DECODE(p_rdf_code,NULL,RULE_INFORMATION_CATEGORY,p_rdf_code);
2053:
2054: l_rulv_rec rulv_rec_type;
2055: i NUMBER DEFAULT 0;

Line 2200: FROM okc_rules_v

2196: AND rgd_code = 'LALEVL';
2197:
2198: CURSOR rule_csr(p_rgp_id NUMBER) IS
2199: SELECT id
2200: FROM okc_rules_v
2201: WHERE rgp_id = p_rgp_id
2202: --Bug# : 3124577 :11.5.10 Rule migration
2203: AND rule_information_category IN ('LASLH','LASLL');
2204: --AND rule_information_category IN ('SLH','SLL');