DBA Data[Home] [Help]

APPS.OKL_FE_EO_TERM_OPTIONS_PVT dependencies on OKL_FE_RESI_CAT_OBJECTS

Line 1476: from OKL_FE_RESI_CAT_OBJECTS where resi_category_set_id = id1

1472: cursor repeat_csr(id1 NUMBER, id2 NUMBER) is
1473: select count(*) from
1474: (
1475: select organization_id, inventory_item_id, category_id, category_set_id
1476: from OKL_FE_RESI_CAT_OBJECTS where resi_category_set_id = id1
1477: intersect
1478: select organization_id, inventory_item_id, category_id, category_set_id
1479: from OKL_FE_RESI_CAT_OBJECTS where resi_category_set_id = id2
1480: );

Line 1479: from OKL_FE_RESI_CAT_OBJECTS where resi_category_set_id = id2

1475: select organization_id, inventory_item_id, category_id, category_set_id
1476: from OKL_FE_RESI_CAT_OBJECTS where resi_category_set_id = id1
1477: intersect
1478: select organization_id, inventory_item_id, category_id, category_set_id
1479: from OKL_FE_RESI_CAT_OBJECTS where resi_category_set_id = id2
1480: );
1481:
1482: BEGIN
1483: