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

Line 7093: FROM okc_k_headers_b

7089: --Cursor to get the customer_account_id for the customer
7090: CURSOR c_get_contractinfo_csr(cp_khr_id IN NUMBER) IS
7091: SELECT cust_acct_id, bill_to_site_use_id, currency_code, org_id,
7092: conversion_type, conversion_rate, conversion_rate_date, start_date
7093: FROM okc_k_headers_b
7094: WHERE id = cp_khr_id;
7095:
7096: --get currency attributes
7097: CURSOR l_fndcurrency_csr(cp_currency_code IN VARCHAR2) IS

Line 17593: okc_k_headers_b chr

17589:
17590: CURSOR get_rbk_act_khr(p_trx_id okl_trx_contracts.ID%TYPE) IS
17591: SELECT chr.ID
17592: FROM okl_trx_contracts trx,
17593: okc_k_headers_b chr
17594: WHERE chr.ID = trx.khr_id
17595: AND trx.ID = p_trx_id ;
17596:
17597: -- 16522428 15/03/13

Line 17599: CURSOR get_rbk_khr_id(p_chr_id okc_k_headers_b.ID%TYPE) IS

17595: AND trx.ID = p_trx_id ;
17596:
17597: -- 16522428 15/03/13
17598: -- added a new cursor to get the rebook contract id
17599: CURSOR get_rbk_khr_id(p_chr_id okc_k_headers_b.ID%TYPE) IS
17600: SELECT chr.ID
17601: FROM okc_k_headers_b chr
17602: WHERE chr.orig_system_id1 = p_chr_id
17603: AND chr.sts_code <> 'ABANDONED';

Line 17601: FROM okc_k_headers_b chr

17597: -- 16522428 15/03/13
17598: -- added a new cursor to get the rebook contract id
17599: CURSOR get_rbk_khr_id(p_chr_id okc_k_headers_b.ID%TYPE) IS
17600: SELECT chr.ID
17601: FROM okc_k_headers_b chr
17602: WHERE chr.orig_system_id1 = p_chr_id
17603: AND chr.sts_code <> 'ABANDONED';
17604: -- 16522428 15/03/13
17605:

Line 17623: l_chr_id OKC_K_HEADERS_B.ID%TYPE; --ER# 9327076

17619: l_tax_call_type VARCHAR2(30);
17620: l_org_id NUMBER;
17621: l_quote_object_code VARCHAR2(30);
17622: l_quote_object_id NUMBER;
17623: l_chr_id OKC_K_HEADERS_B.ID%TYPE; --ER# 9327076
17624: l_rbk_chr_id OKC_K_HEADERS_B.ID%TYPE; --16522428
17625:
17626: BEGIN
17627:

Line 17624: l_rbk_chr_id OKC_K_HEADERS_B.ID%TYPE; --16522428

17620: l_org_id NUMBER;
17621: l_quote_object_code VARCHAR2(30);
17622: l_quote_object_id NUMBER;
17623: l_chr_id OKC_K_HEADERS_B.ID%TYPE; --ER# 9327076
17624: l_rbk_chr_id OKC_K_HEADERS_B.ID%TYPE; --16522428
17625:
17626: BEGIN
17627:
17628: