APPS.GL_WEB_PLSQL_CARTRIDGE dependencies on GL_CONSOLIDATION

Line 70: gl_consolidation_sets cs1,

66: FROM
67: gl_ledgers to_ledger,
68: gl_ledgers from_ledger,
69: gl_cons_set_assignments csa,
70: gl_consolidation_sets cs1,
71: gl_consolidation_sets cs2,
72: gl_consolidation c
73: WHERE cs1.consolidation_set_id = csa.consolidation_set_id
74: AND csa.consolidation_id = c.consolidation_id

Line 71: gl_consolidation_sets cs2,

67: gl_ledgers to_ledger,
68: gl_ledgers from_ledger,
69: gl_cons_set_assignments csa,
70: gl_consolidation_sets cs1,
71: gl_consolidation_sets cs2,
72: gl_consolidation c
73: WHERE cs1.consolidation_set_id = csa.consolidation_set_id
74: AND csa.consolidation_id = c.consolidation_id
75: AND c.from_ledger_id = from_ledger.ledger_id

Line 72: gl_consolidation c

68: gl_ledgers from_ledger,
69: gl_cons_set_assignments csa,
70: gl_consolidation_sets cs1,
71: gl_consolidation_sets cs2,
72: gl_consolidation c
73: WHERE cs1.consolidation_set_id = csa.consolidation_set_id
74: AND csa.consolidation_id = c.consolidation_id
75: AND c.from_ledger_id = from_ledger.ledger_id
76: AND c.to_ledger_id = to_ledger.ledger_id

Line 98: gl_consolidation c,

94: cs2.consolidation_set_id, cs2.name, c.name
95: FROM
96: gl_ledgers to_ledger,
97: gl_ledgers from_ledger,
98: gl_consolidation c,
99: gl_cons_set_assignments csa,
100: gl_consolidation_sets cs1,
101: gl_consolidation_sets cs2
102: WHERE cs1.consolidation_set_id = csa.consolidation_set_id

Line 100: gl_consolidation_sets cs1,

96: gl_ledgers to_ledger,
97: gl_ledgers from_ledger,
98: gl_consolidation c,
99: gl_cons_set_assignments csa,
100: gl_consolidation_sets cs1,
101: gl_consolidation_sets cs2
102: WHERE cs1.consolidation_set_id = csa.consolidation_set_id
103: AND csa.consolidation_id = c.consolidation_id
104: AND c.from_ledger_id = from_ledger.ledger_id

Line 101: gl_consolidation_sets cs2

97: gl_ledgers from_ledger,
98: gl_consolidation c,
99: gl_cons_set_assignments csa,
100: gl_consolidation_sets cs1,
101: gl_consolidation_sets cs2
102: WHERE cs1.consolidation_set_id = csa.consolidation_set_id
103: AND csa.consolidation_id = c.consolidation_id
104: AND c.from_ledger_id = from_ledger.ledger_id
105: AND c.to_ledger_id = to_ledger.ledger_id

Line 133: FROM GL_CONSOLIDATION_SETS

129: ELSE
130:
131: SELECT name
132: INTO mapping_set_name
133: FROM GL_CONSOLIDATION_SETS
134: WHERE consolidation_set_id = X_Consolidation_Set_Id;
135:
136:
137: IF (X_Mode = 'R') THEN

Line 325: 'gl_consolidation c, ' ||

321: 'from_ledger.chart_of_accounts_id, ' ||
322: 'cs2.consolidation_set_id, cs2.name ' ||
323: 'FROM gl_ledgers to_ledger, ' ||
324: 'gl_ledgers from_ledger, ' ||
325: 'gl_consolidation c, ' ||
326: 'gl_cons_set_assignments csa, ' ||
327: 'gl_consolidation_sets cs1, ' ||
328: 'gl_consolidation_sets cs2 ' ||
329: 'WHERE cs1.consolidation_set_id = ' ||

Line 327: 'gl_consolidation_sets cs1, ' ||

323: 'FROM gl_ledgers to_ledger, ' ||
324: 'gl_ledgers from_ledger, ' ||
325: 'gl_consolidation c, ' ||
326: 'gl_cons_set_assignments csa, ' ||
327: 'gl_consolidation_sets cs1, ' ||
328: 'gl_consolidation_sets cs2 ' ||
329: 'WHERE cs1.consolidation_set_id = ' ||
330: 'csa.consolidation_set_id ' ||
331: 'AND csa.consolidation_id = ' ||

Line 328: 'gl_consolidation_sets cs2 ' ||

324: 'gl_ledgers from_ledger, ' ||
325: 'gl_consolidation c, ' ||
326: 'gl_cons_set_assignments csa, ' ||
327: 'gl_consolidation_sets cs1, ' ||
328: 'gl_consolidation_sets cs2 ' ||
329: 'WHERE cs1.consolidation_set_id = ' ||
330: 'csa.consolidation_set_id ' ||
331: 'AND csa.consolidation_id = ' ||
332: 'c.consolidation_id ' ||

Line 354: 'gl_consolidation c, ' ||

350: 'from_ledger.chart_of_accounts_id, ' ||
351: 'cs2.consolidation_set_id, cs2.name, c.name ' ||
352: 'FROM gl_ledgers to_ledger, ' ||
353: 'gl_ledgers from_ledger, ' ||
354: 'gl_consolidation c, ' ||
355: 'gl_cons_set_assignments csa, ' ||
356: 'gl_consolidation_sets cs1, ' ||
357: 'gl_consolidation_sets cs2 ' ||
358: 'WHERE cs1.consolidation_set_id = ' ||

Line 356: 'gl_consolidation_sets cs1, ' ||

352: 'FROM gl_ledgers to_ledger, ' ||
353: 'gl_ledgers from_ledger, ' ||
354: 'gl_consolidation c, ' ||
355: 'gl_cons_set_assignments csa, ' ||
356: 'gl_consolidation_sets cs1, ' ||
357: 'gl_consolidation_sets cs2 ' ||
358: 'WHERE cs1.consolidation_set_id = ' ||
359: 'csa.consolidation_set_id ' ||
360: 'AND csa.consolidation_id = ' ||

Line 357: 'gl_consolidation_sets cs2 ' ||

353: 'gl_ledgers from_ledger, ' ||
354: 'gl_consolidation c, ' ||
355: 'gl_cons_set_assignments csa, ' ||
356: 'gl_consolidation_sets cs1, ' ||
357: 'gl_consolidation_sets cs2 ' ||
358: 'WHERE cs1.consolidation_set_id = ' ||
359: 'csa.consolidation_set_id ' ||
360: 'AND csa.consolidation_id = ' ||
361: 'c.consolidation_id ' ||