1810: /* Cursor Variables */
1811: CURSOR flex_defs IS
1812: SELECT DYNAMIC_INSERTS_ALLOWED_FLAG,
1813: FFST.ENABLED_FLAG
1814: FROM FND_ID_FLEX_STRUCTURES_VL FFST,
1815: FND_ID_FLEX_SEGMENTS_VL FFSG,
1816: FND_FLEX_VALUE_SETS FVS
1817: WHERE FFST.APPLICATION_ID = 401
1818: AND FFST.ID_FLEX_CODE = 'MKTS'
1825: CURSOR flex_segs IS
1826: SELECT SEGMENT_NUM,
1827: SEGMENT_NAME,
1828: FFST.ENABLED_FLAG
1829: FROM FND_ID_FLEX_STRUCTURES_VL FFST,
1830: FND_ID_FLEX_SEGMENTS_VL FFSG,
1831: FND_FLEX_VALUE_SETS FVS
1832: WHERE FFST.APPLICATION_ID = 401
1833: AND FFST.ID_FLEX_CODE = 'MKTS'
1895: SELECT FREEZE_FLEX_DEFINITION_FLAG,
1896: SEGMENT_NUM,
1897: SEGMENT_NAME,
1898: FFSG.ENABLED_FLAG
1899: FROM FND_ID_FLEX_STRUCTURES_VL FFST,
1900: FND_ID_FLEX_SEGMENTS_VL FFSG,
1901: FND_FLEX_VALUE_SETS FVS
1902: WHERE FFST.APPLICATION_ID = 401
1903: AND FFST.ID_FLEX_CODE = 'MICG'