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 641: okc_k_headers_b khr,

637: ste.source_table
638: FROM okl_strm_elements ste,
639: okl_streams stm,
640: okl_strm_type_v sty,
641: okc_k_headers_b khr,
642: okl_k_headers khl,
643: okc_k_lines_b kle,
644: okc_statuses_b khs
645: WHERE trunc(ste.stream_element_date) >= trunc(nvl(cp_term_date_from, ste.stream_element_date))

Line 848: okc_k_headers_b khr,

844: ste.source_table
845: FROM okl_strm_elements ste,
846: okl_streams stm,
847: okl_strm_type_v sty,
848: okc_k_headers_b khr,
849: okl_k_headers khl,
850: okc_k_lines_b kle,
851: okc_statuses_b khs
852: WHERE trunc(ste.stream_element_date) >= trunc(nvl(cp_term_date_from, ste.stream_element_date))

Line 967: FROM okc_k_headers_b chr,hr_operating_units hr

963: chr.currency_code,
964: hr.set_of_books_id
965: -- 02-NOV-2006 ANSETHUR R12B - Legal Entity
966: ,khr.legal_entity_id
967: FROM okc_k_headers_b chr,hr_operating_units hr
968: -- 02-NOV-2006 ANSETHUR R12B - Legal Entity
969: ,OKL_K_HEADERS khr
970: WHERE chr.authoring_org_id = hr.organization_id
971: AND chr.id = p_chr_id

Line 975: l_authoring_org_id okc_k_headers_b.authoring_org_id%TYPE;

971: AND chr.id = p_chr_id
972: -- 02-NOV-2006 ANSETHUR R12B - Legal Entity
973: AND khr.id = chr.id;
974:
975: l_authoring_org_id okc_k_headers_b.authoring_org_id%TYPE;
976: l_currency_code okc_k_headers_b.currency_code%TYPE;
977: l_set_of_books_id hr_operating_units.set_of_books_id%TYPE;
978: -- 02-NOV-2006 ANSETHUR R12B - Legal Entity
979: l_legal_entity_id okl_k_headers.legal_entity_id%TYPE;

Line 976: l_currency_code okc_k_headers_b.currency_code%TYPE;

972: -- 02-NOV-2006 ANSETHUR R12B - Legal Entity
973: AND khr.id = chr.id;
974:
975: l_authoring_org_id okc_k_headers_b.authoring_org_id%TYPE;
976: l_currency_code okc_k_headers_b.currency_code%TYPE;
977: l_set_of_books_id hr_operating_units.set_of_books_id%TYPE;
978: -- 02-NOV-2006 ANSETHUR R12B - Legal Entity
979: l_legal_entity_id okl_k_headers.legal_entity_id%TYPE;
980: