APPS.BIS_BIA_RSG_LOG_MGMNT dependencies on ALL_SNAPSHOT_LOGS

Line 265: FROM All_SNAPSHOT_LOGS LOG

261: RETURN VARCHAR2
262: IS
263: CURSOR get_log_table IS
264: SELECT log_table
265: FROM All_SNAPSHOT_LOGS LOG
266: WHERE log.master = p_mview_name
267: AND log_owner = p_object_schema;
268: log_table_name VARCHAR2(30);
269: BEGIN

Line 348: from all_snapshot_logs

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
350: and log_owner=p_base_object_schema);
351:
352: l_mv_log_status bis_obj_properties.mv_log_status%type;

Line 583: All_SNAPSHOT_LOGS LOG

579: l_stmt varchar2(32767) := 'BEGIN
580: select count(*) into :l_count
581: from
582: bis_obj_properties PRP,
583: All_SNAPSHOT_LOGS LOG
584: where
585: log.master = PRP.object_name
586: and OBJECT_TYPE = :P_base_object_type
587: and OBJECT_NAME = :p_base_object_name

Line 823: All_SNAPSHOT_LOGS LOG

819:
820: /** commented out per enhancement 4222518
821: select count(*) into l_exist
822: from
823: All_SNAPSHOT_LOGS LOG
824: where
825: log.master = P_OBJ_NAME
826: and log.log_owner = l_owner;
827:

Line 849: * all_snapshot_logs in this query

845: c_all_log_base_obj curType;
846: /*
847: * l_stmt was modified to consider MV type object only due to bug3901782
848: * 23-Mar-2005 l_stmt is modified per enhancement 4222518. Not join with
849: * all_snapshot_logs in this query
850: */
851: l_stmt varchar2(32767) := '
852: select DISTINCT PRP.object_name, PRP.object_type,
853: BIS_CREATE_REQUESTSET.get_object_owner(prp.object_name, prp.object_type) object_owner