APPS.GL_RJE_ACCESS_PKG dependencies on GL_RECURRING_HEADERS

Line 13: FROM gl_recurring_headers

9: -- effective date
10:
11: CURSOR formulas (num NUMBER) IS
12: SELECT recurring_header_id
13: FROM gl_recurring_headers
14: WHERE recurring_batch_id = x_batch_id
15: AND rownum <= num;
16:
17: num_formula NUMBER;

Line 36: FROM gl_recurring_line_calc_rules ru, gl_recurring_headers hd

32: FOR next_formula IN formulas(num_formula) LOOP
33:
34: SELECT nvl(ru.ledger_id, hd.ledger_id)
35: INTO lgr_id
36: FROM gl_recurring_line_calc_rules ru, gl_recurring_headers hd
37: WHERE hd.recurring_header_id = next_formula.recurring_header_id
38: AND hd.recurring_header_id = ru.recurring_header_id(+)
39: AND rownum <2;
40:

Line 62: FROM gl_recurring_headers hd,

58: FUNCTION allow_average_usage(x_batch_id NUMBER) RETURN BOOLEAN IS
59:
60: CURSOR non_cons_ledgers (formula_id NUMBER) IS
61: SELECT 'non consolidation ledger exist'
62: FROM gl_recurring_headers hd,
63: gl_ledgers lgr
64: WHERE hd.recurring_header_id = formula_id
65: AND lgr.ledger_id = hd.ledger_id
66: AND lgr.consolidation_ledger_flag = 'N'

Line 71: FROM gl_recurring_headers

67: AND rownum < 2;
68:
69: CURSOR formulas (num NUMBER) IS
70: SELECT recurring_header_id
71: FROM gl_recurring_headers
72: WHERE recurring_batch_id = x_batch_id
73: AND rownum <= num;
74:
75:

Line 109: FROM gl_recurring_headers

105:
106: FUNCTION set_random_ledger_id (x_allocation_batch_id NUMBER) RETURN NUMBER IS
107: CURSOR random_ledger IS
108: SELECT ledger_id
109: FROM gl_recurring_headers
110: WHERE recurring_batch_id = x_allocation_batch_id;
111:
112: random_ledger_id NUMBER;
113: BEGIN