APPS.JA_CN_UTILITY dependencies on GL_LEDGERS

Line 208: l_Ledger_Id Gl_Ledgers.Ledger_Id%TYPE;

204: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;
205: l_Message VARCHAR2(300);
206:
207: l_Chart_Of_Accounts_Id Gl_Sets_Of_Books.Chart_Of_Accounts_Id%TYPE;
208: l_Ledger_Id Gl_Ledgers.Ledger_Id%TYPE;
209: BEGIN
210:
211: --log the parameters
212: IF (l_Procedure_Level >= l_Runtime_Level)

Line 1344: FROM Gl_Ledgers

1340: Bal_Seg_Value_Set_Id
1341: INTO l_Ledger_Category,
1342: l_Bsv_Option,
1343: l_Bsv_Vset_Id
1344: FROM Gl_Ledgers
1345: WHERE Ledger_Id = p_Ledger_Id;
1346:
1347: IF (l_Ledger_Category <> 'PRIMARY' AND l_Ledger_Category <> 'SECONDARY' AND
1348: l_Ledger_Category <> 'ALC')

Line 1385: FROM Gl_Ledgers Lg,

1381: Bsv.Segment_Value,
1382: Bsv.Legal_Entity_Id,
1383: Bsv.Start_Date,
1384: Bsv.End_Date
1385: FROM Gl_Ledgers Lg,
1386: Gl_Ledger_Relationships Rs,
1387: Gl_Ledger_Norm_Seg_Vals Bsv,
1388: Gl_Ledgers Lgr_c
1389: WHERE ((Rs.Relationship_Type_Code = 'NONE' AND

Line 1388: Gl_Ledgers Lgr_c

1384: Bsv.End_Date
1385: FROM Gl_Ledgers Lg,
1386: Gl_Ledger_Relationships Rs,
1387: Gl_Ledger_Norm_Seg_Vals Bsv,
1388: Gl_Ledgers Lgr_c
1389: WHERE ((Rs.Relationship_Type_Code = 'NONE' AND
1390: Rs.Target_Ledger_Id = p_Ledger_Id) OR
1391: (Rs.Target_Ledger_Category_Code = 'ALC' AND
1392: Rs.Relationship_Type_Code IN ('SUBLEDGER', 'JOURNAL') AND

Line 1470: l_Insertsql(l_Line_No) := 'FROM GL_LEDGERS lg, ' || l_Fv_Table ||

1466: --l_Insertsql(l_Line_No) := ' DECODE(lg.LEDGER_CATEGORY_CODE, ''PRIMARY'', ''Y'', ''N'') ';
1467:
1468: -- Build FROM statement of the dynamic INSERT SQL
1469: l_Line_No := l_Line_No + 1;
1470: l_Insertsql(l_Line_No) := 'FROM GL_LEDGERS lg, ' || l_Fv_Table ||
1471: ' bsv ';
1472:
1473: -- Build WHERE statement of the dynamic INSERT SQL
1474: l_Line_No := l_Line_No + 1;