APPS.GL_JE_HEADERS_PKG dependencies on GL_LEDGERS

Line 147: from gl_ledgers lgr

143: (select decode(jeh.currency_code,
144: 'STAT', new_effective_date,
145: lgr.currency_code, new_effective_date,
146: jeh.currency_conversion_date)
147: from gl_ledgers lgr
148: where lgr.ledger_id = jeh.ledger_id),
149: accrual_rev_effective_date
150: = (select decode(jeh.accrual_rev_status,
151: null, ps.start_date,

Line 219: FROM gl_je_headers jeh, gl_ledgers lgr

215: CURSOR convert_headers IS
216: SELECT jeh.je_header_id, jeh.currency_code, jeh.actual_flag,
217: jeh.currency_conversion_type, jeh.je_category,
218: jeh.ledger_id, lgr.currency_code, jeh.reversed_je_header_id
219: FROM gl_je_headers jeh, gl_ledgers lgr
220: WHERE jeh.je_batch_id = batch_id
221: AND lgr.ledger_id = jeh.ledger_id
222: ORDER BY jeh.name || to_char(jeh.ledger_id)
223: FOR UPDATE OF jeh.default_effective_date, jeh.period_name,

Line 233: FROM gl_je_headers jeh, gl_ledgers lgr

229: CURSOR convert_header_range IS
230: SELECT jeh.je_header_id, jeh.currency_code, jeh.actual_flag,
231: jeh.currency_conversion_type, jeh.je_category,
232: jeh.ledger_id, lgr.currency_code, jeh.reversed_je_header_id
233: FROM gl_je_headers jeh, gl_ledgers lgr
234: WHERE jeh.je_batch_id = batch_id
235: AND lgr.ledger_id = jeh.ledger_id
236: AND jeh.name > (SELECT name || to_char(ledger_id)
237: FROM gl_je_headers

Line 333: FROM gl_je_headers jeh, gl_ledgers lgr

329: SELECT jeh.je_category, jeh.actual_flag, jeh.ledger_id,
330: lgr.currency_code, jeh.reversed_je_header_id
331: INTO cje_category, cje_actual_flag, cledger_id,
332: cfunct_curr, crev_jeh_id
333: FROM gl_je_headers jeh, gl_ledgers lgr
334: WHERE jeh.je_header_id = header_id
335: AND lgr.ledger_id = jeh.ledger_id;
336:
337: -- If the user has just changed the currency to stat, then

Line 744: gl_ledgers_pkg.select_columns(

740: error_name := '';
741:
742: -- Get the ledger information
743: BEGIN
744: gl_ledgers_pkg.select_columns(
745: ledger_id,
746: ledger_name);
747: EXCEPTION
748: WHEN NO_DATA_FOUND THEN

Line 2281: FROM gl_je_headers gh,gl_ledgers gl

2277: WHERE je_batch_id = X_Je_Batch_Id;
2278:
2279: CURSOR get_child IS
2280: SELECT gh.je_header_id,gh.je_batch_id,gl.ledger_category_code,gh.rowid,gl.ledger_id
2281: FROM gl_je_headers gh,gl_ledgers gl
2282: WHERE gh.parent_je_header_id = X_Je_Header_Id
2283: AND gh.ledger_id = gl.ledger_id
2284: AND gl.ledger_category_code in ('ALC','SECONDARY')
2285: AND gh.status = decode(gl.ledger_category_code, 'SECONDARY','U','ALC',gh.status);

Line 2465: FROM gl_je_headers gh,gl_ledgers gl

2461: 'R', accrual_rev_je_header_id,
2462: null)
2463: WHERE je_header_id =
2464: (SELECT gh.accrual_rev_je_header_id
2465: FROM gl_je_headers gh,gl_ledgers gl
2466: WHERE gh.parent_je_header_id = X_Je_Header_Id
2467: AND gh.accrual_rev_status = 'R'
2468: AND gh.ledger_id = gl.ledger_id
2469: AND gl.ledger_category_code = 'ALC');

Line 2479: FROM gl_je_headers gh,gl_ledgers gl

2475: accrual_rev_je_header_id =null,
2476: accrual_rev_flag = 'Y'
2477: WHERE je_header_id =
2478: ( SELECT gh.reversed_je_header_id
2479: FROM gl_je_headers gh,gl_ledgers gl
2480: WHERE gh.parent_je_header_id = X_Je_Header_Id
2481: AND gh.reversed_je_header_id IS NOT NULL
2482: AND gh.ledger_id = gl.ledger_id
2483: AND gl.ledger_category_code = 'ALC');

Line 2491: FROM gl_ledgers

2487: --WHERE parent_je_header_id = X_Je_Header_Id;
2488: Delete from gl_je_headers glh
2489: where parent_je_header_id =X_Je_Header_Id
2490: and ledger_id in (SELECT ledger_id
2491: FROM gl_ledgers
2492: WHERE ledger_id = glh.ledger_id
2493: AND ledger_category_code = 'ALC');
2494:
2495: