APPS.OKL_DEAL_CREATE_PUB dependencies on OKC_RULES_V

Line 694: FROM Okc_Rules_V

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

Line 695: WHERE okc_rules_v.rgp_id = p_rgp_id

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

Line 696: AND okc_rules_v.object2_id1 = p_slh_id

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

Line 839: FROM okc_rules_v

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

Line 2819: FROM okc_rules_v

2815: CURSOR c_rule_segmnts_csr(p_rule_id IN NUMBER) IS
2816: SELECT RULE_INFORMATION1,RULE_INFORMATION2,RULE_INFORMATION3,RULE_INFORMATION4,RULE_INFORMATION5,
2817: RULE_INFORMATION6,RULE_INFORMATION7,RULE_INFORMATION8,RULE_INFORMATION9,RULE_INFORMATION10,
2818: RULE_INFORMATION11,RULE_INFORMATION12,RULE_INFORMATION13,RULE_INFORMATION14,RULE_INFORMATION15
2819: FROM okc_rules_v
2820: WHERE id = p_rule_id
2821: AND dnz_chr_id = p_dest_id;
2822:
2823: rul_seg_rec c_rule_segmnts_csr%ROWTYPE;

Line 8104: FROM okc_rule_groups_v rgp, okc_rules_v rul

8100: AND gvr.dnz_chr_id = p_durv_rec.chr_id;
8101:
8102: CURSOR l_dff_rule_csr(p_rgd_code VARCHAR2, p_rule_information_category VARCHAR2) IS
8103: SELECT rgp.id, rul.id, rul.rule_information1
8104: FROM okc_rule_groups_v rgp, okc_rules_v rul
8105: WHERE rgp.id = rul.rgp_id
8106: AND rgp.rgd_code = p_rgd_code
8107: AND rul.rule_information_category = p_rule_information_category
8108: AND rul.dnz_chr_id = p_durv_rec.chr_id

Line 8123: FROM okc_rule_groups_v rgp, okc_rules_v rul

8119: --end modified abhsaxen for performance SQLID 20563248
8120: ;
8121: CURSOR l_customer_account_csr IS
8122: SELECT rgp.id, rul.id, rul.object1_id1,rul.object1_id2,rul.jtot_object1_code
8123: FROM okc_rule_groups_v rgp, okc_rules_v rul
8124: WHERE rgp.id = rul.rgp_id
8125: AND rgp.rgd_code = 'LACAN'
8126: AND rul.rule_information_category = 'CAN'
8127: AND rul.dnz_chr_id = p_durv_rec.chr_id