APPS.OKL_PAY_INVOICES_DISB_PVT dependencies on OKL_K_HEADERS

Line 261: FROM okl_k_headers khr

257: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
258:
259: CURSOR pdt_id_csr ( p_khr_id NUMBER ) IS
260: SELECT khr.pdt_id
261: FROM okl_k_headers khr
262: WHERE khr.id = p_khr_id;
263:
264: -- SUBTYPE khr_id_type IS okc_k_headers_b.id%type;
265: l_khr_id okc_k_headers_b.id%type;

Line 267: l_currency_conversion_type okl_k_headers.currency_conversion_type%type;

263:
264: -- SUBTYPE khr_id_type IS okc_k_headers_b.id%type;
265: l_khr_id okc_k_headers_b.id%type;
266: l_currency_code okc_k_headers_b.currency_code%type;
267: l_currency_conversion_type okl_k_headers.currency_conversion_type%type;
268: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%type;
269: l_currency_conversion_date okl_k_headers.currency_conversion_date%type;
270:
271: --Get currency conversion attributes for a contract

Line 268: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%type;

264: -- SUBTYPE khr_id_type IS okc_k_headers_b.id%type;
265: l_khr_id okc_k_headers_b.id%type;
266: l_currency_code okc_k_headers_b.currency_code%type;
267: l_currency_conversion_type okl_k_headers.currency_conversion_type%type;
268: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%type;
269: l_currency_conversion_date okl_k_headers.currency_conversion_date%type;
270:
271: --Get currency conversion attributes for a contract
272: CURSOR l_curr_conv_csr(cp_khr_id IN okc_k_headers_b.id%TYPE) IS

Line 269: l_currency_conversion_date okl_k_headers.currency_conversion_date%type;

265: l_khr_id okc_k_headers_b.id%type;
266: l_currency_code okc_k_headers_b.currency_code%type;
267: l_currency_conversion_type okl_k_headers.currency_conversion_type%type;
268: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%type;
269: l_currency_conversion_date okl_k_headers.currency_conversion_date%type;
270:
271: --Get currency conversion attributes for a contract
272: CURSOR l_curr_conv_csr(cp_khr_id IN okc_k_headers_b.id%TYPE) IS
273: SELECT currency_code

Line 277: FROM okl_k_headers_full_v

273: SELECT currency_code
274: ,currency_conversion_type
275: ,currency_conversion_rate
276: ,currency_conversion_date
277: FROM okl_k_headers_full_v
278: WHERE id = cp_khr_id;
279:
280: --End code added by pgomes on 02/12/2003
281:

Line 2093: okl_k_headers khl,

2089: FROM okl_strm_elements ste,
2090: okl_streams stm,
2091: okl_strm_type_v sty,
2092: okc_k_headers_b khr,
2093: okl_k_headers khl,
2094: hr_operating_units hou,
2095: okc_k_lines_b kle,
2096: --added for evergreen change request 08_nov_2005
2097: okc_line_styles_b lse,

Line 2166: okl_k_headers khl,

2162: FROM okl_strm_elements ste,
2163: okl_streams stm,
2164: okl_strm_type_v sty,
2165: okc_k_headers_b khr,
2166: okl_k_headers khl,
2167: hr_operating_units hou,
2168: okc_k_lines_b kle,
2169: okc_k_lines_b sub_kle,
2170: --added for evergreen change request 08_nov_2005

Line 2246: FROM okl_k_headers oklh,

2242: pph.payout_basis_formula,
2243: okch.contract_number,
2244: -- 01-NOV-2006 ANSETHUR R12B - Legal Entity
2245: oklh.legal_entity_id
2246: FROM okl_k_headers oklh,
2247: okc_k_headers_b okch,
2248: hr_operating_units hou,
2249: okc_k_lines_b kle,
2250: --added for evergreen change request 08_nov_2005

Line 2603: from okl_k_headers REV

2599: ;
2600:
2601: cursor c_is_revolv_crd(p_creditline_id number) is
2602: select 1 -- Revloving line of credit line
2603: from okl_k_headers REV
2604: where rev.id = p_creditline_id
2605: and REV.REVOLVING_CREDIT_YN = 'Y'
2606: ;
2607: