DBA Data[Home] [Help]

APPS.GL_FEEDER_INFO_PKG dependencies on GL_LOOKUPS

Line 12: FROM gl_lookups lkp, gl_encumbrance_types types

8: x_oth_name IN OUT NOCOPY VARCHAR2) IS
9:
10: CURSOR c_req IS
11: SELECT types.encumbrance_type_id, lpad(lkp.meaning, 20)
12: FROM gl_lookups lkp, gl_encumbrance_types types
13: WHERE lkp.lookup_type='LITERAL'
14: and types.encumbrance_type_id = 1000
15: and upper(lkp.lookup_code) = UPPER(types.encumbrance_type);
16:

Line 19: FROM gl_lookups lkp, gl_encumbrance_types types

15: and upper(lkp.lookup_code) = UPPER(types.encumbrance_type);
16:
17: CURSOR c_po IS
18: SELECT types.encumbrance_type_id, lpad(lkp.meaning, 20)
19: FROM gl_lookups lkp, gl_encumbrance_types types
20: WHERE lkp.lookup_type='LITERAL'
21: and types.encumbrance_type_id = 1001
22: and upper(lkp.lookup_code) = UPPER(types.encumbrance_type);
23:

Line 26: FROM gl_lookups

22: and upper(lkp.lookup_code) = UPPER(types.encumbrance_type);
23:
24: CURSOR c_oth IS
25: SELECT lpad(meaning, 20)
26: FROM gl_lookups
27: WHERE lookup_type='LITERAL'
28: AND lookup_code='OTHER';
29:
30: BEGIN