APPS.JA_CN_UTILITY dependencies on FND_SEGMENT_ATTRIBUTE_VALUES

Line 1043: l_Account_Segment_Flag Fnd_Segment_Attribute_Values.Attribute_Value%TYPE;

1039: RETURN BOOLEAN IS
1040: l_Id_Flex_Num Fnd_Id_Flex_Structures.Id_Flex_Num%TYPE;
1041: l_Delimiter Fnd_Id_Flex_Structures.Concatenated_Segment_Delimiter%TYPE;
1042: l_Seq_Account NUMBER;
1043: l_Account_Segment_Flag Fnd_Segment_Attribute_Values.Attribute_Value%TYPE;
1044: l_Account_Segment Fnd_Id_Flex_Segments.Segment_Name%TYPE;
1045:
1046: l_Cash_Related_Flag BOOLEAN;
1047: l_Cash_Acct_Count NUMBER;

Line 1104: FROM Fnd_Segment_Attribute_Values

1100: l_Seq_Account := l_Seq_Account + 1;
1101:
1102: SELECT Attribute_Value
1103: INTO l_Account_Segment_Flag
1104: FROM Fnd_Segment_Attribute_Values
1105: WHERE Application_Id = 101
1106: AND Id_Flex_Code = 'GL#'
1107: AND Id_Flex_Num = l_Id_Flex_Num
1108: AND Application_Column_Name =

Line 1568: FROM FND_SEGMENT_ATTRIBUTE_VALUES FSAV,

1564: l_total_num := FND_FLEX_EXT.BREAKUP_SEGMENTS(p_concatenated_segments,
1565: l_delimiter,
1566: l_segments);
1567: SELECT NUM+1 INTO l_num
1568: FROM FND_SEGMENT_ATTRIBUTE_VALUES FSAV,
1569: (SELECT ROWNUM NUM, APPLICATION_COLUMN_NAME
1570: FROM (SELECT APPLICATION_COLUMN_NAME, SEGMENT_NUM
1571: FROM FND_ID_FLEX_SEGMENTS
1572: WHERE ID_FLEX_NUM = p_coa_id

Line 2928: FND_SEGMENT_ATTRIBUTE_VALUES FSAV

2924: 'SEGMENT25',GCC.SEGMENT25, 'SEGMENT26',GCC.SEGMENT26, 'SEGMENT27',GCC.SEGMENT27,
2925: 'SEGMENT28',GCC.SEGMENT28, 'SEGMENT29',GCC.SEGMENT29, 'SEGMENT30',GCC.SEGMENT30)
2926: INTO L_BALANCING_SEGMENT
2927: FROM GL_CODE_COMBINATIONS GCC,
2928: FND_SEGMENT_ATTRIBUTE_VALUES FSAV
2929: WHERE GCC.CODE_COMBINATION_ID = P_CC_ID
2930: AND FSAV.ATTRIBUTE_VALUE = 'Y'
2931: AND FSAV.APPLICATION_ID = 101
2932: AND FSAV.SEGMENT_ATTRIBUTE_TYPE = 'GL_BALANCING'

Line 3023: FROM GL_CODE_COMBINATIONS GCC, FND_SEGMENT_ATTRIBUTE_VALUES FSAV

3019: GCC.SEGMENT29,
3020: 'SEGMENT30',
3021: GCC.SEGMENT30)
3022: INTO L_ACCOUNTING_SEGMENT
3023: FROM GL_CODE_COMBINATIONS GCC, FND_SEGMENT_ATTRIBUTE_VALUES FSAV
3024: WHERE GCC.CODE_COMBINATION_ID = P_CC_ID
3025: AND FSAV.ATTRIBUTE_VALUE = 'Y'
3026: AND FSAV.APPLICATION_ID = 101
3027: AND FSAV.SEGMENT_ATTRIBUTE_TYPE = 'GL_ACCOUNT'