DBA Data[Home] [Help]

APPS.XLA_TP_SUMMARY_RPT_PKG dependencies on GL_PERIODS

Line 58: FROM gl_periods GP

54: ,MAX(CASE GP.period_name WHEN P_PERIOD_TO THEN
55: TO_DATE(TO_CHAR(GP.end_date,'DD-MON-YYYY')
56: ||' 23:59:59','DD-MM-YYYY HH24:MI:SS') END)
57: INTO P_PERIOD_START_DATE,P_PERIOD_END_DATE
58: FROM gl_periods GP
59: ,gl_ledgers GLL
60: WHERE GLL.ledger_id=P_LEDGER_ID
61: AND GP.period_set_name =GLL.period_set_name
62: AND GP.period_name IN (P_PERIOD_FROM,P_PERIOD_TO);