DBA Data[Home] [Help]

APPS.JA_CN_UTILITY dependencies on JA_CN_LEDGER_LE_BSV_GT

Line 1280: -- legal entity and ledger into temporary table ja_cn_ledger_le_bsv_gt

1276: --
1277: -- DESCRIPTION:
1278: --
1279: -- This procedure is used to populate the balance segment of currenct
1280: -- legal entity and ledger into temporary table ja_cn_ledger_le_bsv_gt
1281: --
1282: --
1283: -- PARAMETERS:
1284: -- In: p_legal_entity_id Legal entity ID

Line 1365: INSERT INTO Ja_Cn_Ledger_Le_Bsv_Gt

1361: --
1362: IF (l_Bsv_Option = 'I')
1363: THEN
1364: -- Insert rows for the passed ledger and its associated ALC Ledgers
1365: INSERT INTO Ja_Cn_Ledger_Le_Bsv_Gt
1366: (Ledger_Id,
1367: Ledger_Category_Code,
1368: Chart_Of_Accounts_Id,
1369: Bal_Seg_Value_Option_Code,

Line 1427: l_Insertsql(l_Line_No) := 'INSERT INTO JA_CN_LEDGER_LE_BSV_GT';

1423: AND Fvt.Flex_Value_Set_Id(+) = Fvs.Flex_Value_Set_Id;
1424:
1425: -- Build INSERT statement of the dynamic INSERT SQL
1426: l_Line_No := l_Line_No + 1;
1427: l_Insertsql(l_Line_No) := 'INSERT INTO JA_CN_LEDGER_LE_BSV_GT';
1428: l_Line_No := l_Line_No + 1;
1429: l_Insertsql(l_Line_No) := '(LEDGER_ID, LEDGER_CATEGORY_CODE, ';
1430: l_Line_No := l_Line_No + 1;
1431: l_Insertsql(l_Line_No) := ' CHART_OF_ACCOUNTS_ID, BAL_SEG_VALUE_OPTION_CODE, BAL_SEG_VALUE_SET_ID, ';