[Home] [Help]
38:
39: -- cusrsor to get env. variables
40: cursor cr_env (p_qname in varchar2, p_appId in NUMBER ) IS
41: select VARIABLE_NAME, VALUE
42: from FND_ENV_CONTEXT
43: where CONCURRENT_PROCESS_ID in
44: (select max(CONCURRENT_PROCESS_ID)
45: from FND_CONCURRENT_PROCESSES fcp , FND_CONCURRENT_QUEUES fcq
46: where fcp.CONCURRENT_QUEUE_ID = fcq.CONCURRENT_QUEUE_ID