[Home] [Help]
61: -- -----------------------------------------------------
62: -- Variable definitions for line level bill-to_support
63: -- -----------------------------------------------------
64: l_pmth_line_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
65: l_rct_line_method_code AR_RECEIPT_CLASSES.CREATION_METHOD_CODE%TYPE;
66: lp_rct_line_method_code AR_RECEIPT_CLASSES.CREATION_METHOD_CODE%TYPE;
67: l_bank_line_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
68:
69: l_line_cust_bank_acct_id OKL_TRX_AR_INVOICES_V.customer_bank_account_id%TYPE;
62: -- Variable definitions for line level bill-to_support
63: -- -----------------------------------------------------
64: l_pmth_line_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
65: l_rct_line_method_code AR_RECEIPT_CLASSES.CREATION_METHOD_CODE%TYPE;
66: lp_rct_line_method_code AR_RECEIPT_CLASSES.CREATION_METHOD_CODE%TYPE;
67: l_bank_line_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
68:
69: l_line_cust_bank_acct_id OKL_TRX_AR_INVOICES_V.customer_bank_account_id%TYPE;
70: l_line_cust_address_id OKL_TRX_AR_INVOICES_V.ibt_id%TYPE;
144: -- Bank Account Cursor
145: CURSOR rcpt_method_csr ( p_rct_method_id NUMBER) IS
146: SELECT C.CREATION_METHOD_CODE
147: FROM AR_RECEIPT_METHODS M,
148: AR_RECEIPT_CLASSES C
149: WHERE M.RECEIPT_CLASS_ID = C.RECEIPT_CLASS_ID AND
150: M.receipt_method_id = p_rct_method_id;
151:
152: CURSOR cust_line_bank_csr ( p_khr_id NUMBER, p_kle_id NUMBER ) IS
1473: --akrangan added ebtax billing impacts coding end
1474:
1475: lx_dist_tbl dist_tbl_type; -- rmunjulu R12 Fixes
1476: n NUMBER; -- rmunjulu R12 Fixes
1477: l_creation_method_code AR_RECEIPT_CLASSES.CREATION_METHOD_CODE%TYPE;
1478:
1479: -- gboomina added for bug 7513216 - start
1480: cursor get_khr_id_csr (p_contract_number okc_k_headers_all_b.contract_number%type)
1481: is