APPS.OKL_ARINTF_PVT dependencies on OKC_RULE_GROUPS_B

Line 115: Okc_rule_groups_B rgp

111:
112: CURSOR cust_line_pmth_csr ( p_khr_id NUMBER, p_kle_id NUMBER ) IS
113: SELECT object1_id1
114: FROM OKC_RULES_B rul,
115: Okc_rule_groups_B rgp
116: WHERE rul.rgp_id = rgp.id AND
117: rgp.rgd_code = 'LABILL' AND
118: rgp.cle_id = p_kle_id AND
119: rul.rule_information_category = 'LAPMTH' AND

Line 127: , Okc_rule_groups_B rgp

123: FROM okc_k_lines_b cle
124: , okc_k_items_v item
125: , okc_k_lines_b linked_asset
126: , OKC_RULES_B rul
127: , Okc_rule_groups_B rgp
128: WHERE cle.dnz_chr_id = p_khr_id AND
129: cle.id = p_kle_id AND
130: cle.chr_id IS NULL AND
131: cle.id = item.cle_id AND

Line 155: Okc_rule_groups_B rgp

151:
152: CURSOR cust_line_bank_csr ( p_khr_id NUMBER, p_kle_id NUMBER ) IS
153: SELECT object1_id1
154: FROM OKC_RULES_B rul,
155: Okc_rule_groups_B rgp
156: WHERE rul.rgp_id = rgp.id AND
157: rgp.cle_id = p_kle_id AND
158: rgp.rgd_code = 'LABILL' AND
159: rul.rule_information_category = 'LABACC' AND

Line 167: , Okc_rule_groups_B rgp

163: FROM okc_k_lines_b cle
164: , okc_k_items_v item
165: , okc_k_lines_b linked_asset
166: , OKC_RULES_B rul
167: , Okc_rule_groups_B rgp
168: WHERE cle.dnz_chr_id = p_khr_id AND
169: cle.id = p_kle_id AND
170: cle.chr_id IS NULL AND
171: cle.id = item.cle_id AND

Line 801: Okc_rule_groups_B rgp

797: -- Fetch the Contract Level Bank Id
798: CURSOR cust_bank_csr ( cp_khr_id NUMBER ) IS
799: SELECT object1_id1
800: FROM OKC_RULES_B rul,
801: Okc_rule_groups_B rgp
802: WHERE rul.rgp_id = rgp.id AND
803: rgp.rgd_code = 'LABILL' AND
804: rgp.dnz_chr_id = rgp.chr_id AND
805: rul.rule_information_category = 'LABACC' AND