APPS.OKL_FE_EO_TERM_OPTIONS_PVT dependencies on OKL_FE_EO_TERM_VERS_V

Line 451: FROM OKL_FE_EO_TERM_VERS_V

447: SELECT end_of_term_id,
448: eot_type_code,
449: currency_code,
450: category_type_code
451: FROM OKL_FE_EO_TERM_VERS_V
452: WHERE end_of_term_ver_id = p_version_id;
453:
454: -- cursor to see id the records are available
455: CURSOR count_csr(p_version_id IN NUMBER,l_eot_type_code IN VARCHAR2, l_currency_code IN VARCHAR2) IS

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