DBA Data[Home] [Help]

APPS.BIS_BIA_RSG_LOG_MGMNT dependencies on DUAL

Line 144: ---base summary tables, which are currently managed by individual

140:
141: ---this API check if MV patch has been applied after
142: ---last time the MV log being captured/dropped/created
143: ----please note that this API can't handle MV logs attached to
144: ---base summary tables, which are currently managed by individual
145: ---product teams by calling BIA custom API
146:
147: function check_obj_patch_applied(p_base_object_name in varchar2,p_base_object_type in varchar2) return varchar2 is
148:

Line 345: from dual

341: and object_type=P_base_object_type;
342:
343: cursor log_exist is
344: select 'Y'
345: from dual
346: where exists(
347: select log_table
348: from all_snapshot_logs
349: where master=p_base_object_name