DBA Data[Home] [Help]

APPS.JG_ZZ_SUMMARY_ALL_PKG dependencies on FND_FLEX_VALUES_VL

Line 1428: FROM fnd_flex_values_vl FFV

1424: BEGIN
1425: IF p_report_name = 'JEPTAVAT' OR p_report_name = 'JEPTPVAT' THEN
1426: SELECT FFV.description
1427: INTO l_location_name
1428: FROM fnd_flex_values_vl FFV
1429: , fnd_flex_value_sets FFVS
1430: WHERE FFV.flex_value_set_id = FFVS.flex_value_set_id
1431: AND FFVS.flex_value_set_name = 'JEPT_TAX_LOCATION'
1432: AND FFV.flex_value = P_LOCATION;