DBA Data[Home] [Help]

APPS.IGS_GE_GEN_004 dependencies on IGS_LOOKUP_VALUES

Line 15: -- asbala 23-JUL-2003 Changed IGS_lookup_view to igs_lookup_values in CURSOR c_lookup_meaning

11: -- sjadhav 16-aug-2001 removed hardcoded reference to
12: -- apps schema in cursor c_user_name
13: -- msrinivi 25-AUG-2001 Bug No. 1956374 .The function GENP_VAL_bus_day
14: -- removed .
15: -- asbala 23-JUL-2003 Changed IGS_lookup_view to igs_lookup_values in CURSOR c_lookup_meaning
16: --asbala 23-JUL-03 Bug No:2667343 populating x_meaning from lookup_type = Report_Type and lookup_code = A
17: -- instead of hard coded string 'All'.
18: ------------------------------------------------------------------
19:

Line 45: --asbala 23-JUL-03 Changed igs_lookups_view to igs_lookup_values

41: FUNCTION GENP_GET_LOOKUP(
42: p_lookup_type IN VARCHAR2,
43: p_lookup_code IN VARCHAR2)
44: RETURN VARCHAR2 IS
45: --asbala 23-JUL-03 Changed igs_lookups_view to igs_lookup_values
46: CURSOR c_lookup_meaning(cp_lookup_type VARCHAR2,
47: cp_lookup_code VARCHAR2) IS
48: SELECT meaning
49: FROM IGS_LOOKUP_VALUES

Line 49: FROM IGS_LOOKUP_VALUES

45: --asbala 23-JUL-03 Changed igs_lookups_view to igs_lookup_values
46: CURSOR c_lookup_meaning(cp_lookup_type VARCHAR2,
47: cp_lookup_code VARCHAR2) IS
48: SELECT meaning
49: FROM IGS_LOOKUP_VALUES
50: WHERE lookup_type=cp_lookup_type AND
51: lookup_code=cp_lookup_code;
52: x_meaning VARCHAR2(80);
53: BEGIN