APPS.IGI_SLS_SECURITY_PKG dependencies on IGI_SLS_CONSOLIDATE_GROUPS

Line 1511: FROM igi_sls_consolidate_groups

1507:
1508: CURSOR c_cons_recs IS
1509: SELECT from_sls_security_group,
1510: to_sls_security_group
1511: FROM igi_sls_consolidate_groups
1512: WHERE date_security_applied IS NULL;
1513:
1514: CURSOR c_grp_alloc (p_sls_group igi_sls_groups.sls_group%TYPE) IS
1515: SELECT sls_group,

Line 1680: igi_sls_consolidate_groups b

1676: -- Mark it enabled.
1677: SELECT COUNT(*)
1678: INTO l_enab_rec_count
1679: FROM igi_sls_allocations a,
1680: igi_sls_consolidate_groups b
1681: WHERE a.sls_group = b.from_sls_security_group
1682: AND a.date_disabled IS NULL
1683: AND a.date_removed IS NULL
1684: AND a.sls_allocation = rt_c_grp_alloc.sls_allocation

Line 1775: UPDATE igi_sls_consolidate_groups

1771: FROM igi_sls_groups
1772: WHERE sls_group = rt_c_cons_recs.from_sls_security_group
1773: AND date_removed = l_sysdate;
1774:
1775: UPDATE igi_sls_consolidate_groups
1776: SET date_security_applied = SYSDATE,
1777: last_update_login = to_number(fnd_profile.value('LOGIN_ID')),
1778: last_update_date = SYSDATE,
1779: last_updated_by = to_number(fnd_profile.value('USER_ID'))