APPS.GL_ALLOC_HISTORY_PKG dependencies on GL_ALLOC_FORMULAS

Line 49: FROM gl_alloc_formulas af,

45: x_line_selection VARCHAR2,
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

Line 66: FROM gl_alloc_formulas af,

62: AND ldg.object_type_code = 'L';
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

Line 83: FROM gl_alloc_formulas af,

79: AND ldg.object_type_code = 'L';
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)

Line 129: FROM gl_alloc_formulas

125: AND ldg.object_type_code = 'L';
126:
127: CURSOR formulas (num NUMBER) IS
128: SELECT allocation_formula_id
129: FROM gl_alloc_formulas
130: WHERE allocation_batch_id = x_allocation_batch_id
131: AND rownum <= num;
132:
133: num_formula NUMBER;

Line 188: FROM gl_alloc_formulas

184: AND rownum < 2;
185:
186: CURSOR formulas (num NUMBER) IS
187: SELECT allocation_formula_id
188: FROM gl_alloc_formulas
189: WHERE allocation_batch_id = x_allocation_batch_id
190: AND rownum <= num;
191:
192: num_formula NUMBER;