APPS.OKC_OPPORTUNITY_PVT dependencies on OKC_RULES_B

Line 168: okc_rules_b.rule_information_category%TYPE) is

164: from jtf_rs_salesreps
165: where salesrep_id = g_sales_rep); */
166: --
167: cursor c5(p_rule_information_category IN
168: okc_rules_b.rule_information_category%TYPE) is
169: select rule_information1,
170: rule_information2,
171: rule_information3,
172: rule_information4,

Line 176: from okc_rules_b

172: rule_information4,
173: rule_information5,
174: jtot_object1_code,
175: object1_id1
176: from okc_rules_b
177: where dnz_chr_id = p_contract_id
178: and rule_information_category = p_rule_information_category;
179: --
180:

Line 1193: cursor rul_csr(p_rule okc_rules_b.rule_information_category%TYPE,

1189: where (rel.cle_id = cle.id
1190: or rel.cle_id = cle.cle_id)
1191: and rel.rty_code = g_rty_code);
1192: --
1193: cursor rul_csr(p_rule okc_rules_b.rule_information_category%TYPE,
1194: p_renewal_type okc_rules_b.rule_information1%TYPE) is
1195: select 'x'
1196: from okc_rules_b
1197: where dnz_chr_id = p_contract_id

Line 1194: p_renewal_type okc_rules_b.rule_information1%TYPE) is

1190: or rel.cle_id = cle.cle_id)
1191: and rel.rty_code = g_rty_code);
1192: --
1193: cursor rul_csr(p_rule okc_rules_b.rule_information_category%TYPE,
1194: p_renewal_type okc_rules_b.rule_information1%TYPE) is
1195: select 'x'
1196: from okc_rules_b
1197: where dnz_chr_id = p_contract_id
1198: and rule_information_category = p_rule

Line 1196: from okc_rules_b

1192: --
1193: cursor rul_csr(p_rule okc_rules_b.rule_information_category%TYPE,
1194: p_renewal_type okc_rules_b.rule_information1%TYPE) is
1195: select 'x'
1196: from okc_rules_b
1197: where dnz_chr_id = p_contract_id
1198: and rule_information_category = p_rule
1199: and rule_information1 = p_renewal_type;
1200: --

Line 1392: okc_rules_b.rule_information_category%TYPE) is

1388: x_win_probability IN OUT NOCOPY NUMBER,
1389: x_closing_date_days IN OUT NOCOPY NUMBER,
1390: x_return_status OUT NOCOPY VARCHAR2) IS
1391: cursor c1(p_rule_information_category IN
1392: okc_rules_b.rule_information_category%TYPE) is
1393: select rule_information1,
1394: rule_information2,
1395: rule_information3,
1396: rule_information4,

Line 1398: from okc_rules_b

1394: rule_information2,
1395: rule_information3,
1396: rule_information4,
1397: rule_information5
1398: from okc_rules_b
1399: where dnz_chr_id = p_contract_id
1400: and rule_information_category = p_rule_information_category;
1401: c1_rec c1%ROWTYPE;
1402: l_row_found Boolean;