APPS.OKL_FE_EO_TERM_OPTIONS_PVT dependencies on OKL_FE_EO_TERM_OBJECTS

Line 74: FROM OKL_FE_EO_TERM_OBJECTS WHERE END_OF_TERM_VER_ID = p_end_of_term_ver_id;

70: CREATION_DATE,
71: LAST_UPDATED_BY,
72: LAST_UPDATE_DATE,
73: LAST_UPDATE_LOGIN
74: FROM OKL_FE_EO_TERM_OBJECTS WHERE END_OF_TERM_VER_ID = p_end_of_term_ver_id;
75:
76: BEGIN
77: -- Check if the po id exists
78: OPEN eo_term_exists;

Line 442: FROM OKL_FE_EO_TERM_OBJECTS

438: organization_id,
439: category_set_id,
440: category_id,
441: resi_category_set_id
442: FROM OKL_FE_EO_TERM_OBJECTS
443: WHERE end_of_term_ver_id = p_version_id;
444:
445: -- cursor to fetch the residual type and the currency from the header
446: CURSOR eot_hdr_csr(p_version_id IN NUMBER) IS

Line 462: FROM OKL_FE_EO_TERM_OBJECTS

458: organization_id,
459: category_set_id,
460: category_id,
461: resi_category_set_id
462: FROM OKL_FE_EO_TERM_OBJECTS
463: WHERE end_of_term_ver_id = p_version_id
464: MINUS
465: SELECT inventory_item_id ,
466: organization_id,

Line 1469: FROM OKL_FE_EO_TERM_OBJECTS

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
1469: FROM OKL_FE_EO_TERM_OBJECTS
1470: WHERE end_of_term_ver_id=p_end_of_term_ver_id;
1471:
1472: cursor repeat_csr(id1 NUMBER, id2 NUMBER) is
1473: select count(*) from