DBA Data[Home] [Help]

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 2491: from pa_lookups

2487: RETURN VARCHAR2
2488: IS
2489: cursor c1 is
2490: select meaning
2491: from pa_lookups
2492: where lookup_type = p_lookup_type
2493: and lookup_code = p_lookup_code;
2494: l_dummy varchar2(80);
2495: l_index varchar2(100); -- Bug 6156686

Line 5078: FROM pa_lookups

5074: IS
5075: CURSOR chk_lkp(cp_lookup_type VARCHAR2, cp_lookup_code VARCHAR2)
5076: IS
5077: SELECT 'Y'
5078: FROM pa_lookups
5079: WHERE lookup_type = cp_lookup_type
5080: AND lookup_code = cp_lookup_code;
5081: l_dummy varchar2(1):='Y';
5082: BEGIN