APPS.JA_CN_POST_UTILITY_PKG dependencies on FND_SEGMENT_ATTRIBUTE_VALUES

Line 267: FROM FND_SEGMENT_ATTRIBUTE_VALUES sav

263: put_log('open_period parameter',p_period_name);
264:
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#'

Line 535: FROM FND_SEGMENT_ATTRIBUTE_VALUES sav

531: WHERE sob.ledger_id = p_ledger_id;
532:
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

Line 1363: FROM FND_SEGMENT_ATTRIBUTE_VALUES sav

1359: WHERE Jcc.Code_Combination_ID = l_RET_EARN_CODE_COMBINATION_ID;
1360:
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

Line 1397: FROM FND_SEGMENT_ATTRIBUTE_VALUES sav

1393: WHERE ledger_id=p_ledger_id;
1394:
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#'

Line 3032: FROM FND_SEGMENT_ATTRIBUTE_VALUES sav

3028:
3029: --get the flexfield set ID for chart of account
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#'