DBA Data[Home] [Help]

APPS.PAY_BTL_BUS dependencies on FND_ID_FLEX_SEGMENTS

Line 254: of fnd_id_flex_segments.application_column_name%type INDEX BY Binary_integer;

250:
251: type segment_no_array is table
252: of number(2) INDEX BY Binary_integer;
253: type application_column_array is table
254: of fnd_id_flex_segments.application_column_name%type INDEX BY Binary_integer;
255: type application_segment_array is table
256: of fnd_id_flex_segments.segment_name%type INDEX BY Binary_integer;
257: type required_flag_array is table
258: of fnd_id_flex_segments.required_flag%type INDEX BY Binary_integer;

Line 256: of fnd_id_flex_segments.segment_name%type INDEX BY Binary_integer;

252: of number(2) INDEX BY Binary_integer;
253: type application_column_array is table
254: of fnd_id_flex_segments.application_column_name%type INDEX BY Binary_integer;
255: type application_segment_array is table
256: of fnd_id_flex_segments.segment_name%type INDEX BY Binary_integer;
257: type required_flag_array is table
258: of fnd_id_flex_segments.required_flag%type INDEX BY Binary_integer;
259:
260: l_segment_no segment_no_array;

Line 258: of fnd_id_flex_segments.required_flag%type INDEX BY Binary_integer;

254: of fnd_id_flex_segments.application_column_name%type INDEX BY Binary_integer;
255: type application_segment_array is table
256: of fnd_id_flex_segments.segment_name%type INDEX BY Binary_integer;
257: type required_flag_array is table
258: of fnd_id_flex_segments.required_flag%type INDEX BY Binary_integer;
259:
260: l_segment_no segment_no_array;
261: l_application_column application_column_array;
262: l_application_segment application_segment_array;

Line 271: FROM FND_ID_FLEX_SEGMENTS fs,

267: SELECT substr(fs.application_column_name,8,2) segment_no,
268: fs.application_column_name application_column_name,
269: fs.segment_name application_segment_name,
270: fs.required_flag required_flag
271: FROM FND_ID_FLEX_SEGMENTS fs,
272: FND_SEGMENT_ATTRIBUTE_VALUES sa1
273: WHERE sa1.id_flex_num = p_cost_id_flex_num
274: and sa1.id_flex_code = 'COST'
275: and sa1.attribute_value = 'Y'