APPS.OKL_LOSS_PROV_PVT dependencies on OKL_BUCKETS_V

Line 1024: l_least_bucket_rate OKL_BUCKETS_V.LOSS_RATE%TYPE;

1020: l_cntrct_id OKL_K_HEADERS_FULL_V.ID%TYPE;
1021: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
1022: l_try_id OKL_TRX_TYPES_V.ID%TYPE;
1023: l_deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE;
1024: l_least_bucket_rate OKL_BUCKETS_V.LOSS_RATE%TYPE;
1025: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
1026: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
1027: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;
1028: l_currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE;

Line 1121: FROM OKX_AGING_BUCKETS_V okx, OKL_BUCKETS_V bkt

1117:
1118: -- cursor to retrieve the aging bucket lines
1119: CURSOR bucket_lines_csr (l_bucket_id OKX_AGING_BUCKETS_V.AGING_BUCKET_ID%TYPE) IS
1120: SELECT okx.aging_bucket_line_id, bkt.id bkt_id, okx.bucket_name, okx.days_start, okx.days_to, bkt.loss_rate
1121: FROM OKX_AGING_BUCKETS_V okx, OKL_BUCKETS_V bkt
1122: WHERE okx.aging_bucket_id = l_bucket_id
1123: AND okx.aging_bucket_line_id = bkt.ibc_id
1124: AND bkt.end_date IS NULL
1125: ORDER by okx.bucket_sequence_num;

Line 1144: FROM OKL_BUCKETS_V

1140:
1141: -- cursor to get the least loss rate for the bucket
1142: CURSOR least_rate_csr (p_aging_bucket_line_id OKX_AGING_BUCKETS_V.AGING_BUCKET_LINE_ID%TYPE) IS
1143: SELECT loss_rate
1144: FROM OKL_BUCKETS_V
1145: WHERE IBC_ID = p_aging_bucket_line_id
1146: AND end_date IS NULL;
1147:
1148: -- cursor to get product name

Line 1528: l_loss_rate OKL_BUCKETS_V.LOSS_RATE%TYPE;

1524: l_gen_loss_fnd VARCHAR2(1) := 'N';
1525: l_no_of_days NUMBER;
1526: l_due_amt NUMBER;
1527: l_inv_loss_amt NUMBER :=0;
1528: l_loss_rate OKL_BUCKETS_V.LOSS_RATE%TYPE;
1529: l_trx_header_total OKL_TRX_CONTRACTS.AMOUNT%TYPE := 0;
1530: l_converted_net_book_value NUMBER;
1531: l_sty_id OKL_TXL_CNTRCT_LNS.STY_ID%TYPE; --:= to_number(p_sty_id);
1532: l_sty_name OKL_STRM_TYPE_V.NAME%TYPE;