APPS.OKL_LOSS_PROV_PVT dependencies on OKX_AGING_BUCKETS_V

Line 1018: l_bucket_id OKX_AGING_BUCKETS_V.AGING_BUCKET_ID%TYPE := to_number(p_bucket_id);

1014: l_org_id NUMBER;
1015: l_org_name VARCHAR2(2000);
1016: l_product_id OKL_TRX_CONTRACTS.PDT_ID%TYPE := to_number(p_product_id);
1017: l_product_name OKL_PRODUCTS_V.NAME%TYPE;
1018: l_bucket_id OKX_AGING_BUCKETS_V.AGING_BUCKET_ID%TYPE := to_number(p_bucket_id);
1019: l_entry_date DATE := FND_DATE.CANONICAL_TO_DATE(p_entry_date);
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;

Line 1119: CURSOR bucket_lines_csr (l_bucket_id OKX_AGING_BUCKETS_V.AGING_BUCKET_ID%TYPE) IS

1115: AND chr.scs_code = 'INVESTOR';
1116:
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

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 1142: CURSOR least_rate_csr (p_aging_bucket_line_id OKX_AGING_BUCKETS_V.AGING_BUCKET_LINE_ID%TYPE) IS

1138: -- WHERE stytl.id = l_sty_id
1139: -- AND stytl.LANGUAGE = USERENV('LANG');
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;