DBA Data[Home] [Help]

APPS.OKL_BLK_AST_UPD_PVT dependencies on OKC_RULES_B

Line 193: FROM OKC_RULES_B RUL,

189: CURSOR c_bill_upfront_tax(p_contract_id IN NUMBER,
190: p_line_id IN NUMBER)
191: IS
192: SELECT RUL.RULE_INFORMATION11
193: FROM OKC_RULES_B RUL,
194: OKC_RULE_GROUPS_B RGP
195: WHERE RUL.RGP_ID = RGP.ID
196: AND RGP.DNZ_CHR_ID = p_contract_id
197: AND RGP.CLE_ID = p_line_id

Line 204: FROM OKC_RULES_B RUL,

200:
201: CURSOR c_asset_upfront_tax(p_contract_id IN NUMBER)
202: IS
203: SELECT RUL.RULE_INFORMATION1
204: FROM OKC_RULES_B RUL,
205: OKC_RULE_GROUPS_B RGP
206: WHERE RUL.RGP_ID = RGP.ID
207: AND RGP.DNZ_CHR_ID = p_contract_id
208: AND RUL.RULE_INFORMATION_CATEGORY = 'LASTPR'

Line 1120: l_inv_acct_code OKC_RULES_B.Rule_Information1%TYPE;

1116: l_custBillTo_rec custBillTo_csr%ROWTYPE;
1117:
1118: l_acc_gen_primary_key_tbl okl_account_dist_pvt.acc_gen_primary_key;
1119: l_fact_synd_code FND_LOOKUPS.Lookup_code%TYPE;
1120: l_inv_acct_code OKC_RULES_B.Rule_Information1%TYPE;
1121:
1122: account_data_exception EXCEPTION;
1123:
1124: --Bug# 6619311

Line 1371: l_inv_acct_code OKC_RULES_B.Rule_Information1%TYPE;

1367: SUBTYPE ac_tax_line_rec IS tax_line_csr1%ROWTYPE;
1368: TYPE ac_tax_line_tbl IS TABLE OF ac_tax_line_rec INDEX BY BINARY_INTEGER;
1369: l_accoutable_tax_lines ac_tax_line_tbl;
1370: l_fact_synd_code FND_LOOKUPS.Lookup_code%TYPE;
1371: l_inv_acct_code OKC_RULES_B.Rule_Information1%TYPE;
1372: upfront_tax_acct_exception EXCEPTION;
1373:
1374: l_billed_sty_id NUMBER;
1375: l_transaction_amount NUMBER;