APPS.FND_AUDIT_REPORT dependencies on FND_AUDIT_GROUPS

Line 87: from fnd_audit_groups g

83: profvalue varchar2(255) := NULL;
84:
85: cursor c0 (p_group_name varchar2) is
86: select g.group_name
87: from fnd_audit_groups g
88: where g.group_name = nvl(p_group_name, g.group_name);
89:
90: cursor c1 (p_group_name varchar2) is
91: select g.group_name, b.table_name, g.audit_group_id, t.table_id, a.application_short_name

Line 92: from fnd_audit_groups g, fnd_audit_tables t, fnd_tables b, fnd_application a

88: where g.group_name = nvl(p_group_name, g.group_name);
89:
90: cursor c1 (p_group_name varchar2) is
91: select g.group_name, b.table_name, g.audit_group_id, t.table_id, a.application_short_name
92: from fnd_audit_groups g, fnd_audit_tables t, fnd_tables b, fnd_application a
93: where g.audit_group_id = t.audit_group_id
94: and t.table_id = b.table_id
95: and g.group_name = p_group_name
96: and t.table_app_id = a.application_id;

Line 184: from fnd_audit_groups g, fnd_audit_tables t , fnd_tables b

180: 'G','Disable - Prepare for Archive',
181: 'D','Disable - Purge Table',
182: 'E','Enabled',
183: g.state) state
184: from fnd_audit_groups g, fnd_audit_tables t , fnd_tables b
185: where t.audit_group_id = g.audit_group_id
186: and t.table_id = b.table_id
187: and t.table_id in (
188: select t2.table_id