APPS.GMF_GET_MAPPINGS dependencies on FND_ID_FLEX_SEGMENTS

Line 547: fnd_id_flex_segments f,

543: f.segment_num, p.segment_no, p.length
544: FROM
545: gl_plcy_seg p,
546: gl_plcy_mst pm,
547: fnd_id_flex_segments f,
548: gl_sets_of_books s
549: WHERE
550: p.co_code = p_co_code
551: AND p.delete_mark = 0

Line 1257: FROM fnd_id_flex_segments

1253: p_app_id NUMBER, p_flex_code VARCHAR2,
1254: p_chart_of_accounts_id NUMBER, p_seg_name VARCHAR2)
1255: IS
1256: SELECT segment_num
1257: FROM fnd_id_flex_segments
1258: WHERE
1259: application_id = p_app_id
1260: AND id_flex_code = p_flex_code
1261: AND id_flex_num = p_chart_of_accounts_id

Line 1301: l_segmentname fnd_id_flex_segments.segment_name%TYPE;

1297: -- for Seg. Value descriptions
1298: l_startdate fnd_flex_values.start_date_active%TYPE;
1299: l_enddate fnd_flex_values.end_date_active%TYPE;
1300: l_sobname gl_plcy_mst.set_of_books_name%TYPE;
1301: l_segmentname fnd_id_flex_segments.segment_name%TYPE;
1302: l_segmentnum fnd_id_flex_segments.segment_num%TYPE;
1303: l_segmentval fnd_flex_values.flex_value%TYPE;
1304: l_segmentdesc fnd_flex_values_vl.description%TYPE;
1305: l_row_to_fetch NUMBER DEFAULT 1;

Line 1302: l_segmentnum fnd_id_flex_segments.segment_num%TYPE;

1298: l_startdate fnd_flex_values.start_date_active%TYPE;
1299: l_enddate fnd_flex_values.end_date_active%TYPE;
1300: l_sobname gl_plcy_mst.set_of_books_name%TYPE;
1301: l_segmentname fnd_id_flex_segments.segment_name%TYPE;
1302: l_segmentnum fnd_id_flex_segments.segment_num%TYPE;
1303: l_segmentval fnd_flex_values.flex_value%TYPE;
1304: l_segmentdesc fnd_flex_values_vl.description%TYPE;
1305: l_row_to_fetch NUMBER DEFAULT 1;
1306: l_statuscode NUMBER DEFAULT 0;