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_ACCRUAL_SEC_PVT dependencies on OKL_K_HEADERS

Line 85: okl_k_headers khr,

81: opc.streams_to_date end_date,
82: khr.deal_type deal_type
83: FROM okl_pool_contents opc,
84: okl_pools op,
85: okl_k_headers khr,
86: -- Changed for User Defined Streams
87: --okl_strm_type_tl stytl
88: okl_strm_type_b stytl
89: WHERE op.khr_id = p_inv_id

Line 129: okl_k_headers khr,

125: opc.streams_to_date end_date,
126: khr.deal_type deal_type
127: FROM okl_pool_contents opc,
128: okl_pools op,
129: okl_k_headers khr,
130: -- Changed for User Defined Streams
131: --okl_strm_type_tl stytl
132: okl_strm_type_b stytl
133: WHERE op.khr_id = p_inv_id

Line 982: OKL_K_HEADERS khr,

978: opc.streams_to_date end_date,
979: khr.deal_type deal_type
980: FROM OKL_POOL_CONTENTS opc,
981: OKL_POOLS op,
982: OKL_K_HEADERS khr,
983: OKL_STRM_TYPE_B stytl
984: WHERE op.khr_id = p_inv_id
985: AND op.id = opc.pol_id
986: AND opc.khr_id = khr.id

Line 1020: OKL_K_HEADERS khr,

1016: opc.streams_to_date end_date,
1017: khr.deal_type deal_type
1018: FROM OKL_POOL_CONTENTS opc,
1019: OKL_POOLS op,
1020: OKL_K_HEADERS khr,
1021: OKL_STRM_TYPE_B stytl
1022: WHERE op.khr_id = p_inv_id
1023: AND op.id = opc.pol_id
1024: AND opc.khr_id = khr.id

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

1406: l_stmv_rec.transaction_number := l_trx_number;
1407: l_stmv_rec.active_yn := 'Y';
1408: l_stmv_rec.date_current := l_sysdate;
1409: l_stmv_rec.source_id := p_khr_id;
1410: l_stmv_rec.source_table := 'OKL_K_HEADERS';
1411: -- create final l_stmt
1412: --l_stmt := l_stmt || l_where;
1413: --OPEN strm_csr FOR l_stmt;
1414: -- use of a parameterized cursor by zrehman on 12-Sep-2006

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

1716: l_stmv_rec.transaction_number := l_trx_number;
1717: l_stmv_rec.active_yn := 'Y';
1718: l_stmv_rec.date_current := l_sysdate;
1719: l_stmv_rec.source_id := p_khr_id;
1720: l_stmv_rec.source_table := 'OKL_K_HEADERS';
1721: -- create final l_stmt
1722: --l_stmt := l_stmt || l_where;
1723: --OPEN strm_csr FOR l_stmt;
1724: -- use of a parameterized cursor by zrehman on 12-Sep-2006

Line 1895: FROM OKL_K_HEADERS

1891:
1892: -- cursor to get deal type of lease contract.
1893: CURSOR get_deal_type_csr(p_khr_id NUMBER) IS
1894: SELECT deal_type
1895: FROM OKL_K_HEADERS
1896: WHERE id = p_khr_id;
1897:
1898: CURSOR non_accrued_streams_csr(p_khr_id NUMBER, p_sty_code VARCHAR2, p_date DATE) IS
1899: SELECT ste.id

Line 2263: OKL_K_HEADERS khr

2259: IS
2260: SELECT sty.id sty_id
2261: FROM OKL_STRM_TYPE_B sty,
2262: OKL_PROD_STRM_TYPES psty,
2263: OKL_K_HEADERS khr
2264: WHERE khr.id = chrId
2265: --AND khr.pdt_id = psty.pdt_id
2266: AND psty.pdt_id = NVL(p_product_id, khr.pdt_id) -- MGAAP 7263041
2267: AND psty.sty_id = sty.id