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_STREAM_GENERATOR_PVT dependencies on OKC_K_HEADERS_B

Line 23: G_ORG_ID OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE;

19: and sts.code = kle.sts_code
20: and sts.ste_code not in ('HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED')
21: );
22:
23: G_ORG_ID OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE;
24: G_CURRENCY_CODE OKC_K_HEADERS_B.CURRENCY_CODE%TYPE;
25: G_DIFF_LOOKUP_CODE FND_LOOKUPS.LOOKUP_CODE%TYPE;
26: G_PRECISION NUMBER;
27: G_ROUNDING_RULE OKL_SYS_ACCT_OPTS.AEL_ROUNDING_RULE%TYPE;

Line 24: G_CURRENCY_CODE OKC_K_HEADERS_B.CURRENCY_CODE%TYPE;

20: and sts.ste_code not in ('HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED')
21: );
22:
23: G_ORG_ID OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE;
24: G_CURRENCY_CODE OKC_K_HEADERS_B.CURRENCY_CODE%TYPE;
25: G_DIFF_LOOKUP_CODE FND_LOOKUPS.LOOKUP_CODE%TYPE;
26: G_PRECISION NUMBER;
27: G_ROUNDING_RULE OKL_SYS_ACCT_OPTS.AEL_ROUNDING_RULE%TYPE;
28:

Line 771: FROM okc_k_headers_b chr_so,

767: sll.rule_information10 advance_arrears,
768: FND_NUMBER.canonical_to_number(sll.rule_information6) amount,
769: TO_NUMBER(sll.rule_information7) stub_days,
770: TO_NUMBER(sll.rule_information8) stub_amount
771: FROM okc_k_headers_b chr_so,
772: okc_k_lines_b cle,
773: okl_k_lines kle,
774: okc_line_styles_b lse,
775: okc_rules_b sll,

Line 804: FROM okc_k_headers_b chr_so,

800: SELECT DISTINCT
801: to_char(cle.id) kleId,
802: kle.amount fee_amount,
803: cle.start_date fee_start_date
804: FROM okc_k_headers_b chr_so,
805: okc_k_lines_b cle,
806: okl_k_lines kle,
807: okc_line_styles_b lse
808: WHERE chr_so.id = p_khr_id

Line 845: FROM okc_k_headers_b chr,

841: chr.start_date,
842: khr.deal_type,
843: khr.term_duration,
844: NVL(khr.generate_accrual_yn, 'Y')
845: FROM okc_k_headers_b chr,
846: okl_k_headers khr
847: WHERE khr.id = p_khr_id
848: AND chr.id = khr.id;
849:

Line 4047: FROM okc_k_headers_b chr,

4043: khr.deal_type,
4044: khr.term_duration,
4045: khr.pre_tax_irr,
4046: NVL(khr.generate_accrual_yn, 'Y')
4047: FROM okc_k_headers_b chr,
4048: okl_k_headers khr
4049: WHERE khr.id = p_khr_id
4050: AND chr.id = khr.id;
4051:

Line 4911: FROM okc_k_headers_b chr,

4907: chr.start_date,
4908: khr.deal_type,
4909: khr.term_duration,
4910: NVL(khr.generate_accrual_yn, 'Y')
4911: FROM okc_k_headers_b chr,
4912: okl_k_headers khr
4913: WHERE khr.id = p_khr_id
4914: AND chr.id = khr.id;
4915:

Line 5302: FROM okc_k_headers_b chr,

5298: chr.start_date,
5299: khr.deal_type,
5300: khr.term_duration,
5301: NVL(khr.generate_accrual_yn, 'Y')
5302: FROM okc_k_headers_b chr,
5303: okl_k_headers khr
5304: WHERE khr.id = p_khr_id
5305: AND chr.id = khr.id;
5306:

Line 5994: FROM okc_k_headers_b chr,

5990: khr.deal_type,
5991: khr.term_duration,
5992: NVL(khr.generate_accrual_yn, 'Y'),
5993: nvl(rpar.base_rate, 10) base_rate
5994: FROM okc_k_headers_b chr,
5995: okl_k_headers khr,
5996: OKL_K_RATE_PARAMS rpar
5997: WHERE khr.id = p_khr_id
5998: AND chr.id = khr.id

Line 7938: FROM okc_k_headers_b chr,

7934: chr.start_date,
7935: khr.deal_type,
7936: khr.term_duration,
7937: NVL(khr.generate_accrual_yn, 'Y')
7938: FROM okc_k_headers_b chr,
7939: okl_k_headers khr
7940: WHERE khr.id = p_khr_id
7941: AND chr.id = khr.id;
7942:

Line 10970: FROM okc_k_headers_b chr,

10966:
10967: CURSOR c_hdr IS
10968: SELECT nvl(khr.implicit_interest_rate, 0),
10969: khr.deal_type
10970: FROM okc_k_headers_b chr,
10971: okl_k_headers khr
10972: WHERE khr.id = p_khr_id
10973: AND chr.id = khr.id;
10974:

Line 11369: FROM okc_k_headers_b chr,

11365: chr.end_date,
11366: khr.deal_type,
11367: khr.term_duration,
11368: NVL(khr.generate_accrual_yn, 'Y')
11369: FROM okc_k_headers_b chr,
11370: okl_k_headers khr
11371: WHERE khr.id = p_khr_id
11372: AND chr.id = khr.id;
11373:

Line 11631: FROM okc_k_headers_b chr

11627: l_inflow c_inflows%rowtype;
11628:
11629: CURSOR c_hdr IS
11630: SELECT chr.currency_code
11631: FROM okc_k_headers_b chr
11632: WHERE chr.id = p_khr_id;
11633:
11634: l_curreny_code okc_k_headers_all_b.currency_code%type;
11635:

Line 12171: FROM okc_k_headers_b chr

12167: l_api_name CONSTANT VARCHAR2(61) := 'generate_streams_for_IA';
12168:
12169: CURSOR c_hdr IS
12170: SELECT chr.currency_code
12171: FROM okc_k_headers_b chr
12172: WHERE chr.id = p_khr_id;
12173:
12174: l_currency_code okc_k_headers_all_b.currency_code%type;
12175: l_purpose_code VARCHAR2(10) := '-99';