DBA Data[Home] [Help]

APPS.XLA_TB_REPORT_PVT dependencies on GL_PERIODS

Line 1196: ,gl_periods gp

1192: --added bug 6684579 ,pick as_of_date period instead of sysdate period if as of date is provided
1193: SELECT gp.period_name
1194: INTO l_period_name
1195: FROM gl_ledgers gl
1196: ,gl_periods gp
1197: WHERE gl.ledger_id = p_ledger_id
1198: AND gp.period_set_name = gl.period_set_name
1199: AND gp.period_type = gl.accounted_period_type
1200: AND NVL(TRUNC(l_as_of_date),TRUNC(sysdate)) BETWEEN gp.start_date AND gp.end_date