[Home] [Help]
83: opc.streams_to_date end_date,
84: khr.deal_type deal_type
85: FROM okl_pool_contents opc,
86: okl_pools op,
87: okl_k_headers khr,
88: -- Changed for User Defined Streams
89: --okl_strm_type_tl stytl
90: okl_strm_type_b stytl
91: WHERE op.khr_id = p_inv_id
127: opc.streams_to_date end_date,
128: khr.deal_type deal_type
129: FROM okl_pool_contents opc,
130: okl_pools op,
131: okl_k_headers khr,
132: -- Changed for User Defined Streams
133: --okl_strm_type_tl stytl
134: okl_strm_type_b stytl
135: WHERE op.khr_id = p_inv_id
890: l_rep_stmv_rec.active_yn := 'N';
891: l_rep_stmv_rec.purpose_code := 'REPORT';
892: l_rep_stmv_rec.date_current := l_sysdate;
893: -- l_rep_stmv_rec.source_id := p_khr_id;
894: -- l_rep_stmv_rec.source_table := 'OKL_K_HEADERS';
895: END IF;
896: -----------------sechawla 09-mar-09 : MG Impact on Investor Agreement : end ------------
897:
898: --Create stream element structure for primary product
1443: opc.streams_to_date end_date,
1444: khr.deal_type deal_type
1445: FROM OKL_POOL_CONTENTS opc,
1446: OKL_POOLS op,
1447: OKL_K_HEADERS khr,
1448: OKL_STRM_TYPE_B stytl
1449: WHERE op.khr_id = p_inv_id
1450: AND op.id = opc.pol_id
1451: AND opc.khr_id = khr.id
1481: opc.streams_to_date end_date,
1482: khr.deal_type deal_type
1483: FROM OKL_POOL_CONTENTS opc,
1484: OKL_POOLS op,
1485: OKL_K_HEADERS khr,
1486: OKL_STRM_TYPE_B stytl
1487: WHERE op.khr_id = p_inv_id
1488: AND op.id = opc.pol_id
1489: AND opc.khr_id = khr.id
2075: l_stmv_rec.transaction_number := l_trx_number;
2076: l_stmv_rec.active_yn := 'Y';
2077: l_stmv_rec.date_current := l_sysdate;
2078: l_stmv_rec.source_id := p_khr_id;
2079: l_stmv_rec.source_table := 'OKL_K_HEADERS';
2080:
2081:
2082: ---------------sechawla 09-mar-09 : MG Impact on Investor Agreement : begin ------------
2083: IF l_rep_sty_id IS NOT NULL THEN
2092: l_rep_stmv_rec.active_yn := 'N';
2093: l_rep_stmv_rec.purpose_code := 'REPORT';
2094: l_rep_stmv_rec.date_current := l_sysdate;
2095: l_rep_stmv_rec.source_id := p_khr_id;
2096: l_rep_stmv_rec.source_table := 'OKL_K_HEADERS';
2097: END IF;
2098: -----------------sechawla 09-mar-09 : MG Impact on Investor Agreement : end ------------
2099:
2100:
2631: l_stmv_rec.transaction_number := l_trx_number;
2632: l_stmv_rec.active_yn := 'Y';
2633: l_stmv_rec.date_current := l_sysdate;
2634: l_stmv_rec.source_id := p_khr_id;
2635: l_stmv_rec.source_table := 'OKL_K_HEADERS';
2636: -- create final l_stmt
2637: --l_stmt := l_stmt || l_where;
2638: --OPEN strm_csr FOR l_stmt;
2639: -- use of a parameterized cursor by zrehman on 12-Sep-2006
2651: l_rep_stmv_rec.active_yn := 'N';
2652: l_rep_stmv_rec.purpose_code := 'REPORT';
2653: l_rep_stmv_rec.date_current := l_sysdate;
2654: l_rep_stmv_rec.source_id := p_khr_id;
2655: l_rep_stmv_rec.source_table := 'OKL_K_HEADERS';
2656: END IF;
2657: -----------------sechawla 09-mar-09 : MG Impact on Investor Agreement : end ------------
2658:
2659: OPEN strm_csr(l_contracts_csr.khr_id, l_final_start_date, l_contracts_csr.end_date, stream_type_purpose);
2923:
2924: -- cursor to get deal type of lease contract.
2925: CURSOR get_deal_type_csr(p_khr_id NUMBER) IS
2926: SELECT deal_type
2927: FROM OKL_K_HEADERS
2928: WHERE id = p_khr_id;
2929:
2930: CURSOR non_accrued_streams_csr(p_khr_id NUMBER, p_sty_code VARCHAR2, p_date DATE) IS
2931: SELECT ste.id
3424: IS
3425: SELECT sty.id sty_id
3426: FROM OKL_STRM_TYPE_B sty,
3427: OKL_PROD_STRM_TYPES psty,
3428: OKL_K_HEADERS khr
3429: WHERE khr.id = chrId
3430: --AND khr.pdt_id = psty.pdt_id
3431: AND psty.pdt_id = NVL(p_product_id, khr.pdt_id) -- MGAAP 7263041
3432: AND psty.sty_id = sty.id
4091:
4092: -- cursor to get deal type of lease contract.
4093: CURSOR get_deal_type_csr(p_khr_id NUMBER)
4094: IS
4095: SELECT deal_type FROM OKL_K_HEADERS WHERE id = p_khr_id;
4096:
4097:
4098: CURSOR non_accrued_streams_csr(p_khr_id NUMBER, p_sty_code VARCHAR2, p_date DATE)
4099: IS