APPS.JA_CN_POST_UTILITY_PKG dependencies on FND_ID_FLEX_SEGMENTS

Line 269: , Fnd_Id_Flex_Segments ifs

265: SELECT ifs.flex_value_set_id
266: INTO l_flex_value_set_id
267: FROM FND_SEGMENT_ATTRIBUTE_VALUES sav
268: , gl_ledgers led
269: , Fnd_Id_Flex_Segments ifs
270: WHERE sav.SEGMENT_ATTRIBUTE_TYPE = 'GL_ACCOUNT'
271: AND sav.ID_FLEX_CODE = 'GL#'
272: AND sav.APPLICATION_ID = 101
273: AND sav.attribute_value = 'Y'

Line 537: , Fnd_Id_Flex_Segments ifs

533: SELECT COUNT(*)
534: INTO l_row_count
535: FROM FND_SEGMENT_ATTRIBUTE_VALUES sav
536: , gl_ledgers sob
537: , Fnd_Id_Flex_Segments ifs
538: WHERE sav.ID_FLEX_CODE = 'GL#'
539: AND sav.APPLICATION_ID = 101
540: AND sav.attribute_value = 'Y'
541: AND sav.ID_FLEX_NUM = sob.chart_of_accounts_id

Line 1365: , Fnd_Id_Flex_Segments ifs

1361: SELECT COUNT(*)
1362: INTO l_row_count
1363: FROM FND_SEGMENT_ATTRIBUTE_VALUES sav
1364: , gl_ledgers led
1365: , Fnd_Id_Flex_Segments ifs
1366: WHERE sav.ID_FLEX_CODE = 'GL#'
1367: AND sav.APPLICATION_ID = 101
1368: AND sav.attribute_value = 'Y'
1369: AND sav.ID_FLEX_NUM = led.chart_of_accounts_id

Line 1399: , Fnd_Id_Flex_Segments ifs

1395: SELECT ifs.flex_value_set_id
1396: INTO l_flex_value_set_id
1397: FROM FND_SEGMENT_ATTRIBUTE_VALUES sav
1398: , gl_ledgers led
1399: , Fnd_Id_Flex_Segments ifs
1400: WHERE sav.SEGMENT_ATTRIBUTE_TYPE = 'GL_ACCOUNT'
1401: AND sav.ID_FLEX_CODE = 'GL#'
1402: AND sav.APPLICATION_ID = 101
1403: AND sav.attribute_value = 'Y'

Line 3034: , Fnd_Id_Flex_Segments ifs

3030: SELECT ifs.flex_value_set_id
3031: INTO l_flex_value_set_id
3032: FROM FND_SEGMENT_ATTRIBUTE_VALUES sav
3033: , gl_ledgers led
3034: , Fnd_Id_Flex_Segments ifs
3035: WHERE sav.SEGMENT_ATTRIBUTE_TYPE = 'GL_ACCOUNT'
3036: AND sav.ID_FLEX_CODE = 'GL#'
3037: AND sav.APPLICATION_ID = 101
3038: AND sav.attribute_value = 'Y'