APPS.OKL_BPD_TERMINATION_ADJ_PVT dependencies on OKL_K_HEADERS

Line 60: -- SUBTYPE khr_id_type IS okl_k_headers_full_v.id%type;

56: lux_tapv_rec Okl_tap_pvt.tapv_rec_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;

Line 62: l_currency_code okl_k_headers_full_v.currency_code%type;

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;
66:

Line 63: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%type;

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;
66:
67: l_created_tap BOOLEAN := TRUE;

Line 64: l_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%type;

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;
66:
67: l_created_tap BOOLEAN := TRUE;
68: l_created_tpl BOOLEAN := TRUE;

Line 65: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%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;
66:
67: l_created_tap BOOLEAN := TRUE;
68: l_created_tpl BOOLEAN := TRUE;
69: l_created_dist BOOLEAN := TRUE;

Line 81: FROM okl_k_headers khr

77: lx_tldv_rec okl_txd_ar_ln_dtls_pub.tldv_rec_type;
78:
79: CURSOR pdt_id_csr (p_khr_id NUMBER) IS
80: SELECT khr.pdt_id
81: FROM okl_k_headers khr
82: WHERE khr.id = p_khr_id;
83:
84: -- sjalasut, modified the below cursor to have khr_id be picked up from
85: -- okl_txl_ap_inv_lns_v instead of okl_trx_ap_invoices_v

Line 149: FROM okl_k_headers_full_v

145: SELECT currency_code
146: ,currency_conversion_type
147: ,currency_conversion_rate
148: ,currency_conversion_date
149: FROM okl_k_headers_full_v
150: WHERE id = cp_khr_id;
151:
152: cnt NUMBER;
153: BEGIN

Line 415: okl_k_headers khl,

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))
419: AND trunc(ste.stream_element_date) <= trunc(nvl(cp_term_date_to, ste.stream_element_date))

Line 465: FROM OKL_K_HEADERS KHR,

461: --Bug 7456516
462: CURSOR GET_PRICING_DET_CSR(P_KHR_ID IN NUMBER) IS
463: SELECT GTS.PRICING_ENGINE,
464: GTS.ISG_ARREARS_PAY_DATES_OPTION
465: FROM OKL_K_HEADERS KHR,
466: OKL_PRODUCTS PDT,
467: OKL_AE_TMPT_SETS_ALL AES,
468: OKL_ST_GEN_TMPT_SETS_ALL GTS
469: WHERE KHR.PDT_ID = PDT.ID

Line 642: okl_k_headers khl,

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))
646: AND trunc(ste.stream_element_date) <= trunc(nvl(cp_term_date_to, ste.stream_element_date))

Line 849: okl_k_headers khl,

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))
853: AND trunc(ste.stream_element_date) <= trunc(nvl(cp_term_date_to, ste.stream_element_date))

Line 969: ,OKL_K_HEADERS khr

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
972: -- 02-NOV-2006 ANSETHUR R12B - Legal Entity
973: AND khr.id = chr.id;

Line 979: l_legal_entity_id okl_k_headers.legal_entity_id%TYPE;

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:
981: CURSOR get_passthru_csr (p_chr_id NUMBER, p_cle_id NUMBER) IS
982: SELECT id,
983: passthru_stream_type_id,