313:
314: select ORACLE_USERNAME
315: into G_SCHEMA
316: from FND_ORACLE_USERID a, 317: FND_APPLICATION b, 318: FND_PRODUCT_INSTALLATIONS c
319: where a.ORACLE_ID = c.ORACLE_ID
320: and c.APPLICATION_ID = b.APPLICATION_ID
321: and b.APPLICATION_SHORT_NAME = 'ZPB';