APPS.OKL_FE_EO_TERM_OPTIONS_PVT dependencies on OKL_FE_ITEM_RESIDUAL_ALL

Line 470: FROM OKL_FE_ITEM_RESIDUAL_ALL

466: organization_id,
467: category_set_id,
468: category_id,
469: resi_category_set_id
470: FROM OKL_FE_ITEM_RESIDUAL_ALL
471: WHERE (residual_type_code= 'PERCENT' and
472: residual_type_code=l_eot_type_code ) OR (residual_type_code = 'AMOUNT' and
473: residual_type_code=l_eot_type_code and currency_code =l_currency_code)
474: );

Line 1886: l_source_type OKL_FE_ITEM_RESIDUAL_ALL.CATEGORY_TYPE_CODE%TYPE;

1882: AND RCSV.STS_CODE <> p_rcs_sts_code
1883: AND IRESDV.item_residual_id = p_itm_rsdl_id;
1884:
1885: l_eot_id NUMBER;
1886: l_source_type OKL_FE_ITEM_RESIDUAL_ALL.CATEGORY_TYPE_CODE%TYPE;
1887: l_rcs_rec check_active_resi_cat_sets%ROWTYPE;
1888:
1889: CURSOR get_eot_id(p_ver_id IN NUMBER) IS
1890: SELECT END_OF_TERM_ID