991:
992: --Get the Chart Of Accounts name
993: SELECT id_flex_structure_name
994: INTO l_chart_of_accounts_name
995: FROM fnd_id_flex_structures_vl ffsvl
996: WHERE ffsvl.application_id = 101
997: AND ffsvl.id_flex_code = ''GL#''
998: AND ffsvl.id_flex_num = p_chart_of_accounts_id;
999:
6465:
6466: --Get the Chart Of Accounts name
6467: SELECT id_flex_structure_name
6468: INTO p_chart_of_accounts_name
6469: FROM fnd_id_flex_structures_vl ffsvl
6470: WHERE ffsvl.application_id = 101
6471: AND ffsvl.id_flex_code = 'GL#'
6472: AND ffsvl.id_flex_num = p_chart_of_accounts_id;
6473: