APPS.OKL_BPD_ADVANCED_BILLING_PVT dependencies on OKC_RULE_GROUPS_B

Line 113: Okc_rule_groups_B rgp

109: -- Receipt Method Or Payment method
110: CURSOR cust_pmth_csr ( p_khr_id NUMBER ) IS
111: SELECT object1_id1
112: FROM OKC_RULES_B rul,
113: Okc_rule_groups_B rgp
114: WHERE rul.rgp_id = rgp.id AND
115: rgp.rgd_code = 'LABILL' AND
116: rgp.dnz_chr_id = rgp.chr_id AND
117: rul.rule_information_category = 'LAPMTH' AND

Line 123: Okc_rule_groups_B rgp

119: */
120: CURSOR cust_line_pmth_csr ( p_khr_id NUMBER, p_kle_id NUMBER ) IS
121: SELECT object1_id1
122: FROM OKC_RULES_B rul,
123: Okc_rule_groups_B rgp
124: WHERE rul.rgp_id = rgp.id AND
125: rgp.rgd_code = 'LABILL' AND
126: rgp.cle_id = p_kle_id AND
127: rul.rule_information_category = 'LAPMTH' AND

Line 135: , Okc_rule_groups_B rgp

131: FROM okc_k_lines_b cle
132: , okc_k_items_v item
133: , okc_k_lines_b linked_asset
134: , OKC_RULES_B rul
135: , Okc_rule_groups_B rgp
136: WHERE cle.dnz_chr_id = p_khr_id AND
137: cle.id = p_kle_id AND
138: cle.chr_id IS NULL AND
139: cle.id = item.cle_id AND

Line 151: Okc_rule_groups_B rgp

147: /*
148: CURSOR cust_bank_csr ( p_khr_id NUMBER ) IS
149: SELECT object1_id1
150: FROM OKC_RULES_B rul,
151: Okc_rule_groups_B rgp
152: WHERE rul.rgp_id = rgp.id AND
153: rgp.rgd_code = 'LABILL' AND
154: rgp.dnz_chr_id = rgp.chr_id AND
155: rul.rule_information_category = 'LABACC' AND

Line 161: Okc_rule_groups_B rgp

157: */
158: CURSOR cust_line_bank_csr ( p_khr_id NUMBER, p_kle_id NUMBER ) IS
159: SELECT object1_id1
160: FROM OKC_RULES_B rul,
161: Okc_rule_groups_B rgp
162: WHERE rul.rgp_id = rgp.id AND
163: rgp.cle_id = p_kle_id AND
164: rgp.rgd_code = 'LABILL' AND
165: rul.rule_information_category = 'LABACC' AND

Line 173: , Okc_rule_groups_B rgp

169: FROM okc_k_lines_b cle
170: , okc_k_items_v item
171: , okc_k_lines_b linked_asset
172: , OKC_RULES_B rul
173: , Okc_rule_groups_B rgp
174: WHERE cle.dnz_chr_id = p_khr_id AND
175: cle.id = p_kle_id AND
176: cle.chr_id IS NULL AND
177: cle.id = item.cle_id AND