APPS.AHL_VWP_VISITS_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 1193: FND_LOOKUP_VALUES_VL FLVT, FND_LOOKUP_VALUES_VL FLVT1,

1189: AVTS.UNIT_SCHEDULE_ID, AVTS.ASSO_PRIMARY_VISIT_ID
1190: FROM AHL_VISITS_VL AVTS, AHL_SIMULATION_PLANS_VL ASPV,
1191: CSI_ITEM_INSTANCES CSIS, HR_ALL_ORGANIZATION_UNITS HROU,
1192: BOM_DEPARTMENTS BDPT, MTL_SYSTEM_ITEMS_B_KFV MTSB,
1193: FND_LOOKUP_VALUES_VL FLVT, FND_LOOKUP_VALUES_VL FLVT1,
1194: FND_LOOKUP_VALUES_VL FLVT2, FND_LOOKUP_VALUES_VL FLVT3,
1195: PA_PROJECTS_ALL PA, AHL_UNIT_CONFIG_HEADERS UC, CS_INCIDENTS_ALL_B CSAB
1196: WHERE AVTS.ITEM_INSTANCE_ID = UC.CSI_ITEM_INSTANCE_ID(+)
1197: AND AVTS.ITEM_INSTANCE_ID = CSIS.INSTANCE_ID(+)

Line 1194: FND_LOOKUP_VALUES_VL FLVT2, FND_LOOKUP_VALUES_VL FLVT3,

1190: FROM AHL_VISITS_VL AVTS, AHL_SIMULATION_PLANS_VL ASPV,
1191: CSI_ITEM_INSTANCES CSIS, HR_ALL_ORGANIZATION_UNITS HROU,
1192: BOM_DEPARTMENTS BDPT, MTL_SYSTEM_ITEMS_B_KFV MTSB,
1193: FND_LOOKUP_VALUES_VL FLVT, FND_LOOKUP_VALUES_VL FLVT1,
1194: FND_LOOKUP_VALUES_VL FLVT2, FND_LOOKUP_VALUES_VL FLVT3,
1195: PA_PROJECTS_ALL PA, AHL_UNIT_CONFIG_HEADERS UC, CS_INCIDENTS_ALL_B CSAB
1196: WHERE AVTS.ITEM_INSTANCE_ID = UC.CSI_ITEM_INSTANCE_ID(+)
1197: AND AVTS.ITEM_INSTANCE_ID = CSIS.INSTANCE_ID(+)
1198: AND AVTS.ORGANIZATION_ID = HROU.ORGANIZATION_ID(+)

Line 1386: FROM FND_LOOKUP_VALUES_VL

1382:
1383: -- To find meaning for fnd_lookups code
1384: IF (visit_rec.project_flag IS NOT NULL) THEN
1385: SELECT MEANING INTO l_project_flag
1386: FROM FND_LOOKUP_VALUES_VL
1387: WHERE LOOKUP_CODE = visit_rec.project_flag
1388: AND LOOKUP_TYPE = 'AHL_YES_NO_TYPE';
1389: END IF;
1390: ----------------------------------- FOR VISITS --------------------------------------