APPS.AHL_PRD_MTLTXN_PVT dependencies on PA_LOOKUPS

Line 2197: FROM pa_lookups

2193:
2194: --Sareepar FP PIE
2195: CURSOR service_type_code_cur (c_service_type VARCHAR2) IS
2196: SELECT lookup_code
2197: FROM pa_lookups
2198: WHERE MEANING = c_service_type
2199: AND LOOKUP_TYPE = 'SERVICE TYPE'
2200: AND ENABLED_FLAG = 'Y'
2201: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE, SYSDATE - 1))