APPS.JA_CN_UTILITY dependencies on GL_LEDGERS

Line 198: l_Ledger_Id Gl_Ledgers.Ledger_Id%TYPE;

194: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;
195: l_Message VARCHAR2(300);
196:
197: l_Chart_Of_Accounts_Id Gl_Sets_Of_Books.Chart_Of_Accounts_Id%TYPE;
198: l_Ledger_Id Gl_Ledgers.Ledger_Id%TYPE;
199: BEGIN
200:
201: --log the parameters
202: IF (l_Procedure_Level >= l_Runtime_Level)

Line 1222: FROM Gl_Ledgers

1218: Bal_Seg_Value_Set_Id
1219: INTO l_Ledger_Category,
1220: l_Bsv_Option,
1221: l_Bsv_Vset_Id
1222: FROM Gl_Ledgers
1223: WHERE Ledger_Id = p_Ledger_Id;
1224:
1225: IF (l_Ledger_Category <> 'PRIMARY' AND l_Ledger_Category <> 'SECONDARY' AND
1226: l_Ledger_Category <> 'ALC')

Line 1263: FROM Gl_Ledgers Lg,

1259: Bsv.Segment_Value,
1260: Bsv.Legal_Entity_Id,
1261: Bsv.Start_Date,
1262: Bsv.End_Date
1263: FROM Gl_Ledgers Lg,
1264: Gl_Ledger_Relationships Rs,
1265: Gl_Ledger_Norm_Seg_Vals Bsv,
1266: Gl_Ledgers Lgr_c
1267: WHERE ((Rs.Relationship_Type_Code = 'NONE' AND

Line 1266: Gl_Ledgers Lgr_c

1262: Bsv.End_Date
1263: FROM Gl_Ledgers Lg,
1264: Gl_Ledger_Relationships Rs,
1265: Gl_Ledger_Norm_Seg_Vals Bsv,
1266: Gl_Ledgers Lgr_c
1267: WHERE ((Rs.Relationship_Type_Code = 'NONE' AND
1268: Rs.Target_Ledger_Id = p_Ledger_Id) OR
1269: (Rs.Target_Ledger_Category_Code = 'ALC' AND
1270: Rs.Relationship_Type_Code IN ('SUBLEDGER', 'JOURNAL') AND

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

1344: --l_Insertsql(l_Line_No) := ' DECODE(lg.LEDGER_CATEGORY_CODE, ''PRIMARY'', ''Y'', ''N'') ';
1345:
1346: -- Build FROM statement of the dynamic INSERT SQL
1347: l_Line_No := l_Line_No + 1;
1348: l_Insertsql(l_Line_No) := 'FROM GL_LEDGERS lg, ' || l_Fv_Table ||
1349: ' bsv ';
1350:
1351: -- Build WHERE statement of the dynamic INSERT SQL
1352: l_Line_No := l_Line_No + 1;