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

Line 65: p_chr_id IN okc_k_headers_b.id%TYPE,

61: -- End of comments
62:
63: PROCEDURE raise_business_event(p_api_version IN NUMBER,
64: p_init_msg_list IN VARCHAR2,
65: p_chr_id IN okc_k_headers_b.id%TYPE,
66: p_asset_id IN okc_k_lines_b.id%TYPE,
67: p_subsidy_id IN okl_subsidies_b.id%TYPE,
68: p_event_name IN VARCHAR2,
69: x_return_status OUT NOCOPY VARCHAR2,

Line 174: From okc_k_headers_b chr

170: FUNCTION Is_Rebook_Copy (p_chr_id IN NUMBER) return varchar2 IS
171: --Cursor to check if the contract is a rebook copy
172: Cursor Rbk_Cpy_Csr(p_chr_id IN Number) is
173: Select 'Y'
174: From okc_k_headers_b chr
175: where chr.orig_system_source_code = 'OKL_REBOOK'
176: and chr.id = p_chr_id;
177:
178: l_rbk_cpy Varchar2(1) default 'N';

Line 460: okc_k_headers_b chrb

456: Select lseb.id
457: from okc_line_styles_b lseb,
458: okc_line_styles_b top_lseb,
459: okc_subclass_top_line scs_lse,
460: okc_k_headers_b chrb
461: where lseb.lty_code = G_SUBLINE_LTY_CODE
462: and lseb.lse_parent_id = top_lseb.id
463: and top_lseb.lty_code = 'FREE_FORM1'
464: and lseb.lse_parent_id = scs_lse.lse_id

Line 1075: okc_k_headers_b chrb,

1071: cursor l_chr_csr (p_subsidy_id in number,
1072: p_asset_cle_id in number) is
1073: Select 'Y'
1074: from okl_subsidies_b sub,
1075: okc_k_headers_b chrb,
1076: okc_k_lines_b cleb
1077: where sub.id = p_subsidy_id
1078: and chrb.id = cleb.chr_id
1079: and chrb.id = cleb.dnz_chr_id

Line 1093: okc_k_headers_b chrb,

1089: cursor l_relk_csr (p_subsidy_id in number,
1090: p_asset_cle_id in number) is
1091: Select 'Y'
1092: from okl_subsidies_b sub,
1093: okc_k_headers_b chrb,
1094: okc_k_lines_b cleb
1095: where sub.id = p_subsidy_id
1096: and chrb.id = cleb.chr_id
1097: and chrb.id = cleb.dnz_chr_id

Line 1224: from okc_k_headers_b chrb,

1220: --cursor to check cutomer credit class
1221: cursor l_cclass_csr (p_subsidy_id in number,
1222: p_asset_cle_id in number) is
1223: select 'Y'
1224: from okc_k_headers_b chrb,
1225: hz_cust_accounts cust,
1226: okc_k_lines_b cleb,
1227: okl_subsidy_criteria suc
1228: where chrb.id = cleb.chr_id

Line 1357: okc_k_headers_b chrb,

1353: select 'Y'
1354: from hz_parties hp,
1355: hz_cust_accounts_all hca,
1356: okc_k_lines_b cleb,
1357: okc_k_headers_b chrb,
1358: okl_subsidy_criteria suc
1359: where hp.party_id = hca.party_id
1360: And hca.CUST_ACCOUNT_ID = chrb.cust_acct_id
1361: And chrb.id = cleb.chr_id

Line 1384: from okc_k_headers_b chrb,

1380:
1381: -- cursor to check if it is a rebook contract
1382: cursor l_chr_rebook (p_asset_cle_id in number) is
1383: Select 'Y'
1384: from okc_k_headers_b chrb,
1385: okc_k_lines_b cleb,
1386: okl_trx_contracts ktrx
1387: where chrb.id = cleb.chr_id
1388: and chrb.id = cleb.dnz_chr_id

Line 1404: from okc_k_headers_b chrb,

1400:
1401: --cursor to check if it is a mass rebook
1402: cursor l_chr_mass_rebook (p_asset_cle_id in number) is
1403: Select 'Y'
1404: from okc_k_headers_b chrb,
1405: okc_k_lines_b cleb,
1406: okl_trx_contracts ktrx
1407: where chrb.id = cleb.chr_id
1408: and chrb.id = cleb.dnz_chr_id

Line 1765: okc_k_headers_b chrb

1761: cursor l_chr_csr (p_subsidy_id in number,
1762: p_chr_id in number) is
1763: Select 'Y'
1764: from okl_subsidies_b sub,
1765: okc_k_headers_b chrb
1766: where sub.id = p_subsidy_id
1767: and chrb.id = p_chr_id
1768: --check for authoring org id
1769: and chrb.authoring_org_id = sub.org_id

Line 1909: okc_k_headers_b chrb,

1905: p_chr_id in number) is
1906: select 'Y'
1907: from hz_parties hp,
1908: hz_cust_accounts_all hca,
1909: okc_k_headers_b chrb,
1910: okl_subsidy_criteria suc
1911: where hp.party_id = hca.party_id
1912: And hca.CUST_ACCOUNT_ID = chrb.cust_acct_id
1913: And chrb.id = p_chr_id

