APPS.AHL_PRD_NONROUTINE_PVT dependencies on PA_LOOKUPS

Line 1452: FROM pa_lookups

1448:
1449: -- STHILAK PIE Integration
1450: CURSOR sr_service_type_code (p_service_type IN VARCHAR2) IS
1451: SELECT LOOKUP_CODE
1452: FROM pa_lookups
1453: WHERE upper(MEANING) = p_service_type
1454: AND LOOKUP_TYPE = 'SERVICE TYPE'
1455: AND ENABLED_FLAG = 'Y'
1456: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE, SYSDATE - 1))