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

1854: RCSV.RESI_CATEGORY_SET_ID ID
1855: , RCSV.RESI_CAT_NAME NAME
1856: FROM
1857: OKL_FE_RESI_CAT_V RCSV
1858: , OKL_FE_ITEM_RESIDUAL IRESDV
1859: WHERE
1860: IRESDV.CATEGORY_TYPE_CODE = 'RESCAT'
1861: AND IRESDV.RESI_CATEGORY_SET_ID = RCSV.RESI_CATEGORY_SET_ID
1862: AND RCSV.STS_CODE <> p_rcs_sts_code

Line 1866: l_source_type OKL_FE_ITEM_RESIDUAL_ALL.CATEGORY_TYPE_CODE%TYPE;

1862: AND RCSV.STS_CODE <> p_rcs_sts_code
1863: AND IRESDV.item_residual_id = p_itm_rsdl_id;
1864:
1865: l_eot_id NUMBER;
1866: l_source_type OKL_FE_ITEM_RESIDUAL_ALL.CATEGORY_TYPE_CODE%TYPE;
1867: l_rcs_rec check_active_resi_cat_sets%ROWTYPE;
1868:
1869: CURSOR get_eot_id(p_ver_id IN NUMBER) IS
1870: SELECT END_OF_TERM_ID