DBA Data[Home] [Help]

APPS.BSC_UPDATE_LOCK dependencies on BSC_SYS_PERIODICITIES

Line 55: FROM bsc_sys_periodicities

51: h_i NUMBER;
52:
53: CURSOR c_periodicities IS
54: SELECT periodicity_id
55: FROM bsc_sys_periodicities
56: WHERE calendar_id = x_calendar_id;
57:
58: h_periodicity_id NUMBER;
59:

Line 112: FROM bsc_sys_periodicities

108: h_i NUMBER;
109:
110: CURSOR c_periodicities IS
111: SELECT periodicity_id
112: FROM bsc_sys_periodicities
113: WHERE calendar_id = x_calendar_id;
114:
115: h_periodicity_id NUMBER;
116:

Line 129: FROM bsc_sys_periodicities

125: SELECT table_name
126: FROM bsc_db_tables
127: WHERE periodicity_id IN (
128: SELECT periodicity_id
129: FROM bsc_sys_periodicities
130: WHERE calendar_id = x_calendar_id
131: );
132:
133: h_table_name VARCHAR2(50);