DBA Data[Home] [Help]

APPS.JG_ZZ_SUMMARY_ALL_PKG dependencies on FND_FLEX_VALUES_VL

Line 2656: FROM fnd_flex_values_vl FFV

2652: BEGIN
2653: IF p_report_name = 'JEPTAVAT' OR p_report_name = 'JEPTPVAT' THEN
2654: SELECT FFV.description
2655: INTO l_location_name
2656: FROM fnd_flex_values_vl FFV
2657: , fnd_flex_value_sets FFVS
2658: WHERE FFV.flex_value_set_id = FFVS.flex_value_set_id
2659: AND FFVS.flex_value_set_name = 'JEPT_TAX_LOCATION'
2660: AND FFV.flex_value = P_LOCATION;