APPS.OKL_VARIABLE_INTEREST_PVT dependencies on OKL_CONTRACT_BALANCES

Line 1681: FROM okl_contract_balances ocb

1677: GROUP BY cra.receipt_date
1678: UNION ALL
1679: SELECT ocb.termination_date receipt_date,
1680: sum(ocb.termination_value_amt) principal_pmt_rcpt_amt
1681: FROM okl_contract_balances ocb
1682: WHERE ocb.khr_id = p_contract_id
1683: AND ocb.kle_id = NVL(p_line_id, kle_id)
1684: AND ocb.termination_date BETWEEN p_start_date AND p_due_date
1685: GROUP BY ocb.termination_date

Line 4592: --checks if newly created records for okl_contract_balances which have the asset balances

4588: AND vpb.source_table = 'AP_INVOICE_PAYMENTS_ALL'
4589: AND vpb.int_cal_process = 'VARIABLE_INTEREST'
4590: AND vpb.source_id = iph.invoice_payment_id);
4591:
4592: --checks if newly created records for okl_contract_balances which have the asset balances
4593: --as of the partial termination date exist prior to date passed
4594: CURSOR l_partial_term_csr(cp_khr_id NUMBER, cp_from_date DATE) IS
4595: SELECT 'Y' return_value
4596: FROM okl_contract_balances ocb

Line 4596: FROM okl_contract_balances ocb

4592: --checks if newly created records for okl_contract_balances which have the asset balances
4593: --as of the partial termination date exist prior to date passed
4594: CURSOR l_partial_term_csr(cp_khr_id NUMBER, cp_from_date DATE) IS
4595: SELECT 'Y' return_value
4596: FROM okl_contract_balances ocb
4597: WHERE ocb.khr_id = cp_khr_id
4598: AND ocb.termination_date < cp_from_date
4599: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb
4600: WHERE vpb.khr_id = ocb.khr_id

Line 4601: AND vpb.source_table = 'OKL_CONTRACT_BALANCES'

4597: WHERE ocb.khr_id = cp_khr_id
4598: AND ocb.termination_date < cp_from_date
4599: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb
4600: WHERE vpb.khr_id = ocb.khr_id
4601: AND vpb.source_table = 'OKL_CONTRACT_BALANCES'
4602: AND vpb.int_cal_process = 'VARIABLE_INTEREST'
4603: AND vpb.source_id = ocb.id);
4604:
4605: --Bug# 14179413: Include Credit Memos and Adjustments when calculating

Line 5015: --get the id's of records from okl_contract_balances which have the asset balances

5011: AND vpb.source_table = 'AP_INVOICE_PAYMENTS_ALL'
5012: AND vpb.int_cal_process = 'VARIABLE_INTEREST'
5013: AND vpb.source_id = iph.invoice_payment_id);
5014:
5015: --get the id's of records from okl_contract_balances which have the asset balances
5016: --as of the partial termination date
5017: CURSOR l_partial_term_csr(cp_khr_id NUMBER, cp_from_date DATE, cp_to_date DATE) IS
5018: SELECT ocb.id source_id
5019: , 'OKL_CONTRACT_BALANCES' source_table

Line 5019: , 'OKL_CONTRACT_BALANCES' source_table

5015: --get the id's of records from okl_contract_balances which have the asset balances
5016: --as of the partial termination date
5017: CURSOR l_partial_term_csr(cp_khr_id NUMBER, cp_from_date DATE, cp_to_date DATE) IS
5018: SELECT ocb.id source_id
5019: , 'OKL_CONTRACT_BALANCES' source_table
5020: FROM okl_contract_balances ocb
5021: WHERE ocb.khr_id = cp_khr_id
5022: AND ocb.termination_date BETWEEN cp_from_date AND cp_to_date
5023: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb

Line 5020: FROM okl_contract_balances ocb

5016: --as of the partial termination date
5017: CURSOR l_partial_term_csr(cp_khr_id NUMBER, cp_from_date DATE, cp_to_date DATE) IS
5018: SELECT ocb.id source_id
5019: , 'OKL_CONTRACT_BALANCES' source_table
5020: FROM okl_contract_balances ocb
5021: WHERE ocb.khr_id = cp_khr_id
5022: AND ocb.termination_date BETWEEN cp_from_date AND cp_to_date
5023: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb
5024: WHERE vpb.khr_id = ocb.khr_id

Line 5025: AND vpb.source_table = 'OKL_CONTRACT_BALANCES'

5021: WHERE ocb.khr_id = cp_khr_id
5022: AND ocb.termination_date BETWEEN cp_from_date AND cp_to_date
5023: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb
5024: WHERE vpb.khr_id = ocb.khr_id
5025: AND vpb.source_table = 'OKL_CONTRACT_BALANCES'
5026: AND vpb.int_cal_process = 'VARIABLE_INTEREST'
5027: AND vpb.source_id = ocb.id);
5028:
5029: