DBA Data[Home] [Help]

APPS.XLA_TB_REPORT_PVT dependencies on GL_PERIODS

Line 1210: ,gl_periods gp

1206: --added bug 6684579 ,pick as_of_date period instead of sysdate period if as of date is provided
1207: SELECT gp.period_name
1208: INTO l_period_name
1209: FROM gl_ledgers gl
1210: ,gl_periods gp
1211: WHERE gl.ledger_id = p_ledger_id
1212: AND gp.period_set_name = gl.period_set_name
1213: AND gp.period_type = gl.accounted_period_type
1214: AND NVL(TRUNC(l_as_of_date),TRUNC(sysdate)) BETWEEN gp.start_date AND gp.end_date