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 1207: from okc_k_headers_b chrb,

1203: --cursor to check cutomer credit class
1204: cursor l_cclass_csr (p_subsidy_id in number,
1205: p_asset_cle_id in number) is
1206: select 'Y'
1207: from okc_k_headers_b chrb,
1208: hz_cust_accounts cust,
1209: okc_k_lines_b cleb,
1210: okl_subsidy_criteria suc
1211: where chrb.id = cleb.chr_id

Line 1340: okc_k_headers_b chrb,

1336: select 'Y'
1337: from hz_parties hp,
1338: hz_cust_accounts_all hca,
1339: okc_k_lines_b cleb,
1340: okc_k_headers_b chrb,
1341: okl_subsidy_criteria suc
1342: where hp.party_id = hca.party_id
1343: And hca.CUST_ACCOUNT_ID = chrb.cust_acct_id
1344: And chrb.id = cleb.chr_id

Line 1367: from okc_k_headers_b chrb,

1363:
1364: -- cursor to check if it is a rebook contract
1365: cursor l_chr_rebook (p_asset_cle_id in number) is
1366: Select 'Y'
1367: from okc_k_headers_b chrb,
1368: okc_k_lines_b cleb,
1369: okl_trx_contracts ktrx
1370: where chrb.id = cleb.chr_id
1371: and chrb.id = cleb.dnz_chr_id

Line 1387: from okc_k_headers_b chrb,

1383:
1384: --cursor to check if it is a mass rebook
1385: cursor l_chr_mass_rebook (p_asset_cle_id in number) is
1386: Select 'Y'
1387: from okc_k_headers_b chrb,
1388: okc_k_lines_b cleb,
1389: okl_trx_contracts ktrx
1390: where chrb.id = cleb.chr_id
1391: and chrb.id = cleb.dnz_chr_id

Line 1744: okc_k_headers_b chrb

1740: cursor l_chr_csr (p_subsidy_id in number,
1741: p_chr_id in number) is
1742: Select 'Y'
1743: from okl_subsidies_b sub,
1744: okc_k_headers_b chrb
1745: where sub.id = p_subsidy_id
1746: and chrb.id = p_chr_id
1747: --check for authoring org id
1748: and chrb.authoring_org_id = sub.org_id

Line 1888: okc_k_headers_b chrb,

1884: p_chr_id in number) is
1885: select 'Y'
1886: from hz_parties hp,
1887: hz_cust_accounts_all hca,
1888: okc_k_headers_b chrb,
1889: okl_subsidy_criteria suc
1890: where hp.party_id = hca.party_id
1891: And hca.CUST_ACCOUNT_ID = chrb.cust_acct_id
1892: And chrb.id = p_chr_id

Line 1901: FROM okc_k_headers_b

1897: And SUC.industry_code_type is not null;
1898:
1899: CURSOR c_get_trx_csr IS
1900: SELECT currency_code
1901: FROM okc_k_headers_b
1902: WHERE id = p_chr_id;
1903: l_trx_currency_code okc_k_headers_b.currency_code%TYPE;
1904:
1905: l_chk_required varchar2(1);

Line 1903: l_trx_currency_code okc_k_headers_b.currency_code%TYPE;

1899: CURSOR c_get_trx_csr IS
1900: SELECT currency_code
1901: FROM okc_k_headers_b
1902: WHERE id = p_chr_id;
1903: l_trx_currency_code okc_k_headers_b.currency_code%TYPE;
1904:
1905: l_chk_required varchar2(1);
1906: l_applicable varchar2(10);
1907:

Line 2233: okc_k_headers_b chrb

2229: cursor l_chr_csr (p_subsidy_id in number,
2230: p_chr_id in number) is
2231: Select 'Y'
2232: from okl_subsidies_b sub,
2233: okc_k_headers_b chrb
2234: where sub.id = p_subsidy_id
2235: and chrb.id = p_chr_id
2236: --check for authoring org id
2237: and chrb.authoring_org_id = sub.org_id

Line 2320: from okc_k_headers_b chrb,

2316: --cursor to check cutomer credit class
2317: /* cursor l_cclass_csr (p_subsidy_id in number,
2318: p_chr_id in number) is
2319: select 'Y'
2320: from okc_k_headers_b chrb,
2321: hz_cust_accounts cust,
2322: okl_subsidy_criteria suc
2323: where chrb.id = p_chr_id
2324: And chrb.cust_acct_id = to_char(cust.cust_account_id)

Line 2427: okc_k_headers_b chrb,

2423: /* cursor l_sic_csr (p_subsidy_id in number,
2424: p_chr_id in number) is
2425: select 'Y'
2426: from ra_customers rac,
2427: okc_k_headers_b chrb,
2428: okl_subsidy_criteria suc
2429: where rac.customer_id = chrb.cust_acct_id
2430: And chrb.id = p_chr_id
2431: And SUC.subsidy_id = p_subsidy_id

Line 2458: FROM okc_k_headers_b

2454: -- start: okl.h cklee
2455: -- commented for the okl.h Sales Quote/Lease Application IA Subsidies
2456: /* CURSOR c_get_trx_csr IS
2457: SELECT currency_code
2458: FROM okc_k_headers_b
2459: WHERE id = p_chr_id;
2460:
2461: l_trx_currency_code okc_k_headers_b.currency_code%TYPE;
2462: */

Line 2461: l_trx_currency_code okc_k_headers_b.currency_code%TYPE;

2457: SELECT currency_code
2458: FROM okc_k_headers_b
2459: WHERE id = p_chr_id;
2460:
2461: l_trx_currency_code okc_k_headers_b.currency_code%TYPE;
2462: */
2463: -- end: okl.h cklee
2464:
2465: l_chk_required varchar2(1);

Line 2762: FROM okc_k_headers_b hdr,

2758: ) RETURN VARCHAR2 IS
2759:
2760: CURSOR c_get_asset_dtls_csr IS
2761: SELECT line.start_date, hdr.currency_code
2762: FROM okc_k_headers_b hdr,
2763: okc_k_lines_b line
2764: WHERE line.id = p_asset_cle_id
2765: AND line.dnz_chr_id = hdr.id;
2766:

Line 3099: ,p_trx_currency_code IN okc_k_headers_b.currency_code%TYPE

3095: END is_sub_pool_active_by_date;
3096:
3097: FUNCTION is_sub_pool_conv_rate_valid(p_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE
3098: ,p_asset_date IN okc_k_lines_b.start_date%TYPE
3099: ,p_trx_currency_code IN okc_k_headers_b.currency_code%TYPE
3100: ,x_conversion_rate OUT NOCOPY NUMBER) RETURN VARCHAR2 IS
3101: CURSOR c_sub_pool_csr IS
3102: SELECT currency_code
3103: ,currency_conversion_type

Line 3658: from okc_k_headers_b chrb

3654: p_dnz_chr_id IN NUMBER) IS
3655:
3656: cursor l_chr_csr (p_dnz_chr_id in number) is
3657: select 'Y'
3658: from okc_k_headers_b chrb
3659: where chrb.id = p_dnz_chr_id;
3660: --as per clarification by srawlings
3661: --and chrb.sts_code in ('NEW','COMPLETE','PASSED','INCOMPLETE','TERMINATED','APPROVED');
3662: