APPS.IPA_CLIENT_EXTENSION_PKG dependencies on FND_ID_FLEX_SEGMENTS

Line 18: FROM fnd_id_flex_segments s,

14: IS
15: BEGIN
16:
17: SELECT s.segment_name INTO name
18: FROM fnd_id_flex_segments s,
19: fnd_segment_attribute_values sav,
20: fnd_segment_attribute_types sat
21: WHERE s.application_id = appl_id
22: AND s.id_flex_code = code

Line 70: FROM fnd_id_flex_segments

66: /*
67: * Get the user specified segment number
68: */
69: SELECT segment_num into seg_num
70: FROM fnd_id_flex_segments
71: WHERE application_id = appl_id
72: AND id_flex_code = code
73: AND id_flex_num = num
74: AND segment_name = segment

Line 82: FROM fnd_id_flex_segments

78: * The above value gives the relative order of the
79: * segments. Convert it into the segment number.
80: */
81: SELECT count(segment_num) INTO sequence
82: FROM fnd_id_flex_segments
83: WHERE application_id = appl_id
84: AND id_flex_code = code
85: AND id_flex_num = num
86: AND enabled_flag = 'Y'