APPS.AMW_UTILITY_PVT dependencies on AMW_LOOKUPS

Line 107: p_lookup_table_name IN VARCHAR2 := g_amw_lookups,

103: -- HISTORY
104: -- 4/20/2003 mpande Created.
105: ---------------------------------------------------------------------
106: FUNCTION check_lookup_exists(
107: p_lookup_table_name IN VARCHAR2 := g_amw_lookups,
108: p_lookup_type IN VARCHAR2,
109: p_lookup_code IN VARCHAR2
110: )
111: Return VARCHAR2

Line 119: IF p_lookup_table_name = g_amw_lookups THEN

115: l_count NUMBER;
116:
117: BEGIN
118:
119: IF p_lookup_table_name = g_amw_lookups THEN
120: return check_lookup_exists (
121: p_lookup_type => p_lookup_type
122: , p_lookup_code => p_lookup_code
123: , p_view_application_id => 242

Line 635: FROM amw_lookups

631: l_meaning VARCHAR2(80);
632:
633: CURSOR c_meaning IS
634: SELECT meaning
635: FROM amw_lookups
636: WHERE lookup_type = UPPER (p_lookup_type)
637: AND lookup_code = UPPER (p_lookup_code);
638: BEGIN
639: OPEN c_meaning;

Line 687: from amw_lookups

683: l_meaning varchar2(80);
684: begin
685: select meaning
686: into l_meaning
687: from amw_lookups
688: where lookup_type = p_lookup_type
689: and lookup_code = p_lookup_code;
690:
691: return l_meaning;

Line 1697: AMW_LOOKUPS

1693:
1694: CURSOR EX_REASONS(p_exception_id in NUMBER) IS
1695: SELECT MEANING
1696: FROM AMW_EXCEPTIONS_REASONS,
1697: AMW_LOOKUPS
1698: WHERE LOOKUP_TYPE = 'AMW_EXCEPTION_REASONS'
1699: AND LOOKUP_CODE = REASON_CODE
1700: AND EXCEPTION_ID = p_exception_id;
1701: