DBA Data[Home] [Help]

APPS.BSC_BSC_XTD_PKG dependencies on BSC_APPS

Line 40: cursor c1 is SELECT TABLE_NAME FROM ALL_TABLES WHERE TABLE_NAME LIKE 'BSC_RPT_KEYS_%' AND TEMPORARY='Y' AND OWNER = BSC_APPS.get_user_schema;

36: p_user_id number,
37: p_error_message out nocopy varchar2
38: )is
39: l_stmt varchar2(1000);
40: cursor c1 is SELECT TABLE_NAME FROM ALL_TABLES WHERE TABLE_NAME LIKE 'BSC_RPT_KEYS_%' AND TEMPORARY='Y' AND OWNER = BSC_APPS.get_user_schema;
41: l_table varchar2(100);
42: Begin
43: -- Changed by Arun for bug/enh 4676527
44: delete bsc_rpt_keys;