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 644: FROM okc_k_headers_b

640:
641: -- get the K end date
642: CURSOR l_contract_csr(cp_chr_id IN NUMBER) IS
643: SELECT END_DATE
644: FROM okc_k_headers_b
645: WHERE id = cp_chr_id;
646:
647: l_discount_incl_terminated BOOLEAN := FALSE;
648: l_proration_factor NUMBER;

Line 1027: FROM okc_k_headers_b chrb

1023: --Bug 4631549
1024: --cursor to find if this is a re-lease contract
1025: Cursor l_chrb_csr (p_chr_id in number) is
1026: SELECT chrb.orig_system_source_code
1027: FROM okc_k_headers_b chrb
1028: where chrb.id = p_chr_id;
1029:
1030: l_chrb_rec l_chrb_csr%ROWTYPE;
1031:

Line 1076: FROM OKC_K_HEADERS_B CHR

1072: CURSOR c_dnz_chr_id_validate(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
1073: SELECT 1
1074: --FROM DUAL
1075: --WHERE EXISTS (SELECT 1
1076: FROM OKC_K_HEADERS_B CHR
1077: WHERE CHR.id = p_dnz_chr_id; --);
1078: BEGIN
1079: -- initialize return status
1080: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 1931: FROM OKC_K_HEADERS_B

1927:
1928: --Bug# 5150150 -- start
1929: CURSOR l_sys_source_code_csr (p_chr_id NUMBER) IS
1930: SELECT ID,ORIG_SYSTEM_SOURCE_CODE
1931: FROM OKC_K_HEADERS_B
1932: WHERE ID = p_chr_id;
1933:
1934: l_chr_id okc_k_headers_b.id%type;
1935: l_orig_systm_source_code okc_k_headers_b.orig_system_source_code%type;

Line 1934: l_chr_id okc_k_headers_b.id%type;

1930: SELECT ID,ORIG_SYSTEM_SOURCE_CODE
1931: FROM OKC_K_HEADERS_B
1932: WHERE ID = p_chr_id;
1933:
1934: l_chr_id okc_k_headers_b.id%type;
1935: l_orig_systm_source_code okc_k_headers_b.orig_system_source_code%type;
1936: --Bug# 5150150 -- end
1937: l_feeline_rec l_fee_csr%ROWTYPE;
1938: l_discount_incl_terminated BOOLEAN := FALSE;

Line 1935: l_orig_systm_source_code okc_k_headers_b.orig_system_source_code%type;

1931: FROM OKC_K_HEADERS_B
1932: WHERE ID = p_chr_id;
1933:
1934: l_chr_id okc_k_headers_b.id%type;
1935: l_orig_systm_source_code okc_k_headers_b.orig_system_source_code%type;
1936: --Bug# 5150150 -- end
1937: l_feeline_rec l_fee_csr%ROWTYPE;
1938: l_discount_incl_terminated BOOLEAN := FALSE;
1939:

Line 2860: FROM OKC_K_HEADERS_B

2856:
2857: -- cursor to get the contract number
2858: CURSOR contract_num_csr IS
2859: SELECT contract_number
2860: FROM OKC_K_HEADERS_B
2861: WHERE id = p_khr_id;
2862:
2863: -- Fetch contract days in a year
2864: CURSOR days_in_year IS

Line 3028: FROM OKC_K_HEADERS_B

3024:
3025: -- cursor to get the contract number
3026: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
3027: SELECT contract_number
3028: FROM OKC_K_HEADERS_B
3029: WHERE id = p_ctr_id;
3030:
3031: -- BUG 4730646. Changing cursor.
3032: -- CURSOR lookup_csr(p_ctr_id NUMBER) IS

Line 3147: FROM OKC_K_HEADERS_B

3143:
3144: -- cursor to get the contract number
3145: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
3146: SELECT contract_number
3147: FROM OKC_K_HEADERS_B
3148: WHERE id = p_ctr_id;
3149:
3150:
3151: -- Bug 4737551. Commenting below cursor and writing new select statement. SGIYER.

Line 3328: FROM OKC_K_HEADERS_B

3324:
3325: -- cursor to get the contract number
3326: CURSOR contract_num_csr IS
3327: SELECT contract_number
3328: FROM OKC_K_HEADERS_B
3329: WHERE id = p_khr_id;
3330:
3331: -- Bug 5055714. Commenting below derivation. Using utility provided instead.
3332: -- CURSOR principal_bal_csr(p_ctr_id NUMBER, p_start_date DATE, p_end_date DATE, p_prin_bal_id NUMBER) IS

Line 5078: FROM okc_k_headers_b a, okl_k_headers b

5074:
5075: -- Get the financial product of the contract
5076: CURSOR l_get_fin_product(cp_khr_id IN NUMBER) IS
5077: SELECT a.start_date, a.contract_number, b.pdt_id
5078: FROM okc_k_headers_b a, okl_k_headers b
5079: WHERE a.id = b.id
5080: AND a.id = cp_khr_id;
5081:
5082: SUBTYPE pdtv_rec_type IS OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;

Line 5809: SELECT start_date FROM okc_k_headers_b

5805:
5806: -- contract start date
5807: CURSOR contract_start_date_csr(p_khr_id NUMBER)
5808: IS
5809: SELECT start_date FROM okc_k_headers_b
5810: WHERE id = p_khr_id;
5811:
5812: l_streams_repo_policy VARCHAR2(80); -- MGAAP 7263041
5813:

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

6025: 16-Aug-2007, ankushar Bug# 5499193
6026: start changes, modified the cursor to replace reference to okl_cnsld_ar_strms_b
6027: */
6028: okl_bpd_tld_ar_lines_v LSM,
6029: -- OKC_K_HEADERS_B CHR, commenting unused table, ankushar Bug# 5499193
6030: /* 16-Aug-2007 ankushar end changes */
6031: OKC_K_LINES_B CLE,
6032: OKC_LINE_STYLES_B LSE
6033: WHERE

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

6085: 16-Aug-2007, ankushar Bug# 5499193
6086: start changes, modified the cursor to replace reference to okl_cnsld_ar_strms_b
6087: */
6088: okl_bpd_tld_ar_lines_v LSM,
6089: -- OKC_K_HEADERS_B CHR, commenting unused table, ankushar Bug# 5499193
6090: /* 16-Aug-2007 ankushar end changes */
6091: OKC_K_LINES_B CLE,
6092: OKC_LINE_STYLES_B LSE
6093: WHERE

Line 6439: SELECT start_date FROM okc_k_headers_b

6435:
6436: -- contract start date
6437: CURSOR contract_start_date_csr(p_khr_id NUMBER)
6438: IS
6439: SELECT start_date FROM okc_k_headers_b
6440: WHERE id = p_khr_id;
6441:
6442: l_streams_repo_policy VARCHAR2(80); -- MGAAP 7263041
6443: BEGIN

Line 6657: FROM okc_k_headers_b

6653:
6654: CURSOR k_curr_code (c_contract_id NUMBER)
6655: IS
6656: SELECT currency_code
6657: FROM okc_k_headers_b
6658: WHERE id=c_contract_id;
6659:
6660:
6661:

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

7437: FROM okl_strm_elements selb
7438: ,okl_streams stmb
7439: ,okl_pool_contents pocb
7440: ,okl_strm_type_v styv --ankushar --Bug 6594724
7441: ,okc_k_headers_b chrb --ankushar --Bug 6594724
7442: WHERE stmb.khr_id = p_dnz_chr_id
7443: AND stmb.kle_id = p_kle_id
7444: AND stmb.sty_id = p_sty_id
7445: AND selb.stm_id = stmb.id

Line 7821: p_contract_id IN okc_k_headers_b.id%TYPE

7817: -- : 3.0 modified for Addition of Loan Contract into the Pool
7818: -- End of comments
7819: ----------------------------------------------------------------------------------
7820: FUNCTION investor_rent_accural_amout(
7821: p_contract_id IN okc_k_headers_b.id%TYPE
7822: ,p_contract_line_id IN NUMBER
7823: ) RETURN NUMBER
7824: IS
7825:

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

7825:
7826: l_rent_accrual NUMBER;
7827:
7828: -- mvasudev, 09/29/2004, Bug#3909240
7829: CURSOR c_rent_accrual(p_contract_id okc_k_headers_b.id%TYPE) IS
7830: SELECT NVL(SUM(SELB.AMOUNT),0)
7831: FROM
7832: OKL_STREAMS STMB,
7833: OKL_STRM_ELEMENTS SELB,

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

7848: AND STYS.STREAM_TYPE_SUBCLASS IN ('RENT','LOAN_PAYMENT') --Bug # 6740000 ssdeshpa--For Loan Contracts Addition into the Pool
7849: AND POC.status_code <> Okl_Pool_Pvt.G_POC_STS_PENDING --Added by VARANGAN -Pool Contents Impact(Bug#6658065)
7850: );
7851:
7852: CURSOR c_rent_accrual_pending(p_contract_id okc_k_headers_b.id%TYPE) IS
7853: SELECT NVL(SUM(SELB.AMOUNT),0)
7854: FROM
7855: OKL_STREAMS STMB,
7856: OKL_STRM_ELEMENTS SELB,

Line 7930: p_contract_id IN okc_k_headers_b.id%TYPE

7926: -- Version : 1.0
7927: -- End of comments
7928: ----------------------------------------------------------------------------------
7929: FUNCTION investor_user_amount_stake(
7930: p_contract_id IN okc_k_headers_b.id%TYPE
7931: ,p_contract_line_id IN NUMBER
7932: ) RETURN NUMBER
7933: IS
7934: l_amount NUMBER;

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

7932: ) RETURN NUMBER
7933: IS
7934: l_amount NUMBER;
7935:
7936: CURSOR c_amt_stake(p_contract_id okc_k_headers_b.id%TYPE) IS
7937: SELECT
7938: NVL(SUM(NVL(KLEB.AMOUNT,0)),0)
7939: FROM
7940: OKL_K_LINES KLEB,

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

