eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKC_K_HEADERS_B

Line 727: FROM okc_k_headers_b

723:
724: -- get the K end date
725: CURSOR l_contract_csr(cp_chr_id IN NUMBER) IS
726: SELECT END_DATE
727: FROM okc_k_headers_b
728: WHERE id = cp_chr_id;
729:
730: l_discount_incl_terminated BOOLEAN := FALSE;
731: l_proration_factor NUMBER;

Line 1172: FROM okc_k_headers_b chrb

1168: --Bug 4631549
1169: --cursor to find if this is a re-lease contract
1170: Cursor l_chrb_csr (p_chr_id in number) is
1171: SELECT chrb.orig_system_source_code
1172: FROM okc_k_headers_b chrb
1173: where chrb.id = p_chr_id;
1174:
1175: l_chrb_rec l_chrb_csr%ROWTYPE;
1176:

Line 1273: FROM OKC_K_HEADERS_B CHR

1269: CURSOR c_dnz_chr_id_validate(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
1270: SELECT 1
1271: --FROM DUAL
1272: --WHERE EXISTS (SELECT 1
1273: FROM OKC_K_HEADERS_B CHR
1274: WHERE CHR.id = p_dnz_chr_id; --);
1275: BEGIN
1276: -- initialize return status
1277: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 2322: FROM OKC_K_HEADERS_B

2318:
2319: --Bug# 5150150 -- start
2320: CURSOR l_sys_source_code_csr (p_chr_id NUMBER) IS
2321: SELECT ID,ORIG_SYSTEM_SOURCE_CODE
2322: FROM OKC_K_HEADERS_B
2323: WHERE ID = p_chr_id;
2324:
2325: l_chr_id okc_k_headers_b.id%type;
2326: l_orig_systm_source_code okc_k_headers_b.orig_system_source_code%type;

Line 2325: l_chr_id okc_k_headers_b.id%type;

2321: SELECT ID,ORIG_SYSTEM_SOURCE_CODE
2322: FROM OKC_K_HEADERS_B
2323: WHERE ID = p_chr_id;
2324:
2325: l_chr_id okc_k_headers_b.id%type;
2326: l_orig_systm_source_code okc_k_headers_b.orig_system_source_code%type;
2327: --Bug# 5150150 -- end
2328: l_feeline_rec l_fee_csr%ROWTYPE;
2329: l_discount_incl_terminated BOOLEAN := FALSE;

Line 2326: l_orig_systm_source_code okc_k_headers_b.orig_system_source_code%type;

2322: FROM OKC_K_HEADERS_B
2323: WHERE ID = p_chr_id;
2324:
2325: l_chr_id okc_k_headers_b.id%type;
2326: l_orig_systm_source_code okc_k_headers_b.orig_system_source_code%type;
2327: --Bug# 5150150 -- end
2328: l_feeline_rec l_fee_csr%ROWTYPE;
2329: l_discount_incl_terminated BOOLEAN := FALSE;
2330:

Line 3324: FROM OKC_K_HEADERS_B

3320:
3321: -- cursor to get the contract number
3322: CURSOR contract_num_csr IS
3323: SELECT contract_number
3324: FROM OKC_K_HEADERS_B
3325: WHERE id = p_khr_id;
3326:
3327: -- Fetch contract days in a year
3328: CURSOR days_in_year IS

Line 3492: FROM OKC_K_HEADERS_B

3488:
3489: -- cursor to get the contract number
3490: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
3491: SELECT contract_number
3492: FROM OKC_K_HEADERS_B
3493: WHERE id = p_ctr_id;
3494:
3495: -- BUG 4730646. Changing cursor.
3496: -- CURSOR lookup_csr(p_ctr_id NUMBER) IS

Line 3611: FROM OKC_K_HEADERS_B

3607:
3608: -- cursor to get the contract number
3609: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
3610: SELECT contract_number
3611: FROM OKC_K_HEADERS_B
3612: WHERE id = p_ctr_id;
3613:
3614:
3615: -- Bug 4737551. Commenting below cursor and writing new select statement. SGIYER.

Line 3792: FROM OKC_K_HEADERS_B

3788:
3789: -- cursor to get the contract number
3790: CURSOR contract_num_csr IS
3791: SELECT contract_number
3792: FROM OKC_K_HEADERS_B
3793: WHERE id = p_khr_id;
3794:
3795: -- Bug 5055714. Commenting below derivation. Using utility provided instead.
3796: -- CURSOR principal_bal_csr(p_ctr_id NUMBER, p_start_date DATE, p_end_date DATE, p_prin_bal_id NUMBER) IS

Line 5676: FROM okc_k_headers_b a, okl_k_headers b

5672:
5673: -- Get the financial product of the contract
5674: CURSOR l_get_fin_product(cp_khr_id IN NUMBER) IS
5675: SELECT a.start_date, a.contract_number, b.pdt_id
5676: FROM okc_k_headers_b a, okl_k_headers b
5677: WHERE a.id = b.id
5678: AND a.id = cp_khr_id;
5679:
5680: SUBTYPE pdtv_rec_type IS OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;

Line 6407: SELECT start_date FROM okc_k_headers_b

6403:
6404: -- contract start date
6405: CURSOR contract_start_date_csr(p_khr_id NUMBER)
6406: IS
6407: SELECT start_date FROM okc_k_headers_b
6408: WHERE id = p_khr_id;
6409:
6410: l_streams_repo_policy VARCHAR2(80); -- MGAAP 7263041
6411:

Line 6627: -- OKC_K_HEADERS_B CHR, commenting unused table, ankushar Bug# 5499193

6623: 16-Aug-2007, ankushar Bug# 5499193
6624: start changes, modified the cursor to replace reference to okl_cnsld_ar_strms_b
6625: */
6626: okl_bpd_tld_ar_lines_v LSM,
6627: -- OKC_K_HEADERS_B CHR, commenting unused table, ankushar Bug# 5499193
6628: /* 16-Aug-2007 ankushar end changes */
6629: OKC_K_LINES_B CLE,
6630: OKC_LINE_STYLES_B LSE
6631: WHERE

Line 6687: -- OKC_K_HEADERS_B CHR, commenting unused table, ankushar Bug# 5499193

6683: 16-Aug-2007, ankushar Bug# 5499193
6684: start changes, modified the cursor to replace reference to okl_cnsld_ar_strms_b
6685: */
6686: okl_bpd_tld_ar_lines_v LSM,
6687: -- OKC_K_HEADERS_B CHR, commenting unused table, ankushar Bug# 5499193
6688: /* 16-Aug-2007 ankushar end changes */
6689: OKC_K_LINES_B CLE,
6690: OKC_LINE_STYLES_B LSE
6691: WHERE

Line 7037: SELECT start_date FROM okc_k_headers_b

7033:
7034: -- contract start date
7035: CURSOR contract_start_date_csr(p_khr_id NUMBER)
7036: IS
7037: SELECT start_date FROM okc_k_headers_b
7038: WHERE id = p_khr_id;
7039:
7040: l_streams_repo_policy VARCHAR2(80); -- MGAAP 7263041
7041: BEGIN

Line 7255: FROM okc_k_headers_b

7251:
7252: CURSOR k_curr_code (c_contract_id NUMBER)
7253: IS
7254: SELECT currency_code
7255: FROM okc_k_headers_b
7256: WHERE id=c_contract_id;
7257:
7258:
7259:

Line 8090: ,okc_k_headers_b chrb --ankushar --Bug 6594724

8086: FROM okl_strm_elements selb
8087: ,okl_streams stmb
8088: ,okl_pool_contents pocb
8089: ,okl_strm_type_v styv --ankushar --Bug 6594724
8090: ,okc_k_headers_b chrb --ankushar --Bug 6594724
8091: WHERE stmb.khr_id = p_dnz_chr_id
8092: AND stmb.kle_id = p_kle_id
8093: AND stmb.sty_id = p_sty_id
8094: AND selb.stm_id = stmb.id

Line 8495: p_contract_id IN okc_k_headers_b.id%TYPE

8491: -- : 3.0 modified for Addition of Loan Contract into the Pool
8492: -- End of comments
8493: ----------------------------------------------------------------------------------
8494: FUNCTION investor_rent_accural_amout(
8495: p_contract_id IN okc_k_headers_b.id%TYPE
8496: ,p_contract_line_id IN NUMBER
8497: ) RETURN NUMBER
8498: IS
8499:

Line 8503: CURSOR c_rent_accrual(p_contract_id okc_k_headers_b.id%TYPE) IS

8499:
8500: l_rent_accrual NUMBER;
8501:
8502: -- mvasudev, 09/29/2004, Bug#3909240
8503: CURSOR c_rent_accrual(p_contract_id okc_k_headers_b.id%TYPE) IS
8504: SELECT NVL(SUM(SELB.AMOUNT),0)
8505: FROM
8506: OKL_STREAMS STMB,
8507: OKL_STRM_ELEMENTS SELB,

Line 8526: CURSOR c_rent_accrual_pending(p_contract_id okc_k_headers_b.id%TYPE) IS

8522: AND STYS.STREAM_TYPE_SUBCLASS IN ('RENT','LOAN_PAYMENT') --Bug # 6740000 ssdeshpa--For Loan Contracts Addition into the Pool
8523: AND POC.status_code <> Okl_Pool_Pvt.G_POC_STS_PENDING --Added by VARANGAN -Pool Contents Impact(Bug#6658065)
8524: );
8525:
8526: CURSOR c_rent_accrual_pending(p_contract_id okc_k_headers_b.id%TYPE) IS
8527: SELECT NVL(SUM(SELB.AMOUNT),0)
8528: FROM
8529: OKL_STREAMS STMB,
8530: OKL_STRM_ELEMENTS SELB,

Line 8604: p_contract_id IN okc_k_headers_b.id%TYPE

8600: -- Version : 1.0
8601: -- End of comments
8602: ----------------------------------------------------------------------------------
8603: FUNCTION investor_user_amount_stake(
8604: p_contract_id IN okc_k_headers_b.id%TYPE
8605: ,p_contract_line_id IN NUMBER
8606: ) RETURN NUMBER
8607: IS
8608: l_amount NUMBER;

Line 8610: CURSOR c_amt_stake(p_contract_id okc_k_headers_b.id%TYPE) IS

8606: ) RETURN NUMBER
8607: IS
8608: l_amount NUMBER;
8609:
8610: CURSOR c_amt_stake(p_contract_id okc_k_headers_b.id%TYPE) IS
8611: SELECT
8612: NVL(SUM(NVL(KLEB.AMOUNT,0)),0)
8613: FROM
8614: OKL_K_LINES KLEB,

Line 8625: CURSOR c_add_amt_stake(p_contract_id okc_k_headers_b.id%TYPE) IS

8621: CLEB.DNZ_CHR_ID = p_contract_id;
8622: -- akjain 01-28-2004
8623: -- modified the cursor to simplify the query, removed join with OKX_PARTY
8624:
8625: CURSOR c_add_amt_stake(p_contract_id okc_k_headers_b.id%TYPE) IS
8626: SELECT
8627: NVL(SUM(NVL(KLEB.AMOUNT_STAKE,0)),0)
8628: FROM
8629: OKL_K_LINES KLEB,

Line 8698: p_contract_id IN okc_k_headers_b.id%TYPE

8694: -- comments : Bug # 6740000 modified for the Addition of Loan Contracts into the Pool changes
8695: -- End of comments
8696: ----------------------------------------------------------------------------------
8697: FUNCTION investor_stream_amount(
8698: p_contract_id IN okc_k_headers_b.id%TYPE
8699: ,p_contract_line_id IN NUMBER
8700: ) RETURN NUMBER
8701: IS
8702:

Line 8709: CURSOR l_khr_csr(p_khr_id okc_k_headers_b.id%TYPE) IS

8705: l_percent_stake NUMBER;
8706: G_FINAL_DATE CONSTANT DATE := TO_DATE('1','j') + 5300000;
8707:
8708:
8709: CURSOR l_khr_csr(p_khr_id okc_k_headers_b.id%TYPE) IS
8710: SELECT polb.id
8711: FROM okl_pools polb
8712: WHERE polb.khr_id = p_khr_id;
8713:

Line 8909: CURSOR sum_idc_csr(l_dnz_chr_id okc_k_headers_b.id%TYPE) IS

8905:
8906: l_sum_idc_amt NUMBER;
8907:
8908: -- smereddy 06/17/03 calculates sum of fee idc
8909: CURSOR sum_idc_csr(l_dnz_chr_id okc_k_headers_b.id%TYPE) IS
8910: SELECT
8911: NVL(SUM(NVL(KLEB.initial_direct_cost,0)),0)
8912: FROM
8913: OKL_K_LINES KLEB,

Line 8951: p_contract_id IN okc_k_headers_b.id%TYPE

8947: -- 09/05/03 jsanju start
8948: --for cure calculation
8949:
8950: FUNCTION contract_delinquent_amt (
8951: p_contract_id IN okc_k_headers_b.id%TYPE
8952: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
8953: ) RETURN NUMBER IS
8954:
8955: -- ASHIM CHANGE - START

Line 8988: l_contract_number okc_k_headers_b.contract_number%TYPE;

8984: AND sm.name <> 'CURE';
8985:
8986: -- ASHIM CHANGE - END
8987:
8988: l_contract_number okc_k_headers_b.contract_number%TYPE;
8989: l_rule_name VARCHAR2(200);
8990: l_rule_value VARCHAR2(2000);
8991: l_return_Status VARCHAR2(1):=FND_Api.G_RET_STS_SUCCESS;
8992: l_id1 VARCHAR2(40);

Line 9045: p_contract_id IN okc_k_headers_b.id%TYPE

9041:
9042: END contract_delinquent_amt;
9043:
9044: FUNCTION cumulative_vendor_invoice_amt (
9045: p_contract_id IN okc_k_headers_b.id%TYPE
9046: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
9047: ) RETURN NUMBER IS
9048:
9049: CURSOR c_vendor_invoice_amt (p_contract_id IN NUMBER) IS

Line 9068: p_contract_id IN okc_k_headers_b.id%TYPE

9064: END cumulative_vendor_invoice_amt;
9065:
9066:
9067: FUNCTION contract_short_fund_amt (
9068: p_contract_id IN okc_k_headers_b.id%TYPE
9069: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
9070: ) RETURN NUMBER IS
9071:
9072: CURSOR c_get_short_fund_amt (p_contract_id IN NUMBER) IS

Line 10830: okc_k_headers_b chr

10826: else NVL(kle.oec,0) * .1
10827: end) subsidy_amount
10828: from okc_k_lines_b cle,
10829: okl_k_lines kle,
10830: okc_k_headers_b chr
10831: where chr.id = cle.dnz_chr_id
10832: and kle.id = cle.id
10833: and cle.id = p_cle_id -- FREE_FORM1 (FIN)
10834: ;

Line 10841: okc_k_headers_b CHR

10837: SELECT ROUND(MONTHS_BETWEEN(CHR.end_date, cle.start_date)) months,
10838: NVL(kle.oec,0) oec
10839: FROM okc_k_lines_b cle,
10840: okl_k_lines kle,
10841: okc_k_headers_b CHR
10842: WHERE CHR.id = cle.dnz_chr_id
10843: AND kle.id = cle.id
10844: AND cle.id = p_cle_id -- FREE_FORM1 (FIN)
10845: ;

Line 11046: okc_k_headers_b CHR,

11042: FROM okl_strm_elements sele,
11043: --okl_streams str, MGAAP 7263041
11044: okl_streams_rep_v str,
11045: okl_strm_type_v sty,
11046: okc_k_headers_b CHR,
11047: okc_statuses_b sts
11048: WHERE sele.stm_id = str.id
11049: AND str.sty_id = sty.id
11050: --AND UPPER(sty.name) = 'PRE-TAX INCOME'

Line 11077: okc_k_headers_b CHR,

11073: FROM okl_strm_elements sele,
11074: --okl_streams str, MGAAP 7263041
11075: okl_streams_rep_v str,
11076: okl_strm_type_v sty,
11077: okc_k_headers_b CHR,
11078: okc_statuses_b sts,
11079: okc_k_lines_b cle,
11080: okl_k_lines kle
11081: WHERE sele.stm_id = str.id

Line 11212: CURSOR sum_fin_fee_csr(l_dnz_chr_id okc_k_headers_b.id%TYPE) IS

11208: IS
11209:
11210: l_sum_financed_fee_amt NUMBER;
11211:
11212: CURSOR sum_fin_fee_csr(l_dnz_chr_id okc_k_headers_b.id%TYPE) IS
11213: SELECT
11214: NVL(SUM(NVL(KLEB.amount,0)),0)
11215: FROM
11216: OKL_K_LINES KLEB,

Line 11271: CURSOR sum_abs_fee_csr(l_dnz_chr_id okc_k_headers_b.id%TYPE) IS

