DBA Data[Home] [Help]

APPS.OKL_FE_EO_TERM_OPTIONS_PVT dependencies on OKL_FE_RESI_CAT_OBJECTS

Line 1456: from OKL_FE_RESI_CAT_OBJECTS where resi_category_set_id = id1

1452: cursor repeat_csr(id1 NUMBER, id2 NUMBER) is
1453: select count(*) from
1454: (
1455: select organization_id, inventory_item_id, category_id, category_set_id
1456: from OKL_FE_RESI_CAT_OBJECTS where resi_category_set_id = id1
1457: intersect
1458: select organization_id, inventory_item_id, category_id, category_set_id
1459: from OKL_FE_RESI_CAT_OBJECTS where resi_category_set_id = id2
1460: );

Line 1459: from OKL_FE_RESI_CAT_OBJECTS where resi_category_set_id = id2

1455: select organization_id, inventory_item_id, category_id, category_set_id
1456: from OKL_FE_RESI_CAT_OBJECTS where resi_category_set_id = id1
1457: intersect
1458: select organization_id, inventory_item_id, category_id, category_set_id
1459: from OKL_FE_RESI_CAT_OBJECTS where resi_category_set_id = id2
1460: );
1461:
1462: BEGIN
1463: