DBA Data[Home] [Help]

APPS.FUN_TRX_PVT dependencies on GL_LEDGERS

Line 682: FROM gl_ledgers

678:
679: --Validate only if the ledger is set up to have specific BSVs assigned
680: SELECT bal_seg_value_option_code, bal_seg_column_name, name
681: INTO l_bsv_val, l_bal_seg_column_name, g_le_name
682: FROM gl_ledgers
683: WHERE ledger_id=p_ledger_id;
684:
685: IF l_bsv_val='I' THEN
686:

Line 4661: gl_ledgers ledgers

4657: p_ledger_id NUMBER) IS
4658: SELECT COUNT(*)
4659: FROM gl_period_statuses glps,
4660: gl_periods periods,
4661: gl_ledgers ledgers
4662: WHERE periods.period_set_name = ledgers.period_set_name
4663: AND TRUNC(p_trx_date) BETWEEN periods.start_date AND periods.end_date
4664: AND glps.period_name = periods.period_name
4665: AND glps.application_id = 222