APPS.PA_PROJ_ELEMENTS_UTILS dependencies on PA_LOOKUPS

Line 247: FROM pa_lookups

243:
244: CURSOR cur_lookups
245: IS
246: SELECT meaning
247: FROM pa_lookups
248: WHERE lookup_type = 'PA_STRUCTURE_TYPE_CLASS'
249: AND lookup_code = p_structure_type_code;
250:
251:

Line 2584: from pa_lookups

2580: RETURN VARCHAR2
2581: IS
2582: cursor c1 is
2583: select meaning
2584: from pa_lookups
2585: where lookup_type = p_lookup_type
2586: and lookup_code = p_lookup_code;
2587: l_dummy varchar2(80);
2588: l_index varchar2(100); -- Bug 6156686

Line 5172: FROM pa_lookups

5168: IS
5169: CURSOR chk_lkp(cp_lookup_type VARCHAR2, cp_lookup_code VARCHAR2)
5170: IS
5171: SELECT 'Y'
5172: FROM pa_lookups
5173: WHERE lookup_type = cp_lookup_type
5174: AND lookup_code = cp_lookup_code;
5175: l_dummy varchar2(1):='Y';
5176: BEGIN