DBA Data[Home] [Help]

APPS.FND_AUDIT_REPORT dependencies on FND_ORACLE_USERID

Line 226: fnd_audit_schemas d, fnd_oracle_userid u

222: cursor c16 (p_audit_group_id number, p_table_id number) is
223: select u.oracle_username, decode(d.state,'R','Audit Enabled',
224: 'X','Audit Disabled', d.state) state
225: from fnd_audit_tables t, sys.dba_tables a, fnd_tables b,
226: fnd_audit_schemas d, fnd_oracle_userid u
227: where u.oracle_id = d.oracle_id
228: and a.owner = u.oracle_username
229: and t.table_id = b.table_id
230: and d.oracle_id = u.oracle_id