DBA Data[Home] [Help]

APPS.FARX_TAX_PKG dependencies on FND_ID_FLEX_SEGMENTS

Line 230: FROM fnd_id_flex_segments s,

226:
227:
228: SELECT s.segment_num
229: INTO h_segment_num
230: FROM fnd_id_flex_segments s,
231: fnd_segment_attribute_values sav,
232: fnd_segment_attribute_types sat
233: WHERE s.application_id = 140
234: AND s.id_flex_code = 'LOC#'

Line 250: FROM fnd_id_flex_segments

246: AND sat.segment_attribute_type = 'LOC_STATE';
247:
248: SELECT count(segment_num)
249: INTO h_state_seg
250: FROM fnd_id_flex_segments
251: WHERE application_id = 140
252: AND id_flex_code = 'LOC#'
253: AND id_flex_num = 101
254: AND enabled_flag = 'Y'