115:
116: SELECT fifsv.FLEX_VALUE_SET_ID
117: into l_flex_valueset_id
118: FROM FND_ID_FLEX_SEGMENTS_VL fifsv,
119: FND_SEGMENT_ATTRIBUTE_VALUES FSAV
120: WHERE FSAV.ATTRIBUTE_VALUE = 'Y'
121: AND FSAV.APPLICATION_ID = 101
122: AND FSAV.ID_FLEX_CODE = 'GL#'
123: AND FSAV.APPLICATION_ID = fifsv.APPLICATION_ID
285: BEGIN
286:
287: SELECT fifsv.FLEX_VALUE_SET_ID
288: into l_flex_valueset_id
289: FROM FND_ID_FLEX_SEGMENTS_VL fifsv, FND_SEGMENT_ATTRIBUTE_VALUES FSAV
290: WHERE FSAV.ATTRIBUTE_VALUE = 'Y'
291: AND FSAV.APPLICATION_ID = 101
292: AND FSAV.ID_FLEX_CODE = 'GL#'
293: AND FSAV.APPLICATION_ID = fifsv.APPLICATION_ID
374: --get valueset_id
375: SELECT fifsv.FLEX_VALUE_SET_ID
376: into l_flex_valueset_id
377: FROM FND_ID_FLEX_SEGMENTS_VL fifsv,
378: FND_SEGMENT_ATTRIBUTE_VALUES FSAV
379: WHERE FSAV.ATTRIBUTE_VALUE = 'Y'
380: AND FSAV.APPLICATION_ID = 101
381: AND FSAV.ID_FLEX_CODE = 'GL#'
382: AND FSAV.APPLICATION_ID = fifsv.APPLICATION_ID
502: --get valueset_id
503: SELECT fifsv.FLEX_VALUE_SET_ID
504: into l_flex_valueset_id
505: FROM FND_ID_FLEX_SEGMENTS_VL fifsv,
506: FND_SEGMENT_ATTRIBUTE_VALUES FSAV
507: WHERE FSAV.ATTRIBUTE_VALUE = 'Y'
508: AND FSAV.APPLICATION_ID = 101
509: AND FSAV.ID_FLEX_CODE = 'GL#'
510: AND FSAV.APPLICATION_ID = fifsv.APPLICATION_ID
628: IF l_das_bsv=0 THEN
629: SELECT fifsv.FLEX_VALUE_SET_ID
630: into l_flex_valueset_id
631: FROM FND_ID_FLEX_SEGMENTS_VL fifsv,
632: FND_SEGMENT_ATTRIBUTE_VALUES FSAV
633: WHERE FSAV.ATTRIBUTE_VALUE = 'Y'
634: AND FSAV.APPLICATION_ID = 101
635: AND FSAV.ID_FLEX_CODE = 'GL#'
636: AND FSAV.APPLICATION_ID = fifsv.APPLICATION_ID