APPS.AHL_FMP_COMMON_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 24: FROM FND_LOOKUP_VALUES_VL

20: CURSOR get_rec_from_value ( c_lookup_type FND_LOOKUPS.lookup_type%TYPE,
21: c_lookup_meaning FND_LOOKUPS.meaning%TYPE )
22: IS
23: SELECT lookup_code
24: FROM FND_LOOKUP_VALUES_VL
25: WHERE lookup_type = c_lookup_type
26: AND meaning = c_lookup_meaning
27: AND SYSDATE BETWEEN NVL( start_date_active, SYSDATE ) AND
28: NVL( end_date_active, SYSDATE );

Line 34: FROM FND_LOOKUP_VALUES_VL

30: CURSOR get_rec_from_id ( c_lookup_type FND_LOOKUPS.lookup_type%TYPE,
31: c_lookup_code FND_LOOKUPS.lookup_code%TYPE )
32: IS
33: SELECT lookup_code
34: FROM FND_LOOKUP_VALUES_VL
35: WHERE lookup_type = c_lookup_type
36: AND lookup_code = c_lookup_code
37: AND SYSDATE BETWEEN NVL( start_date_active, SYSDATE ) AND
38: NVL( end_date_active, SYSDATE );

Line 619: fnd_lookup_values_vl IT

615: --ahl_item_associations_v igass ,
616: ahl_item_associations_vl igass, --priyan changes due to performance reasons , Refer Bug # 5078530
617: mtl_system_items_kfv MTL,
618: mtl_item_status STAT,
619: fnd_lookup_values_vl IT
620: WHERE mch.mc_header_id = mcr.mc_header_id
621: and mch.mc_id = mcp.mc_id
622: and mch.version_number = nvl(mcp.version_number, mch.version_number)
623: and mcr.position_key = mcp.position_key