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

Line 61: l_khr_id okc_k_headers_b.id%TYPE;

57:
58: -- sjalasut, commented the subtype declaration. changed the usages to point
59: -- to the table.column names.
60: -- SUBTYPE khr_id_type IS okl_k_headers_full_v.id%type;
61: l_khr_id okc_k_headers_b.id%TYPE;
62: l_currency_code okl_k_headers_full_v.currency_code%type;
63: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%type;
64: l_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%type;
65: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%type;

Line 144: CURSOR l_curr_conv_csr(cp_khr_id IN okc_k_headers_b.id%TYPE) IS

140: WHERE name = 'Debit Memo'
141: AND language= 'US';
142:
143: --Get currency conversion attributes for a contract
144: CURSOR l_curr_conv_csr(cp_khr_id IN okc_k_headers_b.id%TYPE) IS
145: SELECT currency_code
146: ,currency_conversion_type
147: ,currency_conversion_rate
148: ,currency_conversion_date

Line 414: okc_k_headers_b khr,

410: ste.source_table
411: FROM okl_strm_elements ste,
412: okl_streams stm,
413: okl_strm_type_v sty,
414: okc_k_headers_b khr,
415: okl_k_headers khl,
416: okc_k_lines_b kle,
417: okc_statuses_b khs
418: WHERE trunc(ste.stream_element_date) > trunc(nvl(cp_term_date_from, ste.stream_element_date))

Line 565: okc_k_headers_b khr,

561: ste.source_table
562: FROM okl_strm_elements ste,
563: okl_streams stm,
564: okl_strm_type_v sty,
565: okc_k_headers_b khr,
566: okl_k_headers khl,
567: okc_k_lines_b kle,
568: okc_statuses_b khs
569: WHERE trunc(ste.stream_element_date) >= trunc(nvl(cp_term_date_from, ste.stream_element_date))

Line 772: okc_k_headers_b khr,

768: ste.source_table
769: FROM okl_strm_elements ste,
770: okl_streams stm,
771: okl_strm_type_v sty,
772: okc_k_headers_b khr,
773: okl_k_headers khl,
774: okc_k_lines_b kle,
775: okc_statuses_b khs
776: WHERE trunc(ste.stream_element_date) >= trunc(nvl(cp_term_date_from, ste.stream_element_date))

Line 891: FROM okc_k_headers_b chr,hr_operating_units hr

887: chr.currency_code,
888: hr.set_of_books_id
889: -- 02-NOV-2006 ANSETHUR R12B - Legal Entity
890: ,khr.legal_entity_id
891: FROM okc_k_headers_b chr,hr_operating_units hr
892: -- 02-NOV-2006 ANSETHUR R12B - Legal Entity
893: ,OKL_K_HEADERS khr
894: WHERE chr.authoring_org_id = hr.organization_id
895: AND chr.id = p_chr_id

Line 899: l_authoring_org_id okc_k_headers_b.authoring_org_id%TYPE;

895: AND chr.id = p_chr_id
896: -- 02-NOV-2006 ANSETHUR R12B - Legal Entity
897: AND khr.id = chr.id;
898:
899: l_authoring_org_id okc_k_headers_b.authoring_org_id%TYPE;
900: l_currency_code okc_k_headers_b.currency_code%TYPE;
901: l_set_of_books_id hr_operating_units.set_of_books_id%TYPE;
902: -- 02-NOV-2006 ANSETHUR R12B - Legal Entity
903: l_legal_entity_id okl_k_headers.legal_entity_id%TYPE;

Line 900: l_currency_code okc_k_headers_b.currency_code%TYPE;

896: -- 02-NOV-2006 ANSETHUR R12B - Legal Entity
897: AND khr.id = chr.id;
898:
899: l_authoring_org_id okc_k_headers_b.authoring_org_id%TYPE;
900: l_currency_code okc_k_headers_b.currency_code%TYPE;
901: l_set_of_books_id hr_operating_units.set_of_books_id%TYPE;
902: -- 02-NOV-2006 ANSETHUR R12B - Legal Entity
903: l_legal_entity_id okl_k_headers.legal_entity_id%TYPE;
904: