DBA Data[Home] [Help]

APPS.OKL_LA_STREAM_PVT dependencies on OKL_K_HEADERS

Line 9: pre_Tax_yield okl_k_headers.pre_tax_yield%type,

5: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
6:
7: -- Store the yields types
8: TYPE yields_type IS RECORD (
9: pre_Tax_yield okl_k_headers.pre_tax_yield%type,
10: after_tax_yield okl_k_headers.after_tax_yield%type,
11: pre_tax_irr okl_k_headers.pre_tax_irr%type,
12: after_tax_irr okl_k_headers.after_tax_irr%type,
13: implicit_interest_rate okl_k_headers.implicit_interest_rate%type,

Line 10: after_tax_yield okl_k_headers.after_tax_yield%type,

6:
7: -- Store the yields types
8: TYPE yields_type IS RECORD (
9: pre_Tax_yield okl_k_headers.pre_tax_yield%type,
10: after_tax_yield okl_k_headers.after_tax_yield%type,
11: pre_tax_irr okl_k_headers.pre_tax_irr%type,
12: after_tax_irr okl_k_headers.after_tax_irr%type,
13: implicit_interest_rate okl_k_headers.implicit_interest_rate%type,
14: sub_pre_Tax_yield okl_k_headers.sub_pre_tax_yield%type,

Line 11: pre_tax_irr okl_k_headers.pre_tax_irr%type,

7: -- Store the yields types
8: TYPE yields_type IS RECORD (
9: pre_Tax_yield okl_k_headers.pre_tax_yield%type,
10: after_tax_yield okl_k_headers.after_tax_yield%type,
11: pre_tax_irr okl_k_headers.pre_tax_irr%type,
12: after_tax_irr okl_k_headers.after_tax_irr%type,
13: implicit_interest_rate okl_k_headers.implicit_interest_rate%type,
14: sub_pre_Tax_yield okl_k_headers.sub_pre_tax_yield%type,
15: sub_after_tax_yield okl_k_headers.sub_after_tax_yield%type,

Line 12: after_tax_irr okl_k_headers.after_tax_irr%type,

8: TYPE yields_type IS RECORD (
9: pre_Tax_yield okl_k_headers.pre_tax_yield%type,
10: after_tax_yield okl_k_headers.after_tax_yield%type,
11: pre_tax_irr okl_k_headers.pre_tax_irr%type,
12: after_tax_irr okl_k_headers.after_tax_irr%type,
13: implicit_interest_rate okl_k_headers.implicit_interest_rate%type,
14: sub_pre_Tax_yield okl_k_headers.sub_pre_tax_yield%type,
15: sub_after_tax_yield okl_k_headers.sub_after_tax_yield%type,
16: sub_pre_tax_irr okl_k_headers.sub_pre_tax_irr%TYPE,

Line 13: implicit_interest_rate okl_k_headers.implicit_interest_rate%type,

9: pre_Tax_yield okl_k_headers.pre_tax_yield%type,
10: after_tax_yield okl_k_headers.after_tax_yield%type,
11: pre_tax_irr okl_k_headers.pre_tax_irr%type,
12: after_tax_irr okl_k_headers.after_tax_irr%type,
13: implicit_interest_rate okl_k_headers.implicit_interest_rate%type,
14: sub_pre_Tax_yield okl_k_headers.sub_pre_tax_yield%type,
15: sub_after_tax_yield okl_k_headers.sub_after_tax_yield%type,
16: sub_pre_tax_irr okl_k_headers.sub_pre_tax_irr%TYPE,
17: sub_after_tax_irr okl_k_headers.sub_after_tax_irr%type,

Line 14: sub_pre_Tax_yield okl_k_headers.sub_pre_tax_yield%type,

10: after_tax_yield okl_k_headers.after_tax_yield%type,
11: pre_tax_irr okl_k_headers.pre_tax_irr%type,
12: after_tax_irr okl_k_headers.after_tax_irr%type,
13: implicit_interest_rate okl_k_headers.implicit_interest_rate%type,
14: sub_pre_Tax_yield okl_k_headers.sub_pre_tax_yield%type,
15: sub_after_tax_yield okl_k_headers.sub_after_tax_yield%type,
16: sub_pre_tax_irr okl_k_headers.sub_pre_tax_irr%TYPE,
17: sub_after_tax_irr okl_k_headers.sub_after_tax_irr%type,
18: sub_impl_interest_rate okl_k_headers.sub_impl_interest_rate%type);

Line 15: sub_after_tax_yield okl_k_headers.sub_after_tax_yield%type,

11: pre_tax_irr okl_k_headers.pre_tax_irr%type,
12: after_tax_irr okl_k_headers.after_tax_irr%type,
13: implicit_interest_rate okl_k_headers.implicit_interest_rate%type,
14: sub_pre_Tax_yield okl_k_headers.sub_pre_tax_yield%type,
15: sub_after_tax_yield okl_k_headers.sub_after_tax_yield%type,
16: sub_pre_tax_irr okl_k_headers.sub_pre_tax_irr%TYPE,
17: sub_after_tax_irr okl_k_headers.sub_after_tax_irr%type,
18: sub_impl_interest_rate okl_k_headers.sub_impl_interest_rate%type);
19: SUBTYPE yields_rec_type IS yields_type;

Line 16: sub_pre_tax_irr okl_k_headers.sub_pre_tax_irr%TYPE,

12: after_tax_irr okl_k_headers.after_tax_irr%type,
13: implicit_interest_rate okl_k_headers.implicit_interest_rate%type,
14: sub_pre_Tax_yield okl_k_headers.sub_pre_tax_yield%type,
15: sub_after_tax_yield okl_k_headers.sub_after_tax_yield%type,
16: sub_pre_tax_irr okl_k_headers.sub_pre_tax_irr%TYPE,
17: sub_after_tax_irr okl_k_headers.sub_after_tax_irr%type,
18: sub_impl_interest_rate okl_k_headers.sub_impl_interest_rate%type);
19: SUBTYPE yields_rec_type IS yields_type;
20:

Line 17: sub_after_tax_irr okl_k_headers.sub_after_tax_irr%type,

13: implicit_interest_rate okl_k_headers.implicit_interest_rate%type,
14: sub_pre_Tax_yield okl_k_headers.sub_pre_tax_yield%type,
15: sub_after_tax_yield okl_k_headers.sub_after_tax_yield%type,
16: sub_pre_tax_irr okl_k_headers.sub_pre_tax_irr%TYPE,
17: sub_after_tax_irr okl_k_headers.sub_after_tax_irr%type,
18: sub_impl_interest_rate okl_k_headers.sub_impl_interest_rate%type);
19: SUBTYPE yields_rec_type IS yields_type;
20:
21: TYPE strm_rec IS RECORD (

Line 18: sub_impl_interest_rate okl_k_headers.sub_impl_interest_rate%type);

