APPS.AHL_FMP_COMMON_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 33: FROM FND_LOOKUP_VALUES_VL

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

Line 43: FROM FND_LOOKUP_VALUES_VL

39: CURSOR get_rec_from_id ( c_lookup_type FND_LOOKUPS.lookup_type%TYPE,
40: c_lookup_code FND_LOOKUPS.lookup_code%TYPE )
41: IS
42: SELECT lookup_code
43: FROM FND_LOOKUP_VALUES_VL
44: WHERE lookup_type = c_lookup_type
45: AND lookup_code = c_lookup_code
46: AND SYSDATE BETWEEN NVL( start_date_active, SYSDATE ) AND
47: NVL( end_date_active, SYSDATE );

Line 630: fnd_lookup_values_vl IT

626: --ahl_item_associations_v igass ,
627: ahl_item_associations_vl igass, --priyan changes due to performance reasons , Refer Bug # 5078530
628: mtl_system_items_kfv MTL,
629: mtl_item_status STAT,
630: fnd_lookup_values_vl IT
631: WHERE mch.mc_header_id = mcr.mc_header_id
632: and mch.mc_id = mcp.mc_id
633: and mch.version_number = nvl(mcp.version_number, mch.version_number)
634: and mcr.position_key = mcp.position_key