918: l_Id_Flex_Num Fnd_Id_Flex_Structures.Id_Flex_Num%TYPE;
919: l_Delimiter Fnd_Id_Flex_Structures.Concatenated_Segment_Delimiter%TYPE;
920: l_Seq_Account NUMBER;
921: l_Account_Segment_Flag Fnd_Segment_Attribute_Values.Attribute_Value%TYPE;
922: l_Account_Segment Fnd_Id_Flex_Segments.Segment_Name%TYPE;
923:
924: l_Cash_Related_Flag BOOLEAN;
925: l_Cash_Acct_Count NUMBER;
926:
936: WHERE Set_Of_Books_Id = p_Set_Of_Bks_Id);
937:
938: CURSOR c_Coa_Segments IS
939: SELECT Application_Column_Name
940: FROM Fnd_Id_Flex_Segments
941: WHERE Application_Id = 101
942: AND Id_Flex_Code = 'GL#'
943: AND Id_Flex_Num = l_Id_Flex_Num
944: AND Enabled_Flag = 'Y'
1445: SELECT NUM+1 INTO l_num
1446: FROM FND_SEGMENT_ATTRIBUTE_VALUES FSAV,
1447: (SELECT ROWNUM NUM, APPLICATION_COLUMN_NAME
1448: FROM (SELECT APPLICATION_COLUMN_NAME, SEGMENT_NUM
1449: FROM FND_ID_FLEX_SEGMENTS
1450: WHERE ID_FLEX_NUM = p_coa_id
1451: AND ID_FLEX_CODE = 'GL#'
1452: AND APPLICATION_ID = 101
1453: AND ENABLED_FLAG = 'Y'