APPS.IGI_SLS_SECURITY_PKG dependencies on FND_ORACLE_USERID

Line 95: FROM fnd_oracle_userid

91: IS
92:
93: CURSOR c_get_install_num IS
94: SELECT install_group_num
95: FROM fnd_oracle_userid
96: WHERE read_only_flag = 'U'
97: ORDER BY install_group_num;
98:
99: CURSOR c_get_flag IS

Line 107: FROM fnd_oracle_userid

103:
104: CURSOR c_get_schema_name (p_install_group_num NUMBER,
105: p_read_only_flag VARCHAR2) IS
106: SELECT oracle_username
107: FROM fnd_oracle_userid
108: WHERE (install_group_num = p_install_group_num
109: OR install_group_num = (SELECT MIN (install_group_num)
110: FROM fnd_oracle_userid
111: WHERE 1=DECODE(p_install_group_num,0,1,2)

Line 110: FROM fnd_oracle_userid

106: SELECT oracle_username
107: FROM fnd_oracle_userid
108: WHERE (install_group_num = p_install_group_num
109: OR install_group_num = (SELECT MIN (install_group_num)
110: FROM fnd_oracle_userid
111: WHERE 1=DECODE(p_install_group_num,0,1,2)
112: AND read_only_flag = p_read_only_flag))
113: AND read_only_flag = p_read_only_flag;
114:

Line 1930: l_schema fnd_oracle_userid.oracle_username%TYPE;

1926: l_count NUMBER := 0;
1927: l_dup_tabs_exist BOOLEAN := FALSE;
1928: l_sql_stmt VARCHAR2(2000);
1929:
1930: l_schema fnd_oracle_userid.oracle_username%TYPE;
1931: l_prod_status fnd_product_installations.status%TYPE;
1932: l_industry fnd_product_installations.industry%TYPE;
1933:
1934: