APPS.OKC_PO_QA_PVT dependencies on OKC_RULE_GROUPS_B

Line 278: FROM okc_rule_groups_b rgp

274: BEGIN
275: IF (x_return_status<>OKC_API.G_RET_STS_ERROR) THEN
276: SELECT 1 /*+ FIRST_ROWS */
277: INTO lshipping_gr_count
278: FROM okc_rule_groups_b rgp
279: WHERE rgp.dnz_chr_id = p_chr_id
280: AND rgp.cle_id IS NULL
281: AND (rgp.rgd_code = g_rg_shipping)
282: and rownum<2;

Line 302: FROM okc_rule_groups_b rgp

298: BEGIN
299: IF (x_return_status<>OKC_API.G_RET_STS_ERROR) THEN
300: SELECT '1' /*+ FIRST_ROWS */
301: INTO lpayment_gr_count
302: FROM okc_rule_groups_b rgp
303: WHERE rgp.dnz_chr_id = p_chr_id
304: AND rgp.cle_id IS NULL
305: AND (rgp.rgd_code = g_rg_payment)
306: and rownum < 2;