APPS.GL_JE_BATCHES_POST_PKG dependencies on GL_BUDGET_VERSIONS

Line 50: FROM GL_BUDGET_VERSIONS BV,

46: FROM
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 );

Line 64: GL_BUDGET_VERSIONS BV,

60: dual
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