APPS.OKL_UBB_INTEGRATION_PVT dependencies on OKC_RULE_GROUPS_V

Line 171: p_rgd_code IN OKC_RULE_GROUPS_V.RGD_CODE%TYPE,

167: x_return_status OUT NOCOPY VARCHAR2,
168: x_msg_count OUT NOCOPY NUMBER,
169: x_msg_data OUT NOCOPY VARCHAR2,
170: p_rule_information_category IN OKC_RULES_V.RULE_INFORMATION_CATEGORY%TYPE,
171: p_rgd_code IN OKC_RULE_GROUPS_V.RGD_CODE%TYPE,
172: p_jtot_object1_code IN OKC_RULES_V.JTOT_OBJECT1_CODE%TYPE,
173: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
174: p_cle_id IN OKC_K_LINES_V.ID%TYPE,
175: x_rulv_rec OUT NOCOPY rulv_rec_type

Line 180: p_rgd_code OKC_RULE_GROUPS_V.RGD_CODE%TYPE,

176: ) IS
177:
178:
179: CURSOR rulv_csr (p_rule_info_catg OKC_RULES_V.RULE_INFORMATION_CATEGORY%TYPE,
180: p_rgd_code OKC_RULE_GROUPS_V.RGD_CODE%TYPE,
181: p_jtot_code OKC_RULES_V.JTOT_OBJECT1_CODE%TYPE,
182: p_chr_id OKC_K_HEADERS_V.ID%TYPE,
183: p_cle_id OKC_K_LINES_V.ID%TYPE) IS
184: SELECT

Line 246: okc_rule_groups_v grp

242: ans_set_jtot_object_id1,
243: ans_set_jtot_object_id2,
244: display_sequence
245: FROM okc_rules_v rule,
246: okc_rule_groups_v grp
247: WHERE rule_information_category = p_rule_info_catg --'CAN'
248: AND jtot_object1_code = p_jtot_code --'OKX_CUSTACCT'
249: AND grp.rgd_code = p_rgd_code --'LACAN'
250: AND (grp.dnz_chr_id = NVL(p_chr_id, G_INIT_NUMBER)