DBA Data[Home] [Help]

APPS.OKL_BLK_AST_UPD_PVT dependencies on OKC_RULES_B

Line 225: FROM OKC_RULES_B RUL,

221: CURSOR c_bill_upfront_tax(p_contract_id IN NUMBER,
222: p_line_id IN NUMBER)
223: IS
224: SELECT RUL.RULE_INFORMATION11
225: FROM OKC_RULES_B RUL,
226: OKC_RULE_GROUPS_B RGP
227: WHERE RUL.RGP_ID = RGP.ID
228: AND RGP.DNZ_CHR_ID = p_contract_id
229: AND RGP.CLE_ID = p_line_id

Line 236: FROM OKC_RULES_B RUL,

232:
233: CURSOR c_asset_upfront_tax(p_contract_id IN NUMBER)
234: IS
235: SELECT RUL.RULE_INFORMATION1
236: FROM OKC_RULES_B RUL,
237: OKC_RULE_GROUPS_B RGP
238: WHERE RUL.RGP_ID = RGP.ID
239: AND RGP.DNZ_CHR_ID = p_contract_id
240: AND RUL.RULE_INFORMATION_CATEGORY = 'LASTPR'

Line 1152: l_inv_acct_code OKC_RULES_B.Rule_Information1%TYPE;

1148: l_custBillTo_rec custBillTo_csr%ROWTYPE;
1149:
1150: l_acc_gen_primary_key_tbl okl_account_dist_pvt.acc_gen_primary_key;
1151: l_fact_synd_code FND_LOOKUPS.Lookup_code%TYPE;
1152: l_inv_acct_code OKC_RULES_B.Rule_Information1%TYPE;
1153:
1154: account_data_exception EXCEPTION;
1155:
1156: --Bug# 6619311

Line 1403: l_inv_acct_code OKC_RULES_B.Rule_Information1%TYPE;

1399: SUBTYPE ac_tax_line_rec IS tax_line_csr1%ROWTYPE;
1400: TYPE ac_tax_line_tbl IS TABLE OF ac_tax_line_rec INDEX BY BINARY_INTEGER;
1401: l_accoutable_tax_lines ac_tax_line_tbl;
1402: l_fact_synd_code FND_LOOKUPS.Lookup_code%TYPE;
1403: l_inv_acct_code OKC_RULES_B.Rule_Information1%TYPE;
1404: upfront_tax_acct_exception EXCEPTION;
1405:
1406: l_billed_sty_id NUMBER;
1407: l_transaction_amount NUMBER;