APPS.GL_JE_BATCHES_POST_PKG dependencies on GL_JE_HEADERS

Line 51: GL_JE_HEADERS JH

47: dual
48: WHERE EXISTS
49: ( SELECT 'Frozen budget'
50: FROM GL_BUDGET_VERSIONS BV,
51: GL_JE_HEADERS JH
52: WHERE BV.status in ('I', 'F')
53: AND BV.budget_version_id = JH.budget_version_id
54: AND JH.je_batch_id = X_je_batch_id );
55:

Line 65: GL_JE_HEADERS JH

61: WHERE EXISTS
62: ( SELECT 'Unopened budget year'
63: FROM GL_BUDGETS GB,
64: GL_BUDGET_VERSIONS BV,
65: GL_JE_HEADERS JH
66: WHERE GB.budget_name = BV.budget_name
67: AND GB.budget_type = BV.budget_type
68: AND ( GB.latest_opened_year IS NULL
69: OR GB.latest_opened_year < X_period_year )

Line 101: FROM GL_JE_HEADERS

97: SELECT 'Out of Balance'
98: FROM SYS.DUAL
99: WHERE EXISTS
100: ( SELECT 'x'
101: FROM GL_JE_HEADERS
102: WHERE je_batch_id = X_je_batch_id
103: AND nvl(display_alc_journal_flag, 'Y') = 'Y'
104: AND currency_code <> 'STAT'
105: AND nvl(running_total_dr, 0) <> nvl(running_total_cr, 0));

Line 127: FROM GL_JE_HEADERS

123: SELECT 'Untaxed'
124: FROM SYS.DUAL
125: WHERE EXISTS
126: ( SELECT 'x'
127: FROM GL_JE_HEADERS
128: WHERE je_batch_id = X_je_batch_id
129: AND nvl(display_alc_journal_flag, 'Y') = 'Y'
130: AND currency_code <> 'STAT'
131: AND tax_status_code = 'R');