DBA Data[Home] [Help]

APPS.XTR_CSH_FCST_POP dependencies on GL_PERIOD_TYPES

Line 63: gl_period_types gpt

59: SELECT gps.period_name
60: INTO history_period
61: FROM gl_periods gps,
62: gl_periods gp,
63: gl_period_types gpt
64: WHERE gps.period_num =DECODE(LEAST(gp.period_num-XTR_CASH_FCST.G_roll_forward_period,1),
65: 1,gp.period_num - XTR_CASH_FCST.G_roll_forward_period,
66: gpt.number_per_fiscal_year +
67: mod(gp.period_num-XTR_CASH_FCST.G_roll_forward_period,gpt.number_per_fiscal_year))