7947: CLEB.DNZ_CHR_ID = p_contract_id;
7948: -- akjain 01-28-2004
7949: -- modified the cursor to simplify the query, removed join with OKX_PARTY
7950:
7951: CURSOR c_add_amt_stake(p_contract_id okc_k_headers_b.id%TYPE) IS
7952: SELECT
7953: NVL(SUM(NVL(KLEB.AMOUNT_STAKE,0)),0)
7954: FROM
7955: OKL_K_LINES KLEB,

Line 8024: p_contract_id IN okc_k_headers_b.id%TYPE

8020: -- comments : Bug # 6740000 modified for the Addition of Loan Contracts into the Pool changes
8021: -- End of comments
8022: ----------------------------------------------------------------------------------
8023: FUNCTION investor_stream_amount(
8024: p_contract_id IN okc_k_headers_b.id%TYPE
8025: ,p_contract_line_id IN NUMBER
8026: ) RETURN NUMBER
8027: IS
8028:

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

8031: l_percent_stake NUMBER;
8032: G_FINAL_DATE CONSTANT DATE := TO_DATE('1','j') + 5300000;
8033:
8034:
8035: CURSOR l_khr_csr(p_khr_id okc_k_headers_b.id%TYPE) IS
8036: SELECT polb.id
8037: FROM okl_pools polb
8038: WHERE polb.khr_id = p_khr_id;
8039:

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

8231:
8232: l_sum_idc_amt NUMBER;
8233:
8234: -- smereddy 06/17/03 calculates sum of fee idc
8235: CURSOR sum_idc_csr(l_dnz_chr_id okc_k_headers_b.id%TYPE) IS
8236: SELECT
8237: NVL(SUM(NVL(KLEB.initial_direct_cost,0)),0)
8238: FROM
8239: OKL_K_LINES KLEB,

Line 8277: p_contract_id IN okc_k_headers_b.id%TYPE

8273: -- 09/05/03 jsanju start
8274: --for cure calculation
8275:
8276: FUNCTION contract_delinquent_amt (
8277: p_contract_id IN okc_k_headers_b.id%TYPE
8278: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
8279: ) RETURN NUMBER IS
8280:
8281: -- ASHIM CHANGE - START

Line 8314: l_contract_number okc_k_headers_b.contract_number%TYPE;

8310: AND sm.name <> 'CURE';
8311:
8312: -- ASHIM CHANGE - END
8313:
8314: l_contract_number okc_k_headers_b.contract_number%TYPE;
8315: l_rule_name VARCHAR2(200);
8316: l_rule_value VARCHAR2(2000);
8317: l_return_Status VARCHAR2(1):=FND_Api.G_RET_STS_SUCCESS;
8318: l_id1 VARCHAR2(40);

Line 8371: p_contract_id IN okc_k_headers_b.id%TYPE

8367:
8368: END contract_delinquent_amt;
8369:
8370: FUNCTION cumulative_vendor_invoice_amt (
8371: p_contract_id IN okc_k_headers_b.id%TYPE
8372: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
8373: ) RETURN NUMBER IS
8374:
8375: CURSOR c_vendor_invoice_amt (p_contract_id IN NUMBER) IS

Line 8394: p_contract_id IN okc_k_headers_b.id%TYPE

8390: END cumulative_vendor_invoice_amt;
8391:
8392:
8393: FUNCTION contract_short_fund_amt (
8394: p_contract_id IN okc_k_headers_b.id%TYPE
8395: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
8396: ) RETURN NUMBER IS
8397:
8398: CURSOR c_get_short_fund_amt (p_contract_id IN NUMBER) IS

Line 9973: okc_k_headers_b chr

9969: else NVL(kle.oec,0) * .1
9970: end) subsidy_amount
9971: from okc_k_lines_b cle,
9972: okl_k_lines kle,
9973: okc_k_headers_b chr
9974: where chr.id = cle.dnz_chr_id
9975: and kle.id = cle.id
9976: and cle.id = p_cle_id -- FREE_FORM1 (FIN)
9977: ;

Line 9984: okc_k_headers_b CHR

9980: SELECT ROUND(MONTHS_BETWEEN(CHR.end_date, cle.start_date)) months,
9981: NVL(kle.oec,0) oec
9982: FROM okc_k_lines_b cle,
9983: okl_k_lines kle,
9984: okc_k_headers_b CHR
9985: WHERE CHR.id = cle.dnz_chr_id
9986: AND kle.id = cle.id
9987: AND cle.id = p_cle_id -- FREE_FORM1 (FIN)
9988: ;

Line 10189: okc_k_headers_b CHR,

10185: FROM okl_strm_elements sele,
10186: --okl_streams str, MGAAP 7263041
10187: okl_streams_rep_v str,
10188: okl_strm_type_v sty,
10189: okc_k_headers_b CHR,
10190: okc_statuses_b sts
10191: WHERE sele.stm_id = str.id
10192: AND str.sty_id = sty.id
10193: --AND UPPER(sty.name) = 'PRE-TAX INCOME'

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

10271: IS
10272:
10273: l_sum_financed_fee_amt NUMBER;
10274:
10275: CURSOR sum_fin_fee_csr(l_dnz_chr_id okc_k_headers_b.id%TYPE) IS
10276: SELECT
10277: NVL(SUM(NVL(KLEB.amount,0)),0)
10278: FROM
10279: OKL_K_LINES KLEB,

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

10330: IS
10331:
10332: l_sum_absorbed_fee_amt NUMBER;
10333:
10334: CURSOR sum_abs_fee_csr(l_dnz_chr_id okc_k_headers_b.id%TYPE) IS
10335: SELECT
10336: NVL(SUM(NVL(KLEB.amount,0)),0)
10337: FROM
10338: OKL_K_LINES KLEB,

Line 10401: FROM OKC_K_HEADERS_B KHR

10397: WHERE TAP.TRX_STATUS_CODE IN ('APPROVED','PROCESSED') -- push to AP
10398: AND TAP.FUNDING_TYPE_CODE IS NOT NULL
10399: -- start: cklee - okl.h ER 05/25/2005
10400: AND NOT EXISTS (SELECT 1
10401: FROM OKC_K_HEADERS_B KHR
10402: WHERE KHR.ID = TAP.KHR_ID
10403: AND ORIG_SYSTEM_SOURCE_CODE = 'OKL_LEASE_APP')
10404: -- end: cklee - okl.h ER 05/25/2005
10405: ;

Line 10492: from OKC_K_HEADERS_B crd,

10488: -- okl_txl_ap_inv_lns_all_b tpl,
10489: (
10490: select gov.dnz_chr_id chr_id,
10491: crd.ID credit_id
10492: from OKC_K_HEADERS_B crd,
10493: okc_Governances gov
10494: where crd.id = gov.chr_id_referred
10495: and crd.sts_code = 'ACTIVE'
10496: and crd.scs_code = 'CREDITLINE_CONTRACT'

Line 10500: from OKC_K_HEADERS_B crd,

10496: and crd.scs_code = 'CREDITLINE_CONTRACT'
10497: union
10498: select mla_g.dnz_chr_id chr_id,
10499: crd.ID credit_id
10500: from OKC_K_HEADERS_B crd,
10501: okc_Governances gov,
10502: OKC_K_HEADERS_B mla,
10503: okc_Governances mla_g
10504: where crd.id = gov.chr_id_referred

Line 10502: OKC_K_HEADERS_B mla,

10498: select mla_g.dnz_chr_id chr_id,
10499: crd.ID credit_id
10500: from OKC_K_HEADERS_B crd,
10501: okc_Governances gov,
10502: OKC_K_HEADERS_B mla,
10503: okc_Governances mla_g
10504: where crd.id = gov.chr_id_referred
10505: and crd.sts_code = 'ACTIVE'
10506: and crd.scs_code = 'CREDITLINE_CONTRACT'

Line 10517: FROM OKC_K_HEADERS_B KHR

10513: AND ccg.credit_id = p_credit_id
10514: AND TAP.TRX_STATUS_CODE IN ('APPROVED','PROCESSED') -- push to AP
10515: AND TAP.FUNDING_TYPE_CODE IS NOT NULL
10516: AND NOT EXISTS (SELECT 1
10517: FROM OKC_K_HEADERS_B KHR
10518: WHERE KHR.ID = tap.KHR_ID
10519: AND ORIG_SYSTEM_SOURCE_CODE = 'OKL_LEASE_APP')
10520: ;
10521:

Line 10531: from OKC_K_HEADERS_B crd,

10527: FROM okl_bpd_ar_inv_lines_v ARL,
10528: (
10529: select gov.dnz_chr_id chr_id,
10530: crd.ID credit_id
10531: from OKC_K_HEADERS_B crd,
10532: okc_Governances gov
10533: where crd.id = gov.chr_id_referred
10534: and crd.sts_code = 'ACTIVE'
10535: and crd.scs_code = 'CREDITLINE_CONTRACT'

Line 10539: from OKC_K_HEADERS_B crd,

10535: and crd.scs_code = 'CREDITLINE_CONTRACT'
10536: union
10537: select mla_g.dnz_chr_id chr_id,
10538: crd.ID credit_id
10539: from OKC_K_HEADERS_B crd,
10540: okc_Governances gov,
10541: OKC_K_HEADERS_B mla,
10542: okc_Governances mla_g
10543: where crd.id = gov.chr_id_referred

Line 10541: OKC_K_HEADERS_B mla,

10537: select mla_g.dnz_chr_id chr_id,
10538: crd.ID credit_id
10539: from OKC_K_HEADERS_B crd,
10540: okc_Governances gov,
10541: OKC_K_HEADERS_B mla,
10542: okc_Governances mla_g
10543: where crd.id = gov.chr_id_referred
10544: and crd.sts_code = 'ACTIVE'
10545: and crd.scs_code = 'CREDITLINE_CONTRACT'

Line 10625: FROM OKC_K_HEADERS_B KHR

10621: AND TAP.TRX_STATUS_CODE IN ('APPROVED','PROCESSED') -- push to AP
10622: AND TAP.FUNDING_TYPE_CODE IS NOT NULL
10623: -- start: cklee - okl.h ER 05/25/2005
10624: AND NOT EXISTS (SELECT 1
10625: FROM OKC_K_HEADERS_B KHR
10626: WHERE KHR.ID = TPL.KHR_ID
10627: AND ORIG_SYSTEM_SOURCE_CODE = 'OKL_LEASE_APP')
10628: -- end: cklee - okl.h ER 05/25/2005
10629: ;

Line 10643: FROM OKC_K_HEADERS_B KHR

10639: where TAP.TRX_STATUS_CODE IN ('APPROVED','PROCESSED') -- push to AP
10640: AND TAP.FUNDING_TYPE_CODE IS NOT NULL
10641: -- start: cklee - okl.h ER 05/25/2005
10642: AND NOT EXISTS (SELECT 1
10643: FROM OKC_K_HEADERS_B KHR
10644: WHERE KHR.ID = tap.KHR_ID
10645: AND ORIG_SYSTEM_SOURCE_CODE = 'OKL_LEASE_APP')
10646: ;
10647: -- end: cklee - okl.h ER 05/25/2005

Line 10859: FROM okc_k_headers_b

10855: AND fab.book_type_code = NVL(p_book_type_code,fab.book_type_code);
10856:
10857: CURSOR contract_start_date_csr(p_chr_id NUMBER) IS
10858: SELECT start_date
10859: FROM okc_k_headers_b
10860: WHERE id = p_chr_id;
10861:
10862: l_discount_incl_terminated BOOLEAN := FALSE;
10863: l_streams_repo_policy VARCHAR2(80); -- MGAAP 7263041

Line 11082: FROM okc_k_headers_b

11078: AND fab.book_type_code = NVL(p_book_type_code,fab.book_type_code);
11079:
11080: CURSOR contract_start_date_csr(p_chr_id NUMBER) IS
11081: SELECT start_date
11082: FROM okc_k_headers_b
11083: WHERE id = p_chr_id;
11084:
11085: l_discount_incl_terminated BOOLEAN := FALSE;
11086: l_streams_repo_policy VARCHAR2(80); -- MGAAP 7263041

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

11488: AND STSB.ste_code NOT IN ('TERMINATED', 'EXPIRED', 'CANCELLED', 'HOLD');
11489:
11490: -- fixed bug 4134296
11491: -- cursor to find total Rollover Fee Amount for a Contract
11492: CURSOR l_rollover_fee_csr(l_dnz_chr_id okc_k_headers_b.id%TYPE) IS
11493: SELECT
11494: NVL(SUM(NVL(KLEB.amount,0)),0) ROLLOVER_AMOUNT
11495: FROM
11496: OKL_K_LINES KLEB,

Line 12584: okc_k_headers_b chr

12580: SELECT cle.id
12581: FROM
12582: okc_k_lines_b cle,
12583: okl_k_lines kle,
12584: okc_k_headers_b chr
12585: WHERE
12586: chr.id = p_contract_id
12587: AND cle.chr_id = chr.id
12588: AND cle.sts_code = chr.sts_code

Line 12632: okc_k_headers_b chr

12628: SELECT cle.id
12629: FROM
12630: okc_k_lines_b cle,
12631: okl_k_lines kle,
12632: okc_k_headers_b chr
12633: WHERE
12634: chr.id = p_contract_id
12635: AND cle.chr_id = chr.id
12636: AND cle.sts_code = chr.sts_code

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

13329:
13330: -- sjalasut, Rebook Change Control Enhancement START
13331:
13332: -- function that returns the sum of unbilled RENT for all active assets on the rebook copy of the contract
13333: FUNCTION cont_rbk_unbilled_receivables(p_contract_id okc_k_headers_b.id%TYPE
13334: ,p_contract_line_id okc_k_lines_b.id%TYPE DEFAULT OKL_API.G_MISS_NUM) RETURN NUMBER IS
13335:
13336: -- get all unbilled receivables for all ACTIVE assets
13337: CURSOR cle_rents_csr(cp_contract_id okc_k_headers_b.id%TYPE) IS

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

13333: FUNCTION cont_rbk_unbilled_receivables(p_contract_id okc_k_headers_b.id%TYPE
13334: ,p_contract_line_id okc_k_lines_b.id%TYPE DEFAULT OKL_API.G_MISS_NUM) RETURN NUMBER IS
13335:
13336: -- get all unbilled receivables for all ACTIVE assets
13337: CURSOR cle_rents_csr(cp_contract_id okc_k_headers_b.id%TYPE) IS
13338: SELECT NVL(SUM(sele.amount),0)
13339: FROM okl_strm_elements sele
13340: ,okl_streams str
13341: ,okl_strm_type_v sty

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

13386: RETURN NULL;
13387: END cont_rbk_unbilled_receivables;
13388:
13389: -- function that returns the sum of pre-tax income that was not accrued for all active assets on the rebook copy of the contract
13390: FUNCTION cont_rbk_unearned_income(p_contract_id okc_k_headers_b.id%TYPE
13391: ,p_contract_line_id okc_k_lines_b.id%TYPE DEFAULT OKL_API.G_MISS_NUM) RETURN NUMBER IS
13392:
13393: CURSOR c_pre_tax_csr(cp_contract_id okc_k_headers_b.id%TYPE) IS
13394: SELECT NVL(SUM(sele.amount),0)

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

13389: -- function that returns the sum of pre-tax income that was not accrued for all active assets on the rebook copy of the contract
13390: FUNCTION cont_rbk_unearned_income(p_contract_id okc_k_headers_b.id%TYPE
13391: ,p_contract_line_id okc_k_lines_b.id%TYPE DEFAULT OKL_API.G_MISS_NUM) RETURN NUMBER IS
13392:
13393: CURSOR c_pre_tax_csr(cp_contract_id okc_k_headers_b.id%TYPE) IS
13394: SELECT NVL(SUM(sele.amount),0)
13395: FROM okl_strm_elements sele
13396: --,okl_streams str MGAAP 7263041
13397: ,okl_streams_rep_v str

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

13435: END cont_rbk_unearned_income;
13436:
13437: -- returns sum of rent not billed for all terminated assets
13438: -- do not send p_contract_line_id as okl_api.g_miss_num
13439: FUNCTION cont_tmt_unbilled_receivables(p_contract_id okc_k_headers_b.id%TYPE
13440: ,p_contract_line_id okc_k_lines_b.id%TYPE DEFAULT OKL_API.G_MISS_NUM) RETURN NUMBER IS
13441: -- get all unbilled receivables for all TERMINATED assets
13442: CURSOR cle_rents_csr(cp_contract_id okc_k_headers_b.id%TYPE
13443: ,cp_contract_line_id okc_k_lines_b.id%TYPE) IS

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

13438: -- do not send p_contract_line_id as okl_api.g_miss_num
13439: FUNCTION cont_tmt_unbilled_receivables(p_contract_id okc_k_headers_b.id%TYPE
13440: ,p_contract_line_id okc_k_lines_b.id%TYPE DEFAULT OKL_API.G_MISS_NUM) RETURN NUMBER IS
13441: -- get all unbilled receivables for all TERMINATED assets
13442: CURSOR cle_rents_csr(cp_contract_id okc_k_headers_b.id%TYPE
13443: ,cp_contract_line_id okc_k_lines_b.id%TYPE) IS
13444: SELECT NVL(SUM(sele.amount),0)
13445: FROM okl_strm_elements sele
13446: ,okl_streams str

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

13494: END cont_tmt_unbilled_receivables;
13495:
13496: -- returns sum of pre tax income not accrued for all terminated assets
13497: -- do not send p_contract_line_id as okl_api.g_miss_num
13498: FUNCTION cont_tmt_unearned_income(p_contract_id okc_k_headers_b.id%TYPE
13499: ,p_contract_line_id okc_k_lines_b.id%TYPE DEFAULT OKL_API.G_MISS_NUM) RETURN NUMBER IS
13500: 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
13501: SELECT NVL(SUM(sele.amount),0)
13502: FROM okl_strm_elements sele

Line 13500: 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

13496: -- returns sum of pre tax income not accrued for all terminated assets
13497: -- do not send p_contract_line_id as okl_api.g_miss_num
13498: FUNCTION cont_tmt_unearned_income(p_contract_id okc_k_headers_b.id%TYPE
13499: ,p_contract_line_id okc_k_lines_b.id%TYPE DEFAULT OKL_API.G_MISS_NUM) RETURN NUMBER IS
13500: 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
13501: SELECT NVL(SUM(sele.amount),0)
13502: FROM okl_strm_elements sele
13503: --,okl_streams str MGAAP 7263041
13504: ,okl_streams_rep_v str

Line 13638: FROM okc_k_headers_b

13634: RETURN NUMBER IS
13635:
13636: CURSOR c_get_lease_app IS
13637: SELECT orig_system_id1
13638: FROM okc_k_headers_b
13639: WHERE id = p_contract_id
13640: AND orig_system_source_code = 'OKL_LEASE_APP';
13641:
13642: ln_lease_app_id NUMBER;

Line 13801: FROM okc_k_party_roles_b kp, okc_k_headers_b okc

13797: ln_lap_cust_acct_id NUMBER;
13798:
13799: CURSOR c_k_get_party_custacct_info IS
13800: SELECT kp.object1_id1, okc.cust_acct_id
13801: FROM okc_k_party_roles_b kp, okc_k_headers_b okc
13802: WHERE kp.dnz_chr_id = p_contract_id
13803: AND kp.rle_code = 'LESSEE'
13804: AND kp.dnz_chr_id = okc.id;
13805:

Line 14052: FROM okc_k_headers_b

14048:
14049:
14050: CURSOR contract_start_date_csr(p_chr_id NUMBER) IS
14051: SELECT start_date
14052: FROM okc_k_headers_b
14053: WHERE id = p_chr_id;
14054:
14055: l_streams_repo_policy VARCHAR2(80); -- 7626121
14056: l_book_class FA_BOOK_CONTROLS.BOOK_CLASS%TYPE := null;

Line 14442: p_dnz_chr_id OKC_K_HEADERS_B.ID%TYPE) IS

14438: AND clex.id = cle.cle_id);
14439:
14440: --Cursor for Capitalized Fee
14441: CURSOR c_cap_fee(p_line_id VARCHAR2,
14442: p_dnz_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
14443: SELECT SUM(kle_cov.capital_amount) Cap_fee
14444: FROM okc_line_styles_b lseb,
14445: okc_k_items cim,
14446: okl_k_lines kle_cov,