Line 6825: SELECT item_type, item_key FROM wf_items_v
6821: l_child_item_key VARCHAR2(240);
6822: l_child_item_type VARCHAR2(30);
6823:
6824: CURSOR c_find_child (item_key_in IN VARCHAR2, item_type_in IN VARCHAR2) IS 6825: SELECT item_type, item_key FROM wf_items_v 6826: WHERE PARENT_ITEM_TYPE = item_type_in
6827: AND parent_item_key = item_key_in
6828: AND END_DATE IS NULL;
6829: