DBA Data[Home] [Help]

APPS.JA_CN_UTILITY dependencies on FND_SEGMENT_ATTRIBUTE_VALUES

Line 921: l_Account_Segment_Flag Fnd_Segment_Attribute_Values.Attribute_Value%TYPE;

917: RETURN BOOLEAN IS
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;

Line 982: FROM Fnd_Segment_Attribute_Values

978: l_Seq_Account := l_Seq_Account + 1;
979:
980: SELECT Attribute_Value
981: INTO l_Account_Segment_Flag
982: FROM Fnd_Segment_Attribute_Values
983: WHERE Application_Id = 101
984: AND Id_Flex_Code = 'GL#'
985: AND Id_Flex_Num = l_Id_Flex_Num
986: AND Application_Column_Name =

Line 1446: FROM FND_SEGMENT_ATTRIBUTE_VALUES FSAV,

1442: l_total_num := FND_FLEX_EXT.BREAKUP_SEGMENTS(p_concatenated_segments,
1443: l_delimiter,
1444: l_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