APPS.JA_JP_TP_BAL_CTRL_RPT_PKG dependencies on GL_LEDGERS

Line 337: CURSOR c_alc_ledger_check(l_ledger_id gl_ledgers.ledger_id%TYPE) IS

333: l_temp number;
334:
335:
336:
337: CURSOR c_alc_ledger_check(l_ledger_id gl_ledgers.ledger_id%TYPE) IS
338: SELECT primary_ledger_id
339: FROM gl_ledger_relationships
340: WHERE target_ledger_id = l_ledger_id
341: AND relationship_type_code = 'SUBLEDGER'

Line 345: l_primary_ledger_id gl_ledgers.ledger_id%TYPE;

341: AND relationship_type_code = 'SUBLEDGER'
342: AND target_ledger_category_code = 'ALC'
343: AND application_id =101;
344:
345: l_primary_ledger_id gl_ledgers.ledger_id%TYPE;
346:
347:
348: BEGIN
349:

Line 394: FROM gl_ledgers

390: --
391:
392: SELECT object_type_code, USERENV('LANG')
393: INTO l_object_type, l_lang
394: FROM gl_ledgers
395: WHERE ledger_id = p_ledger_id;
396:
397:
398: IF(P_JE_SOURCE_NAME='ALL') THEN

Line 497: FROM gl_ledgers

493: --
494:
495: SELECT chart_of_accounts_id
496: INTO l_coa_id
497: FROM gl_ledgers
498: WHERE ledger_id = p_ledger_id;
499:
500: ----------------------------------------------------------------------------
501: -- get qualifier segments for the COA

Line 1040: FROM gl_ledgers gll

1036: ,gcck.segment27 SEGMENT27
1037: ,gcck.segment28 SEGMENT28
1038: ,gcck.segment29 SEGMENT29
1039: ,gcck.segment30 SEGMENT30
1040: FROM gl_ledgers gll
1041: ,xla_control_balances xcb
1042: ,gl_period_statuses gls
1043: ,gl_code_combinations_kfv gcck
1044: ,hz_parties hzp