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_PAY_INVOICES_DISB_PVT dependencies on OKL_K_HEADERS

Line 306: FROM okl_k_headers khr

302: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
303:
304: CURSOR pdt_id_csr ( p_khr_id NUMBER ) IS
305: SELECT khr.pdt_id
306: FROM okl_k_headers khr
307: WHERE khr.id = p_khr_id;
308:
309: -- SUBTYPE khr_id_type IS okc_k_headers_b.id%type;
310: l_khr_id okc_k_headers_b.id%type;

Line 312: l_currency_conversion_type okl_k_headers.currency_conversion_type%type;

308:
309: -- SUBTYPE khr_id_type IS okc_k_headers_b.id%type;
310: l_khr_id okc_k_headers_b.id%type;
311: l_currency_code okc_k_headers_b.currency_code%type;
312: l_currency_conversion_type okl_k_headers.currency_conversion_type%type;
313: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%type;
314: l_currency_conversion_date okl_k_headers.currency_conversion_date%type;
315:
316: --Get currency conversion attributes for a contract

Line 313: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%type;

309: -- SUBTYPE khr_id_type IS okc_k_headers_b.id%type;
310: l_khr_id okc_k_headers_b.id%type;
311: l_currency_code okc_k_headers_b.currency_code%type;
312: l_currency_conversion_type okl_k_headers.currency_conversion_type%type;
313: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%type;
314: l_currency_conversion_date okl_k_headers.currency_conversion_date%type;
315:
316: --Get currency conversion attributes for a contract
317: CURSOR l_curr_conv_csr(cp_khr_id IN okc_k_headers_b.id%TYPE) IS

Line 314: l_currency_conversion_date okl_k_headers.currency_conversion_date%type;

310: l_khr_id okc_k_headers_b.id%type;
311: l_currency_code okc_k_headers_b.currency_code%type;
312: l_currency_conversion_type okl_k_headers.currency_conversion_type%type;
313: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%type;
314: l_currency_conversion_date okl_k_headers.currency_conversion_date%type;
315:
316: --Get currency conversion attributes for a contract
317: CURSOR l_curr_conv_csr(cp_khr_id IN okc_k_headers_b.id%TYPE) IS
318: SELECT currency_code

Line 322: FROM okl_k_headers_full_v

318: SELECT currency_code
319: ,currency_conversion_type
320: ,currency_conversion_rate
321: ,currency_conversion_date
322: FROM okl_k_headers_full_v
323: WHERE id = cp_khr_id;
324:
325: --End code added by pgomes on 02/12/2003
326:

Line 2146: okl_k_headers khl,

2142: FROM okl_strm_elements ste,
2143: okl_streams stm,
2144: okl_strm_type_v sty,
2145: okc_k_headers_b khr,
2146: okl_k_headers khl,
2147: hr_operating_units hou,
2148: okc_k_lines_b kle,
2149: --added for evergreen change request 08_nov_2005
2150: okc_line_styles_b lse,

Line 2219: okl_k_headers khl,

2215: FROM okl_strm_elements ste,
2216: okl_streams stm,
2217: okl_strm_type_v sty,
2218: okc_k_headers_b khr,
2219: okl_k_headers khl,
2220: hr_operating_units hou,
2221: okc_k_lines_b kle,
2222: okc_k_lines_b sub_kle,
2223: --added for evergreen change request 08_nov_2005

Line 2299: FROM okl_k_headers oklh,

2295: pph.payout_basis_formula,
2296: okch.contract_number,
2297: -- 01-NOV-2006 ANSETHUR R12B - Legal Entity
2298: oklh.legal_entity_id
2299: FROM okl_k_headers oklh,
2300: okc_k_headers_b okch,
2301: hr_operating_units hou,
2302: okc_k_lines_b kle,
2303: --added for evergreen change request 08_nov_2005

Line 2656: from okl_k_headers REV

2652: ;
2653:
2654: cursor c_is_revolv_crd(p_creditline_id number) is
2655: select 1 -- Revloving line of credit line
2656: from okl_k_headers REV
2657: where rev.id = p_creditline_id
2658: and REV.REVOLVING_CREDIT_YN = 'Y'
2659: ;
2660: