DBA Data[Home] [Help]

APPS.CSM_UNDO_PKG dependencies on ASG_BASE

Line 339: OPEN cur FOR 'select DISTINCT STORE from '||asg_base.G_OLITE_SCHEMA||'.c$inq c_inq

335: CLOSE c_get_ta_from_base;
336: END IF;
337:
338:
339: OPEN cur FOR 'select DISTINCT STORE from '||asg_base.G_OLITE_SCHEMA||'.c$inq c_inq
340: WHERE CLID$$CS ='''||l_user_name||''' AND TRANID$$ = '||l_tran_id
341: ||' AND EXISTS(SELECT 1 FROM ASG_PUB_ITEM WHERE ITEM_ID = c_inq.STORE) ' ;
342: LOOP
343: FETCH cur INTO r_pub_item_store;