DBA Data[Home] [Help]

APPS.AD_POST_PATCH dependencies on AD_SNAPSHOTS

Line 28: from ad_snapshots

24: -- Get the snapshot_id for use later.
25:
26: select snapshot_id
27: into v_snapshot_id
28: from ad_snapshots
29: where appl_top_id = p_appltop_id
30: and snapshot_name = 'CURRENT_VIEW'
31: and snapshot_type = 'C';
32:

Line 106: from ad_snapshots

102: -- Get the snapshot_id for use later.
103:
104: select snapshot_id
105: into v_snapshot_id
106: from ad_snapshots
107: where appl_top_id = p_appltop_id
108: and snapshot_name = 'CURRENT_VIEW'
109: and snapshot_type = 'C';
110:

Line 187: from ad_snapshots

183: --execute immediate v_sql_stmt;
184:
185: select snapshot_id
186: into v_snapshot_id
187: from ad_snapshots
188: where appl_top_id = p_appltop_id
189: and snapshot_name = 'CURRENT_VIEW'
190: and snapshot_type = 'C';
191:

Line 274: from ad_snapshots

270: -- execute immediate v_sql_stmt;
271:
272: select snapshot_id
273: into v_snapshot_id
274: from ad_snapshots
275: where appl_top_id = p_appltop_id
276: and snapshot_name = 'CURRENT_VIEW'
277: and snapshot_type = 'C';
278:

Line 361: from ad_snapshots

357: -- Dont truncate the table ad_processed_files_temp!!!
358:
359: select snapshot_id
360: into v_snapshot_id
361: from ad_snapshots
362: where appl_top_id = p_appltop_id
363: and snapshot_name = 'CURRENT_VIEW'
364: and snapshot_type = 'C';
365: