DBA Data[Home] [Help]

APPS.HZ_PURGE dependencies on USER_OBJECTS

Line 304: select to_date(timestamp,'YYYY-MM-DD:HH24:MI:SS') from sys.user_objects

300: cursor printparties is
301: select h.party_id, p.party_name from hz_purge_gt h, hz_parties p where h.party_id=p.party_id;
302:
303: cursor time_stmp is
304: select to_date(timestamp,'YYYY-MM-DD:HH24:MI:SS') from sys.user_objects
305: where object_type='PACKAGE BODY' and status='VALID'and object_name='HZ_PURGE_GEN';
306:
307: cursor dict_update_date is
308: select max(last_update_date) from hz_merge_dictionary;