APPS.JA_CN_COA_EXP_PKG dependencies on FND_ID_FLEX_STRUCTURES

Line 465: l_delimiter_label FND_ID_FLEX_STRUCTURES.Concatenated_Segment_Delimiter%TYPE;

461: l_na_acc_str VARCHAR2(2000);
462: l_na_acc_str_2 VARCHAR2(2000);
463: --l_ent_flag JA_CN_SYSTEM_PARAMETERS_ALL.ENT_FLAG%TYPE;
464: l_ent_acc_type VARCHAR2(100);
465: l_delimiter_label FND_ID_FLEX_STRUCTURES.Concatenated_Segment_Delimiter%TYPE;
466: l_acc_segment VARCHAR2(100);
467: TYPE t_acc_level_segments IS TABLE OF NUMBER;
468: l_acc_segments t_acc_level_segments;
469: l_acc_seg_serial NUMBER;

Line 691: FROM FND_ID_FLEX_STRUCTURES FIFStr

687: --Get delimiter label
688: BEGIN
689: SELECT distinct FIFStr.Concatenated_Segment_Delimiter
690: INTO l_delimiter_label
691: FROM FND_ID_FLEX_STRUCTURES FIFStr
692: WHERE FIFStr.APPLICATION_ID=7000
693: AND FIFStr.ID_FLEX_CODE='ACCT' --JA_CN_ACCOUNT_STRUCTURES
694: /* FROM GL_SETS_OF_BOOKS SOB
695: ,FND_ID_FLEX_STRUCTURES FIFStr

Line 695: ,FND_ID_FLEX_STRUCTURES FIFStr

691: FROM FND_ID_FLEX_STRUCTURES FIFStr
692: WHERE FIFStr.APPLICATION_ID=7000
693: AND FIFStr.ID_FLEX_CODE='ACCT' --JA_CN_ACCOUNT_STRUCTURES
694: /* FROM GL_SETS_OF_BOOKS SOB
695: ,FND_ID_FLEX_STRUCTURES FIFStr
696: WHERE SOB.set_of_books_id = l_sob_id --using variable l_sob_id
697: AND FIFStr.APPLICATION_ID=7000
698: AND FIFStr.ID_FLEX_CODE='ACCT' --JA_CN_ACCOUNT_STRUCTURES
699: AND FIFStr.ID_FLEX_NUM = SOB.chart_of_accounts_id*/