DBA Data[Home] [Help]

APPS.OKL_VAR_INT_REAMORT_PVT dependencies on OKL_SIF_RETS

Line 109: OKL_VARIABLE_INTEREST_PVT.print_debug('foreign key to table OKL_SIF_RETS: '||set_value_null(l_rent_tbl(i).sir_id));

105: OKL_VARIABLE_INTEREST_PVT.print_debug('l_rent_tbl element # '|| i);
106: OKL_VARIABLE_INTEREST_PVT.print_debug('----------------------------------------------------');
107: OKL_VARIABLE_INTEREST_PVT.print_debug('sequence number of the payment level: '|| set_value_null(l_rent_tbl(i).level_index_number));
108: OKL_VARIABLE_INTEREST_PVT.print_debug('number of payments for a payment level: '|| set_value_null(l_rent_tbl(i).number_of_periods));
109: OKL_VARIABLE_INTEREST_PVT.print_debug('foreign key to table OKL_SIF_RETS: '||set_value_null(l_rent_tbl(i).sir_id));
110: OKL_VARIABLE_INTEREST_PVT.print_debug('reference to the asset index number: '||set_value_null(l_rent_tbl(i).index_number));
111: OKL_VARIABLE_INTEREST_PVT.print_debug('payment type: '||set_value_null(l_rent_tbl(i).level_type));
112: OKL_VARIABLE_INTEREST_PVT.print_debug('amount: '||set_value_null(l_rent_tbl(i).amount));
113: OKL_VARIABLE_INTEREST_PVT.print_debug('advance_or_arrears: '||set_value_null(l_rent_tbl(i).advance_or_arrears));

Line 1550: OKL_SIF_RETS SIRB,

1546: p_kle_id NUMBER)
1547: IS
1548: SELECT SRLB.REAMORT_BALANCE
1549: FROM OKL_SIF_RET_LEVELS SRLB,
1550: OKL_SIF_RETS SIRB,
1551: OKL_STREAM_INTERFACES SIFB,
1552: OKL_SIF_LINES SILB
1553: WHERE SIFB.TRANSACTION_NUMBER = p_trx_number
1554: AND SIRB.TRANSACTION_NUMBER = SIFB.TRANSACTION_NUMBER