APPS.IGS_PE_HZ_REL_PKG dependencies on FND_LOOKUP_VALUES

Line 102: --asbala 15-JAN-2004 3349171: Incorrect usage of fnd_lookup_values view

98: --Known limitations/enhancements and/or remarks:
99: --
100: --Change History:
101: --Who When What
102: --asbala 15-JAN-2004 3349171: Incorrect usage of fnd_lookup_values view
103: ----------------------------------------------------------------------------------------------
104: --
105: -- cursor to get the surname, prefix, given_names of member
106: --

Line 143: p_lookup_type fnd_lookup_values.lookup_type%TYPE,

139: AND NVL(a.secondary,'N') = 'Y'
140: AND rownum = 1;
141:
142: CURSOR c_prefix_desc (p_prefix VARCHAR2,
143: p_lookup_type fnd_lookup_values.lookup_type%TYPE,
144: p_view_application_id fnd_lookup_values.view_application_id%TYPE,
145: p_security_group_id fnd_lookup_values.security_group_id%TYPE) IS
146: SELECT meaning
147: FROM fnd_lookup_values

Line 144: p_view_application_id fnd_lookup_values.view_application_id%TYPE,

140: AND rownum = 1;
141:
142: CURSOR c_prefix_desc (p_prefix VARCHAR2,
143: p_lookup_type fnd_lookup_values.lookup_type%TYPE,
144: p_view_application_id fnd_lookup_values.view_application_id%TYPE,
145: p_security_group_id fnd_lookup_values.security_group_id%TYPE) IS
146: SELECT meaning
147: FROM fnd_lookup_values
148: WHERE lookup_type = p_lookup_type

Line 145: p_security_group_id fnd_lookup_values.security_group_id%TYPE) IS

141:
142: CURSOR c_prefix_desc (p_prefix VARCHAR2,
143: p_lookup_type fnd_lookup_values.lookup_type%TYPE,
144: p_view_application_id fnd_lookup_values.view_application_id%TYPE,
145: p_security_group_id fnd_lookup_values.security_group_id%TYPE) IS
146: SELECT meaning
147: FROM fnd_lookup_values
148: WHERE lookup_type = p_lookup_type
149: AND view_application_id = p_view_application_id

Line 147: FROM fnd_lookup_values

143: p_lookup_type fnd_lookup_values.lookup_type%TYPE,
144: p_view_application_id fnd_lookup_values.view_application_id%TYPE,
145: p_security_group_id fnd_lookup_values.security_group_id%TYPE) IS
146: SELECT meaning
147: FROM fnd_lookup_values
148: WHERE lookup_type = p_lookup_type
149: AND view_application_id = p_view_application_id
150: AND language = USERENV('LANG')
151: AND security_group_id = p_security_group_id