APPS.OKL_BPD_TERMINATION_ADJ_PVT dependencies on OKL_K_HEADERS_FULL_V

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 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