APPS.AHL_PRD_DISPOSITION_PVT dependencies on PA_LOOKUPS

Line 3970: FROM pa_lookups

3966:
3967: -- AVIKUKUM::PIE::FP::19-OCT-2010
3968: CURSOR service_type_code_csr (c_service_type VARCHAR2) IS
3969: SELECT lookup_code
3970: FROM pa_lookups
3971: WHERE lookup_type = 'SERVICE TYPE'
3972: AND enabled_flag = 'Y'
3973: AND meaning = c_service_type
3974: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active,SYSDATE-1))