APPS.OKL_FE_EO_TERM_OPTIONS_PVT dependencies on OKL_FE_ITEM_RESIDUAL

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 1878: , OKL_FE_ITEM_RESIDUAL IRESDV

1874: RCSV.RESI_CATEGORY_SET_ID ID
1875: , RCSV.RESI_CAT_NAME NAME
1876: FROM
1877: OKL_FE_RESI_CAT_V RCSV
1878: , OKL_FE_ITEM_RESIDUAL IRESDV
1879: WHERE
1880: IRESDV.CATEGORY_TYPE_CODE = 'RESCAT'
1881: AND IRESDV.RESI_CATEGORY_SET_ID = RCSV.RESI_CATEGORY_SET_ID
1882: AND RCSV.STS_CODE <> p_rcs_sts_code

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