DBA Data[Home] [Help]

APPS.FND_AUDIT_REPORT dependencies on FND_ORACLE_USERID

Line 223: fnd_audit_schemas d, fnd_oracle_userid u

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