APPS.OKL_BPD_ADVANCED_BILLING_PVT dependencies on OKC_RULES_B

Line 50: l_pmth_line_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;

46: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
47: -- -----------------------------------------------------
48: -- Variable definitions for line level bill-to_support
49: -- -----------------------------------------------------
50: l_pmth_line_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
51: l_rct_line_method_code AR_RECEIPT_CLASSES.CREATION_METHOD_CODE%TYPE;
52: l_bank_line_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
53:
54: l_line_cust_bank_acct_id OKL_TRX_AR_INVOICES_V.customer_bank_account_id%TYPE;

Line 52: l_bank_line_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;

48: -- Variable definitions for line level bill-to_support
49: -- -----------------------------------------------------
50: l_pmth_line_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
51: l_rct_line_method_code AR_RECEIPT_CLASSES.CREATION_METHOD_CODE%TYPE;
52: l_bank_line_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
53:
54: l_line_cust_bank_acct_id OKL_TRX_AR_INVOICES_V.customer_bank_account_id%TYPE;
55: l_line_cust_address_id OKL_TRX_AR_INVOICES_V.ibt_id%TYPE;
56: l_line_receipt_method_id OKL_TRX_AR_INVOICES_V.irm_id%TYPE;

Line 112: FROM OKC_RULES_B rul,

108: /*
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

Line 122: FROM OKC_RULES_B rul,

118: rgp.dnz_chr_id = p_khr_id;
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

Line 134: , OKC_RULES_B rul

130: SELECT rul.object1_id1
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

Line 150: FROM OKC_RULES_B rul,

146:
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

Line 160: FROM OKC_RULES_B rul,

156: rgp.dnz_chr_id = p_khr_id;
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

Line 172: , OKC_RULES_B rul

168: SELECT rul.object1_id1
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