DBA Data[Home] [Help]

APPS.PN_LEASE_UTILS dependencies on FND_LOOKUP_VALUES_VL

Line 43: FROM fnd_lookup_values_vl flv

39:
40: CURSOR c_lookup_type
41: IS
42: SELECT flv.lookup_code
43: FROM fnd_lookup_values_vl flv
44: WHERE flv.lookup_type = p_lookup_type
45: AND TRUNC (SYSDATE) BETWEEN TRUNC (NVL (flv.start_date_active
46: , SYSDATE))
47: AND TRUNC (NVL (flv.end_date_active

Line 55: FROM fnd_lookup_values_vl flv

51:
52: CURSOR c_lookup_type_code
53: IS
54: SELECT flv.lookup_code
55: FROM fnd_lookup_values_vl flv
56: WHERE flv.lookup_type = p_lookup_type
57: AND TRUNC (SYSDATE) BETWEEN TRUNC (NVL (flv.start_date_active
58: , SYSDATE))
59: AND TRUNC (NVL (flv.end_date_active