Line 1922: FROM okc_k_headers_b

1918: And SUC.industry_code_type is not null;
1919:
1920: CURSOR c_get_trx_csr IS
1921: SELECT currency_code
1922: FROM okc_k_headers_b
1923: WHERE id = p_chr_id;
1924: l_trx_currency_code okc_k_headers_b.currency_code%TYPE;
1925:
1926: l_chk_required varchar2(1);

Line 1924: l_trx_currency_code okc_k_headers_b.currency_code%TYPE;

1920: CURSOR c_get_trx_csr IS
1921: SELECT currency_code
1922: FROM okc_k_headers_b
1923: WHERE id = p_chr_id;
1924: l_trx_currency_code okc_k_headers_b.currency_code%TYPE;
1925:
1926: l_chk_required varchar2(1);
1927: l_applicable varchar2(10);
1928:

Line 2254: okc_k_headers_b chrb

2250: cursor l_chr_csr (p_subsidy_id in number,
2251: p_chr_id in number) is
2252: Select 'Y'
2253: from okl_subsidies_b sub,
2254: okc_k_headers_b chrb
2255: where sub.id = p_subsidy_id
2256: and chrb.id = p_chr_id
2257: --check for authoring org id
2258: and chrb.authoring_org_id = sub.org_id

Line 2341: from okc_k_headers_b chrb,

2337: --cursor to check cutomer credit class
2338: /* cursor l_cclass_csr (p_subsidy_id in number,
2339: p_chr_id in number) is
2340: select 'Y'
2341: from okc_k_headers_b chrb,
2342: hz_cust_accounts cust,
2343: okl_subsidy_criteria suc
2344: where chrb.id = p_chr_id
2345: And chrb.cust_acct_id = to_char(cust.cust_account_id)

Line 2448: okc_k_headers_b chrb,

2444: /* cursor l_sic_csr (p_subsidy_id in number,
2445: p_chr_id in number) is
2446: select 'Y'
2447: from ra_customers rac,
2448: okc_k_headers_b chrb,
2449: okl_subsidy_criteria suc
2450: where rac.customer_id = chrb.cust_acct_id
2451: And chrb.id = p_chr_id
2452: And SUC.subsidy_id = p_subsidy_id

Line 2479: FROM okc_k_headers_b

2475: -- start: okl.h cklee
2476: -- commented for the okl.h Sales Quote/Lease Application IA Subsidies
2477: /* CURSOR c_get_trx_csr IS
2478: SELECT currency_code
2479: FROM okc_k_headers_b
2480: WHERE id = p_chr_id;
2481:
2482: l_trx_currency_code okc_k_headers_b.currency_code%TYPE;
2483: */

Line 2482: l_trx_currency_code okc_k_headers_b.currency_code%TYPE;

2478: SELECT currency_code
2479: FROM okc_k_headers_b
2480: WHERE id = p_chr_id;
2481:
2482: l_trx_currency_code okc_k_headers_b.currency_code%TYPE;
2483: */
2484: -- end: okl.h cklee
2485:
2486: l_chk_required varchar2(1);

Line 2783: FROM okc_k_headers_b hdr,

2779: ) RETURN VARCHAR2 IS
2780:
2781: CURSOR c_get_asset_dtls_csr IS
2782: SELECT line.start_date, hdr.currency_code
2783: FROM okc_k_headers_b hdr,
2784: okc_k_lines_b line
2785: WHERE line.id = p_asset_cle_id
2786: AND line.dnz_chr_id = hdr.id;
2787:

Line 3120: ,p_trx_currency_code IN okc_k_headers_b.currency_code%TYPE

3116: END is_sub_pool_active_by_date;
3117:
3118: FUNCTION is_sub_pool_conv_rate_valid(p_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE
3119: ,p_asset_date IN okc_k_lines_b.start_date%TYPE
3120: ,p_trx_currency_code IN okc_k_headers_b.currency_code%TYPE
3121: ,x_conversion_rate OUT NOCOPY NUMBER) RETURN VARCHAR2 IS
3122: CURSOR c_sub_pool_csr IS
3123: SELECT currency_code
3124: ,currency_conversion_type

Line 3679: from okc_k_headers_b chrb

3675: p_dnz_chr_id IN NUMBER) IS
3676:
3677: cursor l_chr_csr (p_dnz_chr_id in number) is
3678: select 'Y'
3679: from okc_k_headers_b chrb
3680: where chrb.id = p_dnz_chr_id;
3681: --as per clarification by srawlings
3682: --and chrb.sts_code in ('NEW','COMPLETE','PASSED','INCOMPLETE','TERMINATED','APPROVED');
3683: