DBA Data[Home] [Help]

APPS.PQH_CEF_SHD dependencies on DUAL

Line 259: cursor c1 is select userenv('LANG') from dual ;

255: l_creation_date pqh_copy_entity_functions.creation_date%TYPE;
256: l_last_update_date pqh_copy_entity_functions.last_update_date%TYPE;
257: l_last_update_login pqh_copy_entity_functions.last_update_login%TYPE;
258: --
259: cursor c1 is select userenv('LANG') from dual ;
260: --
261: --
262: -- developer key is table_alias + function_type_cd + context
263: --

Line 341: select pqh_copy_entity_functions_s.nextval into l_copy_entity_function_id from dual;

337: and nvl(last_updated_by , -1) in (l_last_updated_by,-1,1);
338: else
339: -- insert row
340:
341: select pqh_copy_entity_functions_s.nextval into l_copy_entity_function_id from dual;
342: --
343: -- Added the following code as a part of Zero Downtime Patching Project.
344: -- Code Starts Here.
345: --