DBA Data[Home] [Help]

APPS.FND_IMP_PKG dependencies on AD_SNAPSHOTS

Line 11: from ad_snapshots adts where adts.snapshot_id = snapshot_id__

7: BEGIN
8: select max(z.ts) into answ__
9: from
10: (select max(greatest(adts.snapshot_creation_date, adts.snapshot_update_date, adts.creation_date, adts.last_update_date)) ts
11: from ad_snapshots adts where adts.snapshot_id = snapshot_id__
12: UNION ALL
13: select max(greatest(umsts.last_update_date, umsts.last_definition_date)) ts
14: from fnd_ums_bugfixes umsts
15: where umsts.bug_number = (select bug_number from ad_pm_patches where patch_id = patch_id__) AND --ang