DBA Data[Home] [Help]

APPS.JA_CN_UTILITY dependencies on FND_ID_FLEX_SEGMENTS

Line 922: l_Account_Segment Fnd_Id_Flex_Segments.Segment_Name%TYPE;

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:

Line 940: FROM Fnd_Id_Flex_Segments

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'

Line 1449: FROM FND_ID_FLEX_SEGMENTS

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'