[Home] [Help]
32:
33: -- rmunjulu BUG 5050158
34: CURSOR get_contract_end_date_csr (p_contract_id IN NUMBER ) IS
35: SELECT end_date
36: FROM okc_k_headers_b
37: WHERE id = p_contract_id;
38:
39: l_last_int_calc_till_date DATE;
40: l_last_sch_int_calc_date DATE;
538:
539: -- Check if the Financial asset is serviced thru OKS - Will return the OKL Contract
540: CURSOR link_csr (p_kle_id OKC_K_LINES_V.ID%TYPE) IS
541: SELECT KREL.chr_id okl_contract_id
542: FROM OKC_K_HEADERS_B OKS_CHRB,
543: OKC_LINE_STYLES_B OKS_COV_PD_LSE,
544: OKC_K_LINES_B OKS_COV_PD_CLEB,
545: OKC_K_REL_OBJS KREL,
546: OKC_LINE_STYLES_B LNK_SRV_LSE,
689: SELECT COUNT(CLE.id) no_of_contract_assets
690: FROM OKC_K_LINES_B CLE,
691: OKC_LINE_STYLES_B LSE,
692: --OKC_STATUSES_B STS,
693: OKC_K_HEADERS_B CHR
694: WHERE CLE.lse_id = LSE.id
695: AND LSE.lty_code = 'FREE_FORM1'
696: --AND CLE.sts_code = STS.code
697: AND CLE.sts_code = CHR.sts_code
819: CURSOR get_additional_assets_csr (p_khr_id IN NUMBER, p_qte_id IN NUMBER) IS
820: SELECT 1
821: FROM OKC_K_LINES_B CLE,
822: OKC_LINE_STYLES_B LSE,
823: OKC_K_HEADERS_B CHR
824: WHERE CLE.lse_id = LSE.id
825: AND LSE.lty_code = 'FREE_FORM1'
826: AND CLE.sts_code = CHR.sts_code
827: AND CHR.id = CLE.dnz_chr_id
1140: -- RMUNJULU 05-JAN-04 new cursor to get the contract status
1141: -- Get the sts_code for the contract
1142: CURSOR get_k_sts_csr (p_chr_id IN NUMBER) IS
1143: SELECT CHR.sts_code
1144: FROM OKC_K_HEADERS_B CHR
1145: WHERE CHR.id = p_chr_id;
1146:
1147: -- RMUNJULU 05-JAN-04 Added variable
1148: l_sts_code OKC_K_HEADERS_B.sts_code%TYPE;
1144: FROM OKC_K_HEADERS_B CHR
1145: WHERE CHR.id = p_chr_id;
1146:
1147: -- RMUNJULU 05-JAN-04 Added variable
1148: l_sts_code OKC_K_HEADERS_B.sts_code%TYPE;
1149:
1150: BEGIN
1151: IF (is_debug_procedure_on) THEN
1152: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
1799: -- sure that the contract has a logical post
1800: -- booking status.
1801: CURSOR k_contractstatus_csr IS
1802: SELECT khr.contract_number, sts.ste_code, sts.meaning
1803: FROM okc_k_headers_b khr, okc_statuses_v sts
1804: WHERE khr.sts_code = sts.code
1805: AND khr.id = p_contract_id;
1806:
1807: -- Cursor to check if contract locked
2508: SELECT id,
2509: object_version_number,
2510: sts_code,
2511: scs_code
2512: FROM OKC_K_HEADERS_B
2513: WHERE id = p_term_rec.p_contract_id;
2514:
2515: -- Get the K deal_type
2516: -- RMUNJULU 06-MAR-03 Performance Fix Replaced K_HDR_FULL
3521:
3522: -- get contract_end_date
3523: cursor c_contract_eff_to(c_contract_id number) is
3524: select end_date
3525: from okc_k_headers_b
3526: where id = c_contract_id;
3527:
3528: --**SMODUGA added for currency conversion info
3529: -- get currency conversion info
3604:
3605: -- rmunjulu 4622198
3606: CURSOR khr_dtls_csr ( p_khr_id NUMBER ) IS
3607: SELECT chr.scs_code
3608: FROM okc_k_headers_b chr
3609: WHERE chr.id = p_khr_id;
3610:
3611: -- rmunjulu 4622198
3612: l_scs_code OKC_K_HEADERS_B.scs_code%TYPE;
3608: FROM okc_k_headers_b chr
3609: WHERE chr.id = p_khr_id;
3610:
3611: -- rmunjulu 4622198
3612: l_scs_code OKC_K_HEADERS_B.scs_code%TYPE;
3613: l_fact_synd_code FND_LOOKUPS.lookup_code%TYPE;
3614: l_inv_acct_code OKC_RULES_B.rule_information1%TYPE;
3615: --akrangan Bug 5526955 fix start
3616: CURSOR check_accrual_previous_csr IS
5471: l_quote_accpt_date DATE;
5472: l_quote_eff_date DATE;
5473: l_sty_id NUMBER;
5474: l_bpd_acc_rec OKL_ACC_CALL_PUB.bpd_acc_rec_type;
5475: l_currency_code OKC_K_HEADERS_B.currency_code%TYPE;
5476: l_loan_refund_amount NUMBER;
5477: l_functional_currency_code VARCHAR2(15);
5478: l_contract_currency_code VARCHAR2(15);
5479: l_currency_conversion_type VARCHAR2(30);