[Home] [Help]
1528: SELECT p.type,
1529: p.length,
1530: p.segment_no segment_ref,
1531: pm.segment_delimiter
1532: FROM gl_plcy_seg p,
1533: gl_plcy_mst pm,
1534: fnd_id_flex_segments f,
1535: gl_sets_of_books s
1536: WHERE p.co_code = p_co_code
6613: b.segment_name short_name,
6614: b.application_column_name,
6615: c.id_flex_structure_code structure_code,
6616: c.id_flex_structure_name structure_name
6617: FROM gl_plcy_seg a,
6618: fnd_id_flex_segments b,
6619: fnd_id_flex_structures_vl c
6620: WHERE a.co_code = p_co_code
6621: AND b.segment_num = a.segment_ref
6836: ***************************************************************************************************/
6837: BEGIN
6838: SELECT count(1)
6839: INTO l_acctg_unit_count
6840: FROM gl_plcy_seg a
6841: WHERE TYPE = 0
6842: AND a.co_code = i.co_code;
6843: EXCEPTION
6844: WHEN OTHERS THEN