APPS.PER_SHT_SHD dependencies on DUAL

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

383: ,p_information_category in varchar2 default null
384: ,p_lookup_type in varchar2 default null
385: ,p_owner in varchar2 default 'CUSTOM'
386: ) is
387: cursor c1 is select userenv('LANG') from dual;
388:
389: cursor c2 is select shared_type_id,last_updated_by from per_shared_types
390: where shared_type_code = p_shared_type_code
391: and lookup_type = p_lookup_type

Line 601: select per_shared_types_s.nextval into l_shared_type_id from dual;

597: else
598: -- neither key record, nor lookup_type and system_type_cd combination exists
599: -- creating a new record for share_type
600:
601: select per_shared_types_s.nextval into l_shared_type_id from dual;
602: insert into per_shared_types (shared_type_id,
603: shared_type_name,
604: shared_type_code,
605: lookup_type,