APPS.GL_DRM_INTEGRATION_PKG dependencies on FND_FLEX_VALUES_VL

Line 883: fnd_flex_values vl

879: -- get flex_value_id
880: SELECT vl.flex_value_id
881: INTO l_n_flex_value_id
882: FROM
883: fnd_flex_values vl
884: WHERE
885: vl.flex_value_set_id = g_value_set_id AND
886: vl.flex_value = g_flex_values_tbl(i).flex_value;
887:

Line 1160: FROM FND_FLEX_VALUES_VL ffv

1156: IS
1157: SELECT
1158: FFV.flex_value TOP_NODE,
1159: FFV.description
1160: FROM FND_FLEX_VALUES_VL ffv
1161: WHERE FFV.flex_value_set_id = p_value_set_id
1162: AND FFV.summary_flag = 'Y'
1163: AND NOT EXISTS
1164: (SELECT 'X'

Line 1216: FROM fnd_flex_values_vl ffv,

1212: ffv.end_date_active,
1213: ffv.compiled_value_attributes,
1214: ffh.hierarchy_code rollup_group,
1215: ffv.hierarchy_level
1216: FROM fnd_flex_values_vl ffv,
1217: fnd_flex_hierarchies ffh
1218: WHERE ffv.flex_value_set_id = p_value_set_id
1219: AND ffv.flex_value_set_id = ffh.flex_value_set_id(+)
1220: AND ffv.structured_hierarchy_level = ffh.hierarchy_id(+);