APPS.OKL_DEAL_CREAT_PVT dependencies on OKC_RULES_V

Line 693: FROM Okc_Rules_V

689: ans_set_jtot_object_code,
690: ans_set_jtot_object_id1,
691: ans_set_jtot_object_id2,
692: DISPLAY_SEQUENCE
693: FROM Okc_Rules_V
694: WHERE okc_rules_v.rgp_id = p_rgp_id
695: AND okc_rules_v.object2_id1 = p_slh_id
696: AND RULE_INFORMATION_CATEGORY = DECODE(p_rdf_code,NULL,RULE_INFORMATION_CATEGORY,p_rdf_code);
697:

Line 694: WHERE okc_rules_v.rgp_id = p_rgp_id

690: ans_set_jtot_object_id1,
691: ans_set_jtot_object_id2,
692: DISPLAY_SEQUENCE
693: FROM Okc_Rules_V
694: WHERE okc_rules_v.rgp_id = p_rgp_id
695: AND okc_rules_v.object2_id1 = p_slh_id
696: AND RULE_INFORMATION_CATEGORY = DECODE(p_rdf_code,NULL,RULE_INFORMATION_CATEGORY,p_rdf_code);
697:
698: l_rulv_rec rulv_rec_type;

Line 695: AND okc_rules_v.object2_id1 = p_slh_id

691: ans_set_jtot_object_id2,
692: DISPLAY_SEQUENCE
693: FROM Okc_Rules_V
694: WHERE okc_rules_v.rgp_id = p_rgp_id
695: AND okc_rules_v.object2_id1 = p_slh_id
696: AND RULE_INFORMATION_CATEGORY = DECODE(p_rdf_code,NULL,RULE_INFORMATION_CATEGORY,p_rdf_code);
697:
698: l_rulv_rec rulv_rec_type;
699: i NUMBER DEFAULT 0;

Line 838: FROM okc_rules_v

834: AND rgd_code = 'LALEVL';
835:
836: CURSOR rule_csr(p_rgp_id NUMBER) IS
837: SELECT id
838: FROM okc_rules_v
839: WHERE rgp_id = p_rgp_id
840: AND rule_information_category IN ('LASLH','LASLL');
841:
842: BEGIN

Line 2799: FROM okc_rules_v

2795: CURSOR c_rule_segmnts_csr(p_rule_id IN NUMBER) IS
2796: SELECT RULE_INFORMATION1,RULE_INFORMATION2,RULE_INFORMATION3,RULE_INFORMATION4,RULE_INFORMATION5,
2797: RULE_INFORMATION6,RULE_INFORMATION7,RULE_INFORMATION8,RULE_INFORMATION9,RULE_INFORMATION10,
2798: RULE_INFORMATION11,RULE_INFORMATION12,RULE_INFORMATION13,RULE_INFORMATION14,RULE_INFORMATION15
2799: FROM okc_rules_v
2800: WHERE id = p_rule_id
2801: AND dnz_chr_id = p_dest_id;
2802:
2803: rul_seg_rec c_rule_segmnts_csr%ROWTYPE;

Line 8308: FROM okc_rule_groups_v rgp, okc_rules_v rul

8304: AND gvr.dnz_chr_id = p_durv_rec.chr_id;
8305:
8306: CURSOR l_dff_rule_csr(p_rgd_code VARCHAR2, p_rule_information_category VARCHAR2) IS
8307: SELECT rgp.id, rul.id, rul.rule_information1
8308: FROM okc_rule_groups_v rgp, okc_rules_v rul
8309: WHERE rgp.id = rul.rgp_id
8310: AND rgp.rgd_code = p_rgd_code
8311: AND rul.rule_information_category = p_rule_information_category
8312: AND rul.dnz_chr_id = p_durv_rec.chr_id

Line 8327: FROM okc_rule_groups_v rgp, okc_rules_v rul

8323: --end modified abhsaxen for performance SQLID 20563248
8324: ;
8325: CURSOR l_customer_account_csr IS
8326: SELECT rgp.id, rul.id, rul.object1_id1,rul.object1_id2,rul.jtot_object1_code
8327: FROM okc_rule_groups_v rgp, okc_rules_v rul
8328: WHERE rgp.id = rul.rgp_id
8329: AND rgp.rgd_code = 'LACAN'
8330: AND rul.rule_information_category = 'CAN'
8331: AND rul.dnz_chr_id = p_durv_rec.chr_id