APPS.FEM_INTG_DIM_RULE_ENG_PKG dependencies on FND_FLEX_VALUE_SETS

Line 198: FND_FLEX_VALUE_SETS V,

194: pv_mapped_segs(i).where_clause,
195: pv_mapped_segs(i).dependent_value_set_flag,
196: pv_mapped_segs(i).dependent_vs_id
197: FROM FND_ID_FLEX_SEGMENTS S,
198: FND_FLEX_VALUE_SETS V,
199: FND_FLEX_VALIDATION_TABLES T
200: WHERE S.APPLICATION_ID = 101
201: AND S.ID_FLEX_CODE = 'GL#'
202: AND S.ID_FLEX_NUM = pv_coa_id

Line 1866: FROM FND_FLEX_VALUE_SETS

1862: SELECT flex_value_set_name
1863: ,description
1864: INTO v_vs_name
1865: ,v_vs_desc
1866: FROM FND_FLEX_VALUE_SETS
1867: WHERE flex_value_set_id = pv_mapped_segs(1).vs_id;
1868:
1869: IF pv_segment_count > 1
1870: THEN

Line 1877: FROM FND_FLEX_VALUE_SETS

1873: SELECT flex_value_set_name
1874: ,description
1875: INTO v_seg_name
1876: ,v_seg_desc
1877: FROM FND_FLEX_VALUE_SETS
1878: WHERE flex_value_set_id = pv_mapped_segs(i).vs_id;
1879:
1880: v_vs_name := v_vs_name || '-'||v_seg_name;
1881: v_vs_desc := v_vs_desc || '-'||v_seg_desc;

Line 1890: FROM FND_FLEX_VALUE_SETS

1886: SELECT flex_value_set_name
1887: ,description
1888: INTO v_vs_name
1889: ,v_vs_desc
1890: FROM FND_FLEX_VALUE_SETS
1891: WHERE flex_value_set_id = p_fnd_vs_id;
1892: END IF;
1893:
1894: --