DBA Data[Home] [Help]

APPS.PN_INDEX_RENT_UTILS dependencies on FND_LOOKUP_VALUES_VL

Line 136: FROM fnd_lookup_values_vl flv

132:
133: CURSOR c_lookup_type
134: IS
135: SELECT flv.lookup_code
136: FROM fnd_lookup_values_vl flv
137: WHERE flv.lookup_type = p_lookup_type
138: AND TRUNC (SYSDATE) BETWEEN TRUNC (NVL (flv.start_date_active
139: , SYSDATE))
140: AND TRUNC (NVL (flv.end_date_active

Line 148: FROM fnd_lookup_values_vl flv

144:
145: CURSOR c_lookup_type_code
146: IS
147: SELECT flv.lookup_code
148: FROM fnd_lookup_values_vl flv
149: WHERE flv.lookup_type = p_lookup_type
150: AND TRUNC (SYSDATE) BETWEEN TRUNC (NVL (flv.start_date_active
151: , SYSDATE))
152: AND TRUNC (NVL (flv.end_date_active