APPS.IGI_SLS_SECURITY_PKG dependencies on IGI_SLS_GROUPS_AUDIT

Line 1445: UPDATE igi_sls_groups_audit a

1441: -- of all actions then this IF condition will have to go.
1442: IF rt_c_all_group.date_disabled IS NOT NULL
1443: OR rt_c_all_group.date_removed IS NOT NULL
1444: THEN
1445: UPDATE igi_sls_groups_audit a
1446: SET a.date_security_applied = SYSDATE
1447: WHERE date_security_applied IS NULL
1448: AND ROWID = (SELECT MAX(ROWID) b
1449: FROM igi_sls_groups_audit b

Line 1449: FROM igi_sls_groups_audit b

1445: UPDATE igi_sls_groups_audit a
1446: SET a.date_security_applied = SYSDATE
1447: WHERE date_security_applied IS NULL
1448: AND ROWID = (SELECT MAX(ROWID) b
1449: FROM igi_sls_groups_audit b
1450: WHERE a.sls_group = b.sls_group)
1451: AND sls_group = rt_c_all_group.sls_group;
1452:
1453: END IF;

Line 1745: INSERT INTO igi_sls_groups_audit

1741: AND date_removed IS NULL;
1742:
1743: -- Since the group is being marked for deletion, enter a record
1744: -- into the audit table.
1745: INSERT INTO igi_sls_groups_audit
1746: (sls_group,
1747: sls_group_type,
1748: description,
1749: date_enabled,