DBA Data[Home] [Help]

APPS.PQH_SAT_SHD dependencies on DUAL

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

268: l_creation_date pqh_special_attributes.creation_date%TYPE;
269: l_last_update_date pqh_special_attributes.last_update_date%TYPE;
270: l_last_update_login pqh_special_attributes.last_update_login%TYPE;
271: --
272: cursor c1 is select userenv('LANG') from dual ;
273: --
274: --
275: -- developer key is TXN_CATEGORY_ATTRIBUTE_ID + ATTRIBUTE_TYPE_CD + CONTEXT
276: --

Line 395: select pqh_special_attributes_s.nextval into l_special_attribute_id from dual;

391: and nvl(last_updated_by, -1) in (l_last_updated_by,-1,0,1,120,121,122);
392:
393: else
394: -- insert
395: select pqh_special_attributes_s.nextval into l_special_attribute_id from dual;
396:
397: --
398: -- Added the following code as a part of Zero Downtime Patching Project.
399: -- Code Starts Here.