APPS.OKL_EVERGREEN_BILLING_PVT dependencies on OKL_K_HEADERS

Line 25: FROM okl_k_headers oklh,

21: CURSOR evergreen_contracts_csr ( p_contract_number VARCHAR2 ) IS
22: SELECT oklh.id khr_id,
23: okch.contract_number,
24: nvl(stm.kle_id, -99) kle_id
25: FROM okl_k_headers oklh,
26: okc_k_headers_b okch,
27: okc_statuses_b khs,
28: okl_streams stm
29: WHERE oklh.id = okch.id

Line 56: FROM okl_k_headers_full_v khr,

52: SELECT khr.contract_number contract_number,
53: stm.kle_id, --added by pgomes
54: stm.id stm_id,
55: sty.stream_type_purpose sty_name
56: FROM okl_k_headers_full_v khr,
57: okl_streams stm,
58: okl_strm_type_v sty
59: WHERE khr.id = p_khr_id
60: AND stm.khr_id = khr.id

Line 327: ,okl_k_headers_full_v khr

323: CURSOR c_sec_strm_csr ( p_khr_id NUMBER, p_kle_id NUMBER, p_sty_id NUMBER, p_stream_element_date DATE) IS
324: select distinct khr.id khr_id
325: from okl_pool_contents_v pol
326: , OKL_POOLS pool
327: ,okl_k_headers_full_v khr
328: where pol.khr_id = p_khr_id
329: and nvl(pol.kle_id, -99) = nvl(p_kle_id, -99)
330: and pol.sty_id = p_sty_id
331: and trunc(p_stream_element_date) between trunc(pol.streams_from_date) and trunc(pol.streams_to_date)

Line 408: l_khr_id okl_k_headers.id%TYPE;

404: ------------------------------------------------------------
405: -- Declare local variables used in the program
406: ------------------------------------------------------------
407:
408: l_khr_id okl_k_headers.id%TYPE;
409: l_kle_id okl_streams.kle_id%TYPE;
410: l_sty_id okl_strm_type_v.id%TYPE;
411: l_evrgrn_strm_purpose okl_strm_type_v.stream_type_purpose%TYPE;
412: l_evrgrn_prim_strm_purpose okl_strm_type_v.stream_type_purpose%TYPE;

Line 463: l_prev_khr_id okl_k_headers.id%TYPE; --dkagrawa added for bug# 4728636

459: l_investor_agrmt_id NUMBER;
460: l_bill_freq OKC_RULES_B.object1_id1%TYPE;
461: l_primary_sty_id NUMBER;
462: l_primary_for_dep_sty_id NUMBER;
463: l_prev_khr_id okl_k_headers.id%TYPE; --dkagrawa added for bug# 4728636
464:
465: -----------------------------------------------------
466: -- Error Processing Variables
467: -----------------------------------------------------

Line 1379: l_stmv_rec.source_table := 'OKL_K_HEADERS';

1375: l_stmv_rec.date_current := sysdate;
1376: l_stmv_rec.comments := l_evrgrn_strm_purpose;
1377: IF (l_investor_agrmt_id IS NOT NULL) THEN
1378: l_stmv_rec.source_id := l_investor_agrmt_id;
1379: l_stmv_rec.source_table := 'OKL_K_HEADERS';
1380: END IF;
1381:
1382: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Creating ' || l_evrgrn_strm_purpose || ' Stream');
1383:

Line 1425: l_selv_rec.source_table := 'OKL_K_HEADERS';

1421:
1422: l_selv_rec.sel_id := l_sel_id;
1423: IF (l_investor_agrmt_id IS NOT NULL) THEN
1424: l_selv_rec.source_id := l_investor_agrmt_id;
1425: l_selv_rec.source_table := 'OKL_K_HEADERS';
1426: END IF;
1427:
1428: Okl_Sel_Pvt.insert_row(
1429: p_api_version,