APPS.JA_CN_UDR_EXPORT dependencies on FND_FLEX_VALUE_SETS

Line 183: FND_FLEX_VALUE_SETS FFVS,

179: into lv_record_name
180: FROM FND_ID_FLEX_SEGMENTS FIFS,
181: FND_SEGMENT_ATTRIBUTE_VALUES FSAV,
182: GL_LEDGERS LED,
183: FND_FLEX_VALUE_SETS FFVS,
184: JA_CN_SUB_ACC_MAPPING SAM
185: WHERE FIFS.ID_FLEX_NUM = FSAV.ID_FLEX_NUM
186: AND FIFS.APPLICATION_COLUMN_NAME =
187: FSAV.APPLICATION_COLUMN_NAME

Line 215: FROM fnd_id_flex_segments fifs, fnd_flex_value_sets ffvs

211:
212: BEGIN
213: SELECT ffvs.description
214: INTO lv_record_description
215: FROM fnd_id_flex_segments fifs, fnd_flex_value_sets ffvs
216: WHERE fifs.id_flex_num = pn_coa_id
217: AND fifs.id_flex_code = 'GL#'
218: AND fifs.application_column_name = lv_context_code
219: AND fifs.flex_value_set_id = ffvs.flex_value_set_id;