APPS.IGS_FI_SS_ACCT_PAYMENT dependencies on IGS_LOOKUPS_VIEW

Line 68: FUNCTION lookup_desc( l_type in igs_lookups_view.lookup_type%TYPE ,

64: -- Also added the local procedure lookup_desc
65: ------------------------------------------------------------------
66:
67:
68: FUNCTION lookup_desc( l_type in igs_lookups_view.lookup_type%TYPE ,
69: l_code in igs_lookups_view.lookup_code%TYPE
70: )RETURN VARCHAR2 IS
71: /******************************************************************
72: Created By : jbegum

Line 69: l_code in igs_lookups_view.lookup_code%TYPE

65: ------------------------------------------------------------------
66:
67:
68: FUNCTION lookup_desc( l_type in igs_lookups_view.lookup_type%TYPE ,
69: l_code in igs_lookups_view.lookup_code%TYPE
70: )RETURN VARCHAR2 IS
71: /******************************************************************
72: Created By : jbegum
73: Date Created By : 25-FEB-2002

Line 85: CURSOR cur_desc( x_type igs_lookups_view.lookup_type%TYPE, x_code igs_lookups_view.lookup_code%TYPE ) IS

81: smadathi 13-nov-2002 Bug 2584986. Modified cursor cur_desc
82: select list to fetch meaning from igs_lookup_values
83: ******************************************************************/
84:
85: CURSOR cur_desc( x_type igs_lookups_view.lookup_type%TYPE, x_code igs_lookups_view.lookup_code%TYPE ) IS
86: SELECT meaning
87: FROM igs_lookup_values
88: WHERE lookup_type = x_type
89: AND lookup_code = x_code

Line 94: l_desc igs_lookups_view.meaning%TYPE;

90: AND (SYSDATE BETWEEN NVL(start_date_active,SYSDATE)
91: AND NVL(end_date_active,SYSDATE))
92: AND enabled_flag = 'Y';
93:
94: l_desc igs_lookups_view.meaning%TYPE;
95:
96: BEGIN
97: IF l_code IS NULL OR l_type IS NULL THEN
98: RETURN NULL ;