APPS.OKL_FE_EO_TERM_OPTIONS_PVT dependencies on OKL_FE_EO_TERMS_V

Line 331: FROM OKL_FE_EO_TERMS_V WHERE END_OF_TERM_ID=p_eot_id;

327: CREATION_DATE,
328: LAST_UPDATED_BY,
329: LAST_UPDATE_DATE,
330: LAST_UPDATE_LOGIN
331: FROM OKL_FE_EO_TERMS_V WHERE END_OF_TERM_ID=p_eot_id;
332:
333: CURSOR eot_version_csr(p_eot_id NUMBER, p_eot_version VARCHAR2) IS
334: SELECT END_OF_TERM_VER_ID,
335: OBJECT_VERSION_NUMBER,

Line 697: FROM okl_fe_eo_terms_v

693: l_dummy_var VARCHAR2(1):='?';
694:
695: CURSOR eot_unique_chk(p_name IN varchar2) IS
696: SELECT 'x'
697: FROM okl_fe_eo_terms_v
698: WHERE end_of_term_name = UPPER(p_name);
699:
700:
701:

Line 1464: SELECT category_type_code,eot_type_code FROM OKL_FE_EO_TERMS_V hdr, OKL_FE_EO_TERM_VERS ver

1460: j NUMBER;
1461: int_count NUMBER;
1462:
1463: CURSOR cat_type_code_csr(p_end_of_term_ver_id IN NUMBER) IS
1464: SELECT category_type_code,eot_type_code FROM OKL_FE_EO_TERMS_V hdr, OKL_FE_EO_TERM_VERS ver
1465: WHERE hdr.end_of_term_id = ver.end_of_term_id AND ver.end_of_term_ver_id = p_end_of_term_ver_id;
1466:
1467: CURSOR objects_csr(p_end_of_term_ver_id IN NUMBER) IS
1468: SELECT inventory_item_id, organization_id, category_id, category_set_id, resi_category_set_id

Line 1895: FROM OKL_FE_EO_TERMS_V where end_of_term_id= p_eot_id;

1891: FROM OKL_FE_EO_TERM_VERS WHERE END_OF_TERM_VER_ID=p_ver_id;
1892:
1893: CURSOR get_source_type(p_eot_id IN NUMBER)IS
1894: SELECT EOT_TYPE_CODE
1895: FROM OKL_FE_EO_TERMS_V where end_of_term_id= p_eot_id;
1896: BEGIN
1897: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1898: G_PKG_NAME,
1899: l_init_msg_list,