APPS.JA_CN_POST_UTILITY_PKG dependencies on FND_SEGMENT_ATTRIBUTE_VALUES

Line 230: FROM FND_SEGMENT_ATTRIBUTE_VALUES sav

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

Line 438: FROM FND_SEGMENT_ATTRIBUTE_VALUES sav

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

Line 1009: FROM FND_SEGMENT_ATTRIBUTE_VALUES sav

1005: WHERE led.ledger_id = p_ledger_id;
1006:
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

Line 1043: FROM FND_SEGMENT_ATTRIBUTE_VALUES sav

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

Line 1917: FROM FND_SEGMENT_ATTRIBUTE_VALUES sav

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