11267: IS
11268:
11269: l_sum_absorbed_fee_amt NUMBER;
11270:
11271: CURSOR sum_abs_fee_csr(l_dnz_chr_id okc_k_headers_b.id%TYPE) IS
11272: SELECT
11273: NVL(SUM(NVL(KLEB.amount,0)),0)
11274: FROM
11275: OKL_K_LINES KLEB,

Line 11338: FROM OKC_K_HEADERS_B KHR

11334: WHERE TAP.TRX_STATUS_CODE IN ('APPROVED','PROCESSED') -- push to AP
11335: AND TAP.FUNDING_TYPE_CODE IS NOT NULL
11336: -- start: cklee - okl.h ER 05/25/2005
11337: AND NOT EXISTS (SELECT 1
11338: FROM OKC_K_HEADERS_B KHR
11339: WHERE KHR.ID = TAP.KHR_ID
11340: AND ORIG_SYSTEM_SOURCE_CODE = 'OKL_LEASE_APP')
11341: -- end: cklee - okl.h ER 05/25/2005
11342: ;

Line 11429: from OKC_K_HEADERS_B crd,

11425: -- okl_txl_ap_inv_lns_all_b tpl,
11426: (
11427: select gov.dnz_chr_id chr_id,
11428: crd.ID credit_id
11429: from OKC_K_HEADERS_B crd,
11430: okc_Governances gov
11431: where crd.id = gov.chr_id_referred
11432: and crd.sts_code = 'ACTIVE'
11433: and crd.scs_code = 'CREDITLINE_CONTRACT'

Line 11437: from OKC_K_HEADERS_B crd,

11433: and crd.scs_code = 'CREDITLINE_CONTRACT'
11434: union
11435: select mla_g.dnz_chr_id chr_id,
11436: crd.ID credit_id
11437: from OKC_K_HEADERS_B crd,
11438: okc_Governances gov,
11439: OKC_K_HEADERS_B mla,
11440: okc_Governances mla_g
11441: where crd.id = gov.chr_id_referred

Line 11439: OKC_K_HEADERS_B mla,

11435: select mla_g.dnz_chr_id chr_id,
11436: crd.ID credit_id
11437: from OKC_K_HEADERS_B crd,
11438: okc_Governances gov,
11439: OKC_K_HEADERS_B mla,
11440: okc_Governances mla_g
11441: where crd.id = gov.chr_id_referred
11442: and crd.sts_code = 'ACTIVE'
11443: and crd.scs_code = 'CREDITLINE_CONTRACT'

Line 11456: FROM OKC_K_HEADERS_B KHR

11452: AND TAP.FUNDING_TYPE_CODE IS NOT NULL
11453: --Bug# 10056660
11454: AND TAP.FUNDING_TYPE_CODE NOT IN ('SUPPLIER_RETENTION','MANUAL_DISB')
11455: AND NOT EXISTS (SELECT 1
11456: FROM OKC_K_HEADERS_B KHR
11457: WHERE KHR.ID = tap.KHR_ID
11458: AND ORIG_SYSTEM_SOURCE_CODE = 'OKL_LEASE_APP')
11459: ;
11460:

Line 11470: from OKC_K_HEADERS_B crd,

11466: FROM okl_bpd_ar_inv_lines_v ARL,
11467: (
11468: select gov.dnz_chr_id chr_id,
11469: crd.ID credit_id
11470: from OKC_K_HEADERS_B crd,
11471: okc_Governances gov
11472: where crd.id = gov.chr_id_referred
11473: and crd.sts_code = 'ACTIVE'
11474: and crd.scs_code = 'CREDITLINE_CONTRACT'

Line 11478: from OKC_K_HEADERS_B crd,

11474: and crd.scs_code = 'CREDITLINE_CONTRACT'
11475: union
11476: select mla_g.dnz_chr_id chr_id,
11477: crd.ID credit_id
11478: from OKC_K_HEADERS_B crd,
11479: okc_Governances gov,
11480: OKC_K_HEADERS_B mla,
11481: okc_Governances mla_g
11482: where crd.id = gov.chr_id_referred

Line 11480: OKC_K_HEADERS_B mla,

11476: select mla_g.dnz_chr_id chr_id,
11477: crd.ID credit_id
11478: from OKC_K_HEADERS_B crd,
11479: okc_Governances gov,
11480: OKC_K_HEADERS_B mla,
11481: okc_Governances mla_g
11482: where crd.id = gov.chr_id_referred
11483: and crd.sts_code = 'ACTIVE'
11484: and crd.scs_code = 'CREDITLINE_CONTRACT'

Line 11564: FROM OKC_K_HEADERS_B KHR

11560: AND TAP.TRX_STATUS_CODE IN ('APPROVED','PROCESSED') -- push to AP
11561: AND TAP.FUNDING_TYPE_CODE IS NOT NULL
11562: -- start: cklee - okl.h ER 05/25/2005
11563: AND NOT EXISTS (SELECT 1
11564: FROM OKC_K_HEADERS_B KHR
11565: WHERE KHR.ID = TPL.KHR_ID
11566: AND ORIG_SYSTEM_SOURCE_CODE = 'OKL_LEASE_APP')
11567: -- end: cklee - okl.h ER 05/25/2005
11568: ;

Line 11582: FROM OKC_K_HEADERS_B KHR

11578: where TAP.TRX_STATUS_CODE IN ('APPROVED','PROCESSED') -- push to AP
11579: AND TAP.FUNDING_TYPE_CODE IS NOT NULL
11580: -- start: cklee - okl.h ER 05/25/2005
11581: AND NOT EXISTS (SELECT 1
11582: FROM OKC_K_HEADERS_B KHR
11583: WHERE KHR.ID = tap.KHR_ID
11584: AND ORIG_SYSTEM_SOURCE_CODE = 'OKL_LEASE_APP')
11585: ;
11586: -- end: cklee - okl.h ER 05/25/2005

Line 11810: FROM okc_k_headers_b

11806: AND fab.book_type_code = NVL(p_book_type_code,fab.book_type_code);
11807:
11808: CURSOR contract_start_date_csr(p_chr_id NUMBER) IS
11809: SELECT start_date
11810: FROM okc_k_headers_b
11811: WHERE id = p_chr_id;
11812:
11813: --Bug# 16511024, Start
11814: --ndani - 15-Mar-2013 Start - Rebook Accounting Fix

Line 12170: FROM okc_k_headers_b

12166: AND fab.book_type_code = NVL(p_book_type_code,fab.book_type_code);
12167:
12168: CURSOR contract_start_date_csr(p_chr_id NUMBER) IS
12169: SELECT start_date
12170: FROM okc_k_headers_b
12171: WHERE id = p_chr_id;
12172:
12173: l_discount_incl_terminated BOOLEAN := FALSE;
12174: l_streams_repo_policy VARCHAR2(80); -- MGAAP 7263041

Line 12580: CURSOR l_rollover_fee_csr(l_dnz_chr_id okc_k_headers_b.id%TYPE) IS

12576: AND STSB.ste_code NOT IN ('TERMINATED', 'EXPIRED', 'CANCELLED', 'HOLD');
12577:
12578: -- fixed bug 4134296
12579: -- cursor to find total Rollover Fee Amount for a Contract
12580: CURSOR l_rollover_fee_csr(l_dnz_chr_id okc_k_headers_b.id%TYPE) IS
12581: SELECT
12582: NVL(SUM(NVL(KLEB.amount,0)),0) ROLLOVER_AMOUNT
12583: FROM
12584: OKL_K_LINES KLEB,

Line 12929: okc_k_headers_b chr,

12925:
12926: CURSOR get_pricing_name_csr (p_sty_id IN NUMBER, p_khr_id NUMBER) IS
12927: SELECT pricing_name
12928: FROM okl_strm_tmpt_lines_uv stl,
12929: okc_k_headers_b chr,
12930: okl_k_headers khr
12931: WHERE chr.id = p_khr_id
12932: AND khr.id = chr.id
12933: AND stl.primary_yn = 'Y'

Line 13816: okc_k_headers_b chr

13812: SELECT cle.id
13813: FROM
13814: okc_k_lines_b cle,
13815: okl_k_lines kle,
13816: okc_k_headers_b chr
13817: WHERE
13818: chr.id = p_contract_id
13819: AND cle.chr_id = chr.id
13820: AND cle.sts_code = chr.sts_code

Line 13864: okc_k_headers_b chr

13860: SELECT cle.id
13861: FROM
13862: okc_k_lines_b cle,
13863: okl_k_lines kle,
13864: okc_k_headers_b chr
13865: WHERE
13866: chr.id = p_contract_id
13867: AND cle.chr_id = chr.id
13868: AND cle.sts_code = chr.sts_code

Line 14565: FUNCTION cont_rbk_unbilled_receivables(p_contract_id okc_k_headers_b.id%TYPE

14561:
14562: -- sjalasut, Rebook Change Control Enhancement START
14563:
14564: -- function that returns the sum of unbilled RENT for all active assets on the rebook copy of the contract
14565: FUNCTION cont_rbk_unbilled_receivables(p_contract_id okc_k_headers_b.id%TYPE
14566: ,p_contract_line_id okc_k_lines_b.id%TYPE DEFAULT OKL_API.G_MISS_NUM) RETURN NUMBER IS
14567:
14568: -- get all unbilled receivables for all ACTIVE assets
14569: CURSOR cle_rents_csr(cp_contract_id okc_k_headers_b.id%TYPE) IS

Line 14569: CURSOR cle_rents_csr(cp_contract_id okc_k_headers_b.id%TYPE) IS

14565: FUNCTION cont_rbk_unbilled_receivables(p_contract_id okc_k_headers_b.id%TYPE
14566: ,p_contract_line_id okc_k_lines_b.id%TYPE DEFAULT OKL_API.G_MISS_NUM) RETURN NUMBER IS
14567:
14568: -- get all unbilled receivables for all ACTIVE assets
14569: CURSOR cle_rents_csr(cp_contract_id okc_k_headers_b.id%TYPE) IS
14570: SELECT NVL(SUM(sele.amount),0)
14571: FROM okl_strm_elements sele
14572: ,okl_streams str
14573: ,okl_strm_type_v sty

Line 14622: FUNCTION cont_rbk_unearned_income(p_contract_id okc_k_headers_b.id%TYPE

14618: RETURN NULL;
14619: END cont_rbk_unbilled_receivables;
14620:
14621: -- function that returns the sum of pre-tax income that was not accrued for all active assets on the rebook copy of the contract
14622: FUNCTION cont_rbk_unearned_income(p_contract_id okc_k_headers_b.id%TYPE
14623: ,p_contract_line_id okc_k_lines_b.id%TYPE DEFAULT OKL_API.G_MISS_NUM) RETURN NUMBER IS
14624:
14625: CURSOR c_pre_tax_csr(cp_contract_id okc_k_headers_b.id%TYPE) IS
14626: SELECT NVL(SUM(sele.amount),0)

Line 14625: CURSOR c_pre_tax_csr(cp_contract_id okc_k_headers_b.id%TYPE) IS

14621: -- function that returns the sum of pre-tax income that was not accrued for all active assets on the rebook copy of the contract
14622: FUNCTION cont_rbk_unearned_income(p_contract_id okc_k_headers_b.id%TYPE
14623: ,p_contract_line_id okc_k_lines_b.id%TYPE DEFAULT OKL_API.G_MISS_NUM) RETURN NUMBER IS
14624:
14625: CURSOR c_pre_tax_csr(cp_contract_id okc_k_headers_b.id%TYPE) IS
14626: SELECT NVL(SUM(sele.amount),0)
14627: FROM okl_strm_elements sele
14628: --,okl_streams str MGAAP 7263041
14629: ,okl_streams_rep_v str

Line 14671: FUNCTION cont_tmt_unbilled_receivables(p_contract_id okc_k_headers_b.id%TYPE

14667: END cont_rbk_unearned_income;
14668:
14669: -- returns sum of rent not billed for all terminated assets
14670: -- do not send p_contract_line_id as okl_api.g_miss_num
14671: FUNCTION cont_tmt_unbilled_receivables(p_contract_id okc_k_headers_b.id%TYPE
14672: ,p_contract_line_id okc_k_lines_b.id%TYPE DEFAULT OKL_API.G_MISS_NUM) RETURN NUMBER IS
14673: -- get all unbilled receivables for all TERMINATED assets
14674: CURSOR cle_rents_csr(cp_contract_id okc_k_headers_b.id%TYPE
14675: ,cp_contract_line_id okc_k_lines_b.id%TYPE) IS

Line 14674: CURSOR cle_rents_csr(cp_contract_id okc_k_headers_b.id%TYPE

14670: -- do not send p_contract_line_id as okl_api.g_miss_num
14671: FUNCTION cont_tmt_unbilled_receivables(p_contract_id okc_k_headers_b.id%TYPE
14672: ,p_contract_line_id okc_k_lines_b.id%TYPE DEFAULT OKL_API.G_MISS_NUM) RETURN NUMBER IS
14673: -- get all unbilled receivables for all TERMINATED assets
14674: CURSOR cle_rents_csr(cp_contract_id okc_k_headers_b.id%TYPE
14675: ,cp_contract_line_id okc_k_lines_b.id%TYPE) IS
14676: SELECT NVL(SUM(sele.amount),0)
14677: FROM okl_strm_elements sele
14678: ,okl_streams str

Line 14730: FUNCTION cont_tmt_unearned_income(p_contract_id okc_k_headers_b.id%TYPE

14726: END cont_tmt_unbilled_receivables;
14727:
14728: -- returns sum of pre tax income not accrued for all terminated assets
14729: -- do not send p_contract_line_id as okl_api.g_miss_num
14730: FUNCTION cont_tmt_unearned_income(p_contract_id okc_k_headers_b.id%TYPE
14731: ,p_contract_line_id okc_k_lines_b.id%TYPE DEFAULT OKL_API.G_MISS_NUM) RETURN NUMBER IS
14732: CURSOR c_pre_tax_csr(cp_contract_id okc_k_headers_b.id%TYPE ,cp_contract_line_id okc_k_lines_b.id%TYPE) IS
14733: SELECT NVL(SUM(sele.amount),0)
14734: FROM okl_strm_elements sele

Line 14732: CURSOR c_pre_tax_csr(cp_contract_id okc_k_headers_b.id%TYPE ,cp_contract_line_id okc_k_lines_b.id%TYPE) IS

14728: -- returns sum of pre tax income not accrued for all terminated assets
14729: -- do not send p_contract_line_id as okl_api.g_miss_num
14730: FUNCTION cont_tmt_unearned_income(p_contract_id okc_k_headers_b.id%TYPE
14731: ,p_contract_line_id okc_k_lines_b.id%TYPE DEFAULT OKL_API.G_MISS_NUM) RETURN NUMBER IS
14732: CURSOR c_pre_tax_csr(cp_contract_id okc_k_headers_b.id%TYPE ,cp_contract_line_id okc_k_lines_b.id%TYPE) IS
14733: SELECT NVL(SUM(sele.amount),0)
14734: FROM okl_strm_elements sele
14735: --,okl_streams str MGAAP 7263041
14736: ,okl_streams_rep_v str

Line 14870: FROM okc_k_headers_b

14866: RETURN NUMBER IS
14867:
14868: CURSOR c_get_lease_app IS
14869: SELECT orig_system_id1
14870: FROM okc_k_headers_b
14871: WHERE id = p_contract_id
14872: AND orig_system_source_code = 'OKL_LEASE_APP';
14873:
14874: ln_lease_app_id NUMBER;

Line 15033: FROM okc_k_party_roles_b kp, okc_k_headers_b okc

15029: ln_lap_cust_acct_id NUMBER;
15030:
15031: CURSOR c_k_get_party_custacct_info IS
15032: SELECT kp.object1_id1, okc.cust_acct_id
15033: FROM okc_k_party_roles_b kp, okc_k_headers_b okc
15034: WHERE kp.dnz_chr_id = p_contract_id
15035: AND kp.rle_code = 'LESSEE'
15036: AND kp.dnz_chr_id = okc.id;
15037:

Line 15284: FROM okc_k_headers_b

15280:
15281:
15282: CURSOR contract_start_date_csr(p_chr_id NUMBER) IS
15283: SELECT start_date
15284: FROM okc_k_headers_b
15285: WHERE id = p_chr_id;
15286:
15287: l_streams_repo_policy VARCHAR2(80); -- 7626121
15288: l_book_class FA_BOOK_CONTROLS.BOOK_CLASS%TYPE := null;

Line 15674: p_dnz_chr_id OKC_K_HEADERS_B.ID%TYPE) IS

15670: AND clex.id = cle.cle_id);
15671:
15672: --Cursor for Capitalized Fee
15673: CURSOR c_cap_fee(p_line_id VARCHAR2,
15674: p_dnz_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
15675: SELECT SUM(kle_cov.capital_amount) Cap_fee
15676: FROM okc_line_styles_b lseb,
15677: okc_k_items cim,
15678: okl_k_lines kle_cov,