APPS.BIS_TRUNCATE_EMPTY_MV_LOG_PKG dependencies on BIS_OBJ_PROPERTIES

Line 29: FROM fnd_concurrent_programs prog, fnd_concurrent_requests req, bis_obj_properties obj

25: rs_running_rec rs_running%rowtype;
26:
27: CURSOR mv_refresh_prog IS
28: SELECT obj.object_name Name, req.request_id request
29: FROM fnd_concurrent_programs prog, fnd_concurrent_requests req, bis_obj_properties obj
30: WHERE (prog.concurrent_program_name = 'BIS_MV_REFRESH_STANDALONE' OR prog.concurrent_program_name = 'BIS_MV_REFRESH')
31: AND prog.application_id = 191
32: AND prog.concurrent_program_id = req.concurrent_program_id
33: AND req.phase_code = 'R'

Line 40: FROM v$mvrefresh mv, bis_obj_properties obj

36: mv_refresh_prog_rec mv_refresh_prog%rowtype;
37:
38: CURSOR mv_refresh IS
39: SELECT currmvname name
40: FROM v$mvrefresh mv, bis_obj_properties obj
41: WHERE obj.object_name = currmvname;
42: mv_refresh_rec mv_refresh%rowtype;
43:
44: prog_running number;

Line 137: from bis_obj_properties

133: IS
134: TYPE curType IS REF CURSOR ;
135: cursor impl_tables is
136: select object_name, BIS_CREATE_REQUESTSET.get_object_owner(object_name, object_type) obj_owner
137: from bis_obj_properties
138: where (object_type = 'TABLE' OR object_type = 'MV');
139: impl_tables_rec impl_tables%rowtype;
140:
141: cursor log_table(obj_name varchar2, obj_owner varchar2) is