APPS.JA_CN_POST_UTILITY_PKG dependencies on FND_ID_FLEX_SEGMENTS

Line 232: , Fnd_Id_Flex_Segments ifs

228: SELECT ifs.flex_value_set_id
229: INTO l_flex_value_set_id
230: FROM FND_SEGMENT_ATTRIBUTE_VALUES sav
231: , gl_ledgers led
232: , Fnd_Id_Flex_Segments ifs
233: WHERE sav.SEGMENT_ATTRIBUTE_TYPE = 'GL_ACCOUNT'
234: AND sav.ID_FLEX_CODE = 'GL#'
235: AND sav.APPLICATION_ID = 101
236: AND sav.attribute_value = 'Y'

Line 440: , Fnd_Id_Flex_Segments ifs

436: SELECT COUNT(*)
437: INTO l_row_count
438: FROM FND_SEGMENT_ATTRIBUTE_VALUES sav
439: , gl_ledgers sob
440: , Fnd_Id_Flex_Segments ifs
441: WHERE sav.ID_FLEX_CODE = 'GL#'
442: AND sav.APPLICATION_ID = 101
443: AND sav.attribute_value = 'Y'
444: AND sav.ID_FLEX_NUM = sob.chart_of_accounts_id

Line 1011: , Fnd_Id_Flex_Segments ifs

1007: SELECT COUNT(*)
1008: INTO l_row_count
1009: FROM FND_SEGMENT_ATTRIBUTE_VALUES sav
1010: , gl_ledgers led
1011: , Fnd_Id_Flex_Segments ifs
1012: WHERE sav.ID_FLEX_CODE = 'GL#'
1013: AND sav.APPLICATION_ID = 101
1014: AND sav.attribute_value = 'Y'
1015: AND sav.ID_FLEX_NUM = led.chart_of_accounts_id

Line 1045: , Fnd_Id_Flex_Segments ifs

1041: SELECT ifs.flex_value_set_id
1042: INTO l_flex_value_set_id
1043: FROM FND_SEGMENT_ATTRIBUTE_VALUES sav
1044: , gl_ledgers led
1045: , Fnd_Id_Flex_Segments ifs
1046: WHERE sav.SEGMENT_ATTRIBUTE_TYPE = 'GL_ACCOUNT'
1047: AND sav.ID_FLEX_CODE = 'GL#'
1048: AND sav.APPLICATION_ID = 101
1049: AND sav.attribute_value = 'Y'

Line 1919: , Fnd_Id_Flex_Segments ifs

1915: SELECT ifs.flex_value_set_id
1916: INTO l_flex_value_set_id
1917: FROM FND_SEGMENT_ATTRIBUTE_VALUES sav
1918: , gl_ledgers led
1919: , Fnd_Id_Flex_Segments ifs
1920: WHERE sav.SEGMENT_ATTRIBUTE_TYPE = 'GL_ACCOUNT'
1921: AND sav.ID_FLEX_CODE = 'GL#'
1922: AND sav.APPLICATION_ID = 101
1923: AND sav.attribute_value = 'Y'