APPS.GL_ALLOC_HISTORY_PKG dependencies on GL_ALLOC_FORMULA_LINES

Line 50: gl_alloc_formula_lines afl,

46: x_ledger_override_id NUMBER) RETURN NUMBER IS
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

Line 67: gl_alloc_formula_lines afl,

63:
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

Line 84: gl_alloc_formula_lines afl

80:
81: CURSOR null_ledger_in_t_o IS
82: SELECT 'has null ledger'
83: FROM gl_alloc_formulas af,
84: gl_alloc_formula_lines afl
85: WHERE af.allocation_batch_id = x_allocation_batch_id
86: AND af.allocation_formula_id = afl.allocation_formula_id
87: AND afl.line_number IN (4, 5)
88: AND afl.ledger_id IS NULL;

Line 114: FROM gl_alloc_formula_lines afl,

110: x_check_date DATE,
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)

Line 170: FROM gl_alloc_formula_lines afl,

166: x_period_end_date DATE,
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)