APPS.IGS_FI_AD_HOC_WAV dependencies on IGS_LOOKUP_VALUES

Line 79: FUNCTION lookup_desc( p_type IN igs_lookup_values.lookup_type%TYPE,

75: RETURN l_string;
76:
77: END fee_perd;
78:
79: FUNCTION lookup_desc( p_type IN igs_lookup_values.lookup_type%TYPE,
80: p_code IN igs_lookup_values.lookup_code%TYPE ) RETURN VARCHAR2 IS
81: ------------------------------------------------------------------
82: --Created by : Jabeen Begum, Oracle IDC
83: --Date created: 5/12/2001

Line 80: p_code IN igs_lookup_values.lookup_code%TYPE ) RETURN VARCHAR2 IS

76:
77: END fee_perd;
78:
79: FUNCTION lookup_desc( p_type IN igs_lookup_values.lookup_type%TYPE,
80: p_code IN igs_lookup_values.lookup_code%TYPE ) RETURN VARCHAR2 IS
81: ------------------------------------------------------------------
82: --Created by : Jabeen Begum, Oracle IDC
83: --Date created: 5/12/2001
84: --

Line 93: --vvutukur 21-Jan-2003 Bug#2751136.Used igs_lookup_values in stead of igs_lookups_view.Removed cursor cur_desc and its implementation,instead,

89: --Known limitations/enhancements and/or remarks:
90: --
91: --Change History:
92: --Who When What
93: --vvutukur 21-Jan-2003 Bug#2751136.Used igs_lookup_values in stead of igs_lookups_view.Removed cursor cur_desc and its implementation,instead,
94: -- made a call to igs_fi_gen_gl.get_lkp_meaning,which returns the meaning of lookup code of a specific lookup type.
95: -------------------------------------------------------------------
96: l_desc igs_lookup_values.meaning%TYPE;
97:

Line 96: l_desc igs_lookup_values.meaning%TYPE;

92: --Who When What
93: --vvutukur 21-Jan-2003 Bug#2751136.Used igs_lookup_values in stead of igs_lookups_view.Removed cursor cur_desc and its implementation,instead,
94: -- made a call to igs_fi_gen_gl.get_lkp_meaning,which returns the meaning of lookup code of a specific lookup type.
95: -------------------------------------------------------------------
96: l_desc igs_lookup_values.meaning%TYPE;
97:
98: BEGIN
99:
100: IF p_code IS NULL THEN

Line 156: -- with igs_lookup_values.

152: --
153: --Change History:
154: --Who When What
155: --pathipat 26-Apr-2004 Bug 3578249 - Modified cur_mode - replaced fnd_lookup_values
156: -- with igs_lookup_values.
157: --vvutukur 20-Jan-2004 Bug#3348787.Modified cursor cur_mode.
158: -------------------------------------------------------------------
159:
160: CURSOR cur_mode(cp_code fnd_lookup_values.lookup_code%TYPE) IS

Line 162: FROM igs_lookup_values

158: -------------------------------------------------------------------
159:
160: CURSOR cur_mode(cp_code fnd_lookup_values.lookup_code%TYPE) IS
161: SELECT meaning
162: FROM igs_lookup_values
163: WHERE lookup_code = cp_code
164: AND lookup_type = 'YES_NO';
165:
166: l_mode fnd_lookup_values.meaning%TYPE ;