DBA Data[Home] [Help]

APPS.XLA_TB_AP_REPORT_PVT dependencies on GL_LEDGERS

Line 647: gl_ledgers gl,

643: TIV.DESCRIPTION USER_TRX_IDENTIFIER_VALUE_10
644: FROM
645: AP_SLA_INVOICES_TRANSACTION_V tiv,
646: xla_transaction_entities xte,
647: gl_ledgers gl,
648: -- inline view
649: (SELECT /*+ index(xtb XLA_TRIAL_BALANCES_N1) */ xtb.definition_code,
650: nvl(xtb.applied_to_entity_id,xtb.source_entity_id) entity_id,
651: xtb.code_combination_id ,

Line 901: FROM gl_ledgers gl

897:
898: --added bug 6684579 ,pick as_of_date period instead of sysdate period if as of date is provided
899: SELECT gp.period_name
900: INTO l_period_name
901: FROM gl_ledgers gl
902: ,gl_periods gp
903: WHERE gl.ledger_id = p_ledger_id
904: AND gp.period_set_name = gl.period_set_name
905: AND gp.period_type = gl.accounted_period_type