APPS.PAY_COST_ALLOCATION_SWI dependencies on FND_ID_FLEX_SEGMENTS

Line 37: from fnd_id_flex_segments_vl

33: where pbg.business_group_id = p_business_group_id;
34:
35: cursor get_seg_order (p_cost_flex_structure number)is
36: select substr(application_column_name,8,2)
37: from fnd_id_flex_segments_vl
38: where id_flex_code = 'COST'
39: and id_flex_num = p_cost_flex_structure
40: and application_id = 801
41: and enabled_flag = 'Y'

Line 53: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

49: segment segment_table;
50:
51: l_delimiter varchar2(1);
52: l_concat_string varchar2(2000);
53: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
54: l_concatenated_segments varchar2(2000);
55: l_disp_no number;
56: l_first_seg boolean;
57: