APPS.OKL_LOSS_PROV_PVT dependencies on OKX_AGING_BUCKETS_V

Line 9: bucket_id OKX_AGING_BUCKETS_V.AGING_BUCKET_ID%TYPE,

5: -- Removing sty_id parameter as API is not published
6: TYPE glpv_rec_type IS RECORD (
7: product_id OKL_TRX_CONTRACTS.PDT_ID%TYPE,
8: --sty_id OKL_STRM_TYPE_V.ID%TYPE,
9: bucket_id OKX_AGING_BUCKETS_V.AGING_BUCKET_ID%TYPE,
10: entry_date DATE,
11: tax_deductible_local OKL_TRX_CONTRACTS.TAX_DEDUCTIBLE_LOCAL%TYPE,
12: tax_deductible_corporate OKL_TRX_CONTRACTS.TAX_DEDUCTIBLE_CORPORATE%TYPE,
13: description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE);

Line 28: aging_bucket_line_id OKX_AGING_BUCKETS_V.aging_bucket_line_id%TYPE

24: provision_date OKL_TRX_CONTRACTS.DATE_TRANSACTION_OCCURRED%TYPE);
25:
26:
27: TYPE bktv_rec_type IS RECORD (
28: aging_bucket_line_id OKX_AGING_BUCKETS_V.aging_bucket_line_id%TYPE
29: ,bkt_id OKL_BUCKETS_V.ID%TYPE
30: ,loss_rate OKL_BUCKETS_V.LOSS_RATE%TYPE
31: ,bucket_name OKX_AGING_BUCKETS_V.bucket_name%TYPE
32: ,days_start OKX_AGING_BUCKETS_V.days_start%TYPE

Line 31: ,bucket_name OKX_AGING_BUCKETS_V.bucket_name%TYPE

27: TYPE bktv_rec_type IS RECORD (
28: aging_bucket_line_id OKX_AGING_BUCKETS_V.aging_bucket_line_id%TYPE
29: ,bkt_id OKL_BUCKETS_V.ID%TYPE
30: ,loss_rate OKL_BUCKETS_V.LOSS_RATE%TYPE
31: ,bucket_name OKX_AGING_BUCKETS_V.bucket_name%TYPE
32: ,days_start OKX_AGING_BUCKETS_V.days_start%TYPE
33: ,days_to OKX_AGING_BUCKETS_V.days_to%TYPE
34: ,loss_amount OKL_TXL_CNTRCT_LNS.amount%TYPE);
35:

Line 32: ,days_start OKX_AGING_BUCKETS_V.days_start%TYPE

28: aging_bucket_line_id OKX_AGING_BUCKETS_V.aging_bucket_line_id%TYPE
29: ,bkt_id OKL_BUCKETS_V.ID%TYPE
30: ,loss_rate OKL_BUCKETS_V.LOSS_RATE%TYPE
31: ,bucket_name OKX_AGING_BUCKETS_V.bucket_name%TYPE
32: ,days_start OKX_AGING_BUCKETS_V.days_start%TYPE
33: ,days_to OKX_AGING_BUCKETS_V.days_to%TYPE
34: ,loss_amount OKL_TXL_CNTRCT_LNS.amount%TYPE);
35:
36: TYPE bucket_tbl_type IS TABLE OF bktv_rec_type INDEX BY BINARY_INTEGER;

Line 33: ,days_to OKX_AGING_BUCKETS_V.days_to%TYPE

29: ,bkt_id OKL_BUCKETS_V.ID%TYPE
30: ,loss_rate OKL_BUCKETS_V.LOSS_RATE%TYPE
31: ,bucket_name OKX_AGING_BUCKETS_V.bucket_name%TYPE
32: ,days_start OKX_AGING_BUCKETS_V.days_start%TYPE
33: ,days_to OKX_AGING_BUCKETS_V.days_to%TYPE
34: ,loss_amount OKL_TXL_CNTRCT_LNS.amount%TYPE);
35:
36: TYPE bucket_tbl_type IS TABLE OF bktv_rec_type INDEX BY BINARY_INTEGER;
37: TYPE slpv_tbl_type IS TABLE OF slpv_rec_type INDEX BY BINARY_INTEGER;