APPS.GL_ALLOC_HISTORY_PKG dependencies on GL_LEDGERS

Line 52: gl_ledgers ldg

48: SELECT ldg.ledger_id
49: FROM gl_alloc_formulas af,
50: gl_alloc_formula_lines afl,
51: gl_ledger_set_assignments lsa,
52: gl_ledgers ldg
53: WHERE af.allocation_batch_id = x_allocation_batch_id
54: AND afl.allocation_formula_id = af.allocation_formula_id
55: AND afl.line_number IN (1, 2, 3)
56: AND lsa.ledger_set_id (+) = nvl(afl.ledger_id, x_ledger_override_id)

Line 69: gl_ledgers ldg

65: SELECT ldg.ledger_id
66: FROM gl_alloc_formulas af,
67: gl_alloc_formula_lines afl,
68: gl_ledger_set_assignments lsa,
69: gl_ledgers ldg
70: WHERE af.allocation_batch_id = x_allocation_batch_id
71: AND afl.allocation_formula_id = af.allocation_formula_id
72: AND afl.line_number IN (4, 5)
73: AND lsa.ledger_set_id (+) = nvl(afl.ledger_id, x_ledger_override_id)

Line 115: gl_ledgers ldg,

111: x_selected_ced DATE) RETURN BOOLEAN IS
112: CURSOR ledger_ids (formula_id NUMBER) IS
113: SELECT ldg.ledger_id
114: FROM gl_alloc_formula_lines afl,
115: gl_ledgers ldg,
116: gl_ledger_set_assignments lsa
117: WHERE afl.allocation_formula_id = formula_id
118: AND afl.line_number IN (1, 2, 3)
119: AND afl.ledger_id IS NOT NULL

Line 171: gl_ledgers ldg,

167: x_ledger_override_id NUMBER) RETURN BOOLEAN IS
168: CURSOR non_cons_ledgers (formula_id NUMBER) IS
169: SELECT 'non consolidation ledger exist'
170: FROM gl_alloc_formula_lines afl,
171: gl_ledgers ldg,
172: gl_ledger_set_assignments lsa
173: WHERE afl.allocation_formula_id = formula_id
174: AND afl.line_number IN (4,5)
175: AND lsa.ledger_set_id(+) = nvl(afl.ledger_id, x_ledger_override_id)