APPS.JA_CN_ITEMIZATION_INTERFACE dependencies on FND_FLEX_VALUES

Line 400: from FND_FLEX_VALUES ffv,

396: --check project number when project source is 'COA'
397: if l_PROJECT_SOURCE='COA' and l_PROJECT_NUMBER is not null then
398: select count(*)
399: into l_count
400: from FND_FLEX_VALUES ffv,
401: FND_ID_FLEX_SEGMENTS fifs
402: where ffv.flex_value_set_id=fifs.flex_value_set_id
403: and fifs.id_flex_code='GL#'
404: and fifs.id_flex_num=l_coa

Line 2432: from FND_FLEX_VALUES ffv,

2428: where SEGMENT1=l_PROJECT_NUMBER;
2429: elsif l_project_source='COA'then
2430: select flex_value_id
2431: into l_project_id
2432: from FND_FLEX_VALUES ffv,
2433: FND_ID_FLEX_SEGMENTS fifs
2434: where ffv.flex_value_set_id=fifs.flex_value_set_id
2435: and fifs.id_flex_code='GL#'
2436: and fifs.id_flex_num=l_coa