APPS.JA_CN_GL_INTER_VALID_PKG dependencies on FND_FLEX_VALUES

Line 161: ,FND_FLEX_VALUES FFV

157: ,GL_LEDGERS ledger
158: ,FND_ID_FLEX_SEGMENTS FIFS
159: ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV
160: ,FND_FLEX_VALUE_SETS FFVS
161: ,FND_FLEX_VALUES FFV
162: WHERE gcc.code_combination_id = l_cc_id --using variable l_cc_id
163: AND ledger.chart_of_accounts_id = gcc.chart_of_accounts_id
164: AND ledger.ledger_id = l_ledger_id --using variable l_sob_id
165: AND FIFS.id_flex_num = gcc.chart_of_accounts_id

Line 404: ,flex_val FND_FLEX_VALUES.Flex_Value%TYPE

400: l_segemnt t_segemnt_type;
401:
402: TYPE t_acc_seg_type IS RECORD ( seg_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE
403: ,seg_name FND_ID_FLEX_SEGMENTS.SEGMENT_NAME%TYPE
404: ,flex_val FND_FLEX_VALUES.Flex_Value%TYPE
405: ,flex_desc FND_FLEX_VALUES_TL.Description%TYPE
406: );
407: TYPE t_acc_segt_array IS TABLE OF t_acc_seg_type;
408: l_all_acc_seg t_acc_segt_array;

Line 405: ,flex_desc FND_FLEX_VALUES_TL.Description%TYPE

401:
402: TYPE t_acc_seg_type IS RECORD ( seg_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE
403: ,seg_name FND_ID_FLEX_SEGMENTS.SEGMENT_NAME%TYPE
404: ,flex_val FND_FLEX_VALUES.Flex_Value%TYPE
405: ,flex_desc FND_FLEX_VALUES_TL.Description%TYPE
406: );
407: TYPE t_acc_segt_array IS TABLE OF t_acc_seg_type;
408: l_all_acc_seg t_acc_segt_array;
409: l_acc_seg t_acc_seg_type;

Line 460: ||' ,FND_FLEX_VALUES FFV'

456: ||' ,GL_SETS_OF_BOOKS sob'
457: ||' ,FND_ID_FLEX_SEGMENTS FIFS'
458: ||' ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV'
459: ||' ,FND_FLEX_VALUE_SETS FFVS'
460: ||' ,FND_FLEX_VALUES FFV'
461: ||' ,FND_FLEX_VALUES_TL FFVT'
462: ||' WHERE gcc.code_combination_id = :2' --using variable l_cc_id
463: ||' AND sob.chart_of_accounts_id = gcc.chart_of_accounts_id'
464: ||' AND sob.set_of_books_id = :3' --using variable l_sob_id

Line 461: ||' ,FND_FLEX_VALUES_TL FFVT'

457: ||' ,FND_ID_FLEX_SEGMENTS FIFS'
458: ||' ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV'
459: ||' ,FND_FLEX_VALUE_SETS FFVS'
460: ||' ,FND_FLEX_VALUES FFV'
461: ||' ,FND_FLEX_VALUES_TL FFVT'
462: ||' WHERE gcc.code_combination_id = :2' --using variable l_cc_id
463: ||' AND sob.chart_of_accounts_id = gcc.chart_of_accounts_id'
464: ||' AND sob.set_of_books_id = :3' --using variable l_sob_id
465: ||' AND FIFS.id_flex_num = gcc.chart_of_accounts_id'

Line 494: ,FND_FLEX_VALUES FFV

490: ,GL_LEDGERS ledger
491: ,FND_ID_FLEX_SEGMENTS FIFS
492: ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV
493: ,FND_FLEX_VALUE_SETS FFVS
494: ,FND_FLEX_VALUES FFV
495: ,FND_FLEX_VALUES_TL FFVT
496: WHERE gcc.code_combination_id = l_cc_id --using variable l_cc_id
497: AND ledger.chart_of_accounts_id = gcc.chart_of_accounts_id
498: AND ledger.ledger_id = l_ledger_id --using variable l_ledger_id

Line 495: ,FND_FLEX_VALUES_TL FFVT

491: ,FND_ID_FLEX_SEGMENTS FIFS
492: ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV
493: ,FND_FLEX_VALUE_SETS FFVS
494: ,FND_FLEX_VALUES FFV
495: ,FND_FLEX_VALUES_TL FFVT
496: WHERE gcc.code_combination_id = l_cc_id --using variable l_cc_id
497: AND ledger.chart_of_accounts_id = gcc.chart_of_accounts_id
498: AND ledger.ledger_id = l_ledger_id --using variable l_ledger_id
499: AND FIFS.id_flex_num = gcc.chart_of_accounts_id