DBA Data[Home] [Help]

APPS.FND_FLEX_APIS dependencies on FND_SEGMENT_ATTRIBUTE_VALUES

Line 21: FROM fnd_id_flex_segments s, fnd_segment_attribute_values sav,

17: IS
18: this_segment_num NUMBER;
19: BEGIN
20: SELECT s.segment_num INTO this_segment_num
21: FROM fnd_id_flex_segments s, fnd_segment_attribute_values sav,
22: fnd_segment_attribute_types sat
23: WHERE s.application_id = appl_id
24: AND s.id_flex_code = key_flex_code
25: AND s.id_flex_num = structure_number

Line 65: FROM fnd_segment_attribute_values

61: IS
62: BEGIN
63: SELECT application_column_name
64: INTO x_app_column_name
65: FROM fnd_segment_attribute_values
66: WHERE application_id = x_application_id
67: AND id_flex_code = x_id_flex_code
68: AND id_flex_num = x_id_flex_num
69: AND segment_attribute_type = x_seg_attr_type