APPS.OKL_LOSS_PROV_PVT dependencies on OKC_K_HEADERS_B

Line 209: FROM OKC_K_HEADERS_B

205:
206: -- cursor to get the contract number
207: CURSOR contract_num_csr IS
208: SELECT contract_number
209: FROM OKC_K_HEADERS_B
210: WHERE id = p_cntrct_id;
211:
212: CURSOR principal_bal_csr(p_ctr_id NUMBER, p_start_date DATE, p_end_date DATE, p_prin_bal_id NUMBER) IS
213: SELECT SUM(ste.amount)

Line 384: FROM OKC_K_HEADERS_B

380:
381: -- Cursor to select currency information for the contract. Bug 2712001
382: CURSOR currency_info_csr(p_khr_id NUMBER) IS
383: SELECT currency_code
384: FROM OKC_K_HEADERS_B
385: WHERE id = p_khr_id;
386:
387: -- cursor to get the rev rec method .. racheruv. Bug 6342556
388: CURSOR get_rev_rec_method_csr(p_chr_id NUMBER) IS

Line 508: FROM OKC_K_HEADERS_B CHR,

504: -- Get Contract Salesperson
505: -- 30-Apr-2004. Bug 3596651. Cursor provided by Sarvanan.
506: CURSOR l_salesperson_csr (cp_chr_id IN NUMBER) IS
507: SELECT con.object1_id1
508: FROM OKC_K_HEADERS_B CHR,
509: OKC_CONTACT_SOURCES cso,
510: OKC_K_PARTY_ROLES_B kpr,
511: OKC_CONTACTS con
512: WHERE CHR.id = cp_chr_id

Line 537: FROM OKC_K_HEADERS_B

533:
534: -- cursor to get bill-to-site of customer at contract level
535: CURSOR chr_bill_to_site_csr (p_chr_id NUMBER) IS
536: SELECT bill_to_site_use_id
537: FROM OKC_K_HEADERS_B
538: WHERE id = p_chr_id;
539:
540: l_sales_person_id OKC_CONTACTS_V.OBJECT1_ID1%TYPE;
541: l_counter NUMBER := 1;

Line 1021: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

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;
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;

Line 1095: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr

1091: ,khr.currency_conversion_rate
1092: ,khr.currency_conversion_date
1093: -- get the last interest calc date .. racheruv. Bug 6342556
1094: ,TRUNC(nvl(khr.date_last_interim_interest_cal, chr.start_date)) last_int_calc_date
1095: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr
1096: WHERE khr.pdt_id = p_pdt_id
1097: AND chr.id = khr.id
1098: AND sts_code IN ('BOOKED','EVERGREEN')
1099: AND chr.scs_code = 'LEASE';

Line 1111: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr

1107: ,chr.currency_code
1108: ,khr.currency_conversion_type
1109: ,khr.currency_conversion_rate
1110: ,khr.currency_conversion_date
1111: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr
1112: WHERE khr.pdt_id = p_pdt_id
1113: AND chr.id = khr.id
1114: AND sts_code = 'ACTIVE'
1115: AND chr.scs_code = 'INVESTOR';

Line 1222: OKC_K_HEADERS_B chr,

1218: poc.streams_to_date streams_to_date
1219: FROM OKL_POOLS pol,
1220: OKL_POOL_CONTENTS poc,
1221: OKL_STRM_TYPE_B sty,
1222: OKC_K_HEADERS_B chr,
1223: OKL_K_HEADERS khr
1224: WHERE pol.khr_id = p_agr_id
1225: AND pol.id = poc.pol_id
1226: AND poc.status_code = 'ACTIVE'

Line 2314: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

2310: l_set_of_books_id OKL_SYS_ACCT_OPTS.SET_OF_BOOKS_ID%TYPE;
2311: l_product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE;
2312: l_sty_id OKL_STRM_TYPE_V.ID%TYPE;
2313: l_sysdate DATE := SYSDATE;
2314: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
2315: l_period_start_date DATE;
2316: l_period_end_date DATE;
2317: l_period_name VARCHAR2(2000);
2318: l_period_status VARCHAR2(1);

Line 2410: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr

2406: SELECT chr.currency_code currency_code,
2407: khr.currency_conversion_type currency_conversion_type,
2408: khr.currency_conversion_date currency_conversion_date,
2409: khr.currency_conversion_rate currency_conversion_rate
2410: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr
2411: WHERE chr.id = p_khr_id
2412: AND chr.id = khr.id;
2413:
2414: