DBA Data[Home] [Help]

APPS.IGS_AD_SS_PERSON_PKG dependencies on FND_LOOKUP_VALUES

Line 222: CURSOR cur_rowid(cp_lookup_code FND_Lookup_values.lookup_code%type) IS

218: Change History
219: Who When What
220: (reverse chronological order - newest change first)
221: ***************************************************************/
222: CURSOR cur_rowid(cp_lookup_code FND_Lookup_values.lookup_code%type) IS
223: SELECT 1
224: FROM FND_LOOKUP_VALUES
225: WHERE LOOKUP_TYPE = 'HZ_GENDER'
226: AND LANGUAGE = USERENV('LANG')

Line 224: FROM FND_LOOKUP_VALUES

220: (reverse chronological order - newest change first)
221: ***************************************************************/
222: CURSOR cur_rowid(cp_lookup_code FND_Lookup_values.lookup_code%type) IS
223: SELECT 1
224: FROM FND_LOOKUP_VALUES
225: WHERE LOOKUP_TYPE = 'HZ_GENDER'
226: AND LANGUAGE = USERENV('LANG')
227: AND VIEW_APPLICATION_ID = 222
228: AND SECURITY_GROUP_ID(+) = 0