APPS.JA_CN_GL_INTER_VALID_PKG dependencies on FND_FLEX_VALUES

Line 163: ,FND_FLEX_VALUES FFV

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

Line 408: ,flex_val FND_FLEX_VALUES.Flex_Value%TYPE

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

Line 409: ,flex_desc FND_FLEX_VALUES_TL.Description%TYPE

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

Line 464: ||' ,FND_FLEX_VALUES FFV'

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

Line 465: ||' ,FND_FLEX_VALUES_TL FFVT'

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

Line 498: ,FND_FLEX_VALUES FFV

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

Line 499: ,FND_FLEX_VALUES_TL FFVT

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