APPS.FND_AUDIT_UPDATE_PKG dependencies on FND_APPLICATION

Line 84: fnd_application fa

80: -- First get the FND schema name
81: SELECT fou.oracle_username into v_fnd_schema
82: FROM fnd_product_installations fpi,
83: fnd_oracle_userid fou,
84: fnd_application fa
85: WHERE fpi.application_id = fa.application_id
86: AND fpi.oracle_id = fou.oracle_id
87: AND fa.application_short_name = 'FND';
88:

Line 92: FROM fnd_application

88:
89:
90: -- Get Application Short Name
91: SELECT application_short_name into app_short_name
92: FROM fnd_application
93: WHERE application_id = p_taplid;
94:
95: -- Copy the Shadow Table over to saved copy
96: v_ddl_sql := 'alter table ' || v_owner ||'.' || v_shadname || ' rename to ' || v_oldtname;