14: sub_pre_Tax_yield okl_k_headers.sub_pre_tax_yield%type,
15: sub_after_tax_yield okl_k_headers.sub_after_tax_yield%type,
16: sub_pre_tax_irr okl_k_headers.sub_pre_tax_irr%TYPE,
17: sub_after_tax_irr okl_k_headers.sub_after_tax_irr%type,
18: sub_impl_interest_rate okl_k_headers.sub_impl_interest_rate%type);
19: SUBTYPE yields_rec_type IS yields_type;
20:
21: TYPE strm_rec IS RECORD (
22: id OKL_STRM_TYPE_B.ID%TYPE ,

Line 44: okl_k_headers khr,

40: NVL(pdt.reporting_pdt_id, -1) report_pdt_id,
41: chr.currency_code currency_code,
42: khr.term_duration term
43: FROM okc_k_headers_v chr,
44: okl_k_headers khr,
45: okl_products_v pdt
46: WHERE khr.id = chr.id
47: AND chr.id = chrId
48: AND khr.pdt_id = pdt.id(+);

Line 267: okl_k_headers khr,

263: NVL(pdt.reporting_pdt_id, -1) report_pdt_id,
264: chr.currency_code currency_code,
265: khr.term_duration term
266: FROM okc_k_headers_v chr,
267: okl_k_headers khr,
268: okl_products_v pdt
269: WHERE khr.id = chr.id
270: AND chr.id = chrId
271: AND khr.pdt_id = pdt.id(+);