APPS.GL_ALLOC_HISTORY_PKG dependencies on GL_LEDGER_SET_ASSIGNMENTS

Line 51: gl_ledger_set_assignments lsa,

47: CURSOR random_abc_ledger IS
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)

Line 68: gl_ledger_set_assignments lsa,

64: CURSOR random_to_ledger IS
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)

Line 116: gl_ledger_set_assignments lsa

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
120: AND lsa.ledger_set_id(+) = afl.ledger_id

Line 172: gl_ledger_set_assignments lsa

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)
176: AND sysdate BETWEEN