DBA Data[Home] [Help]

APPS.XTR_CSH_FCST_POP dependencies on GL_PERIODS

Line 61: FROM gl_periods gps,

57: ELSIF (XTR_CASH_FCST.G_roll_forward_type = 'A') THEN
58: BEGIN
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,

Line 62: gl_periods gp,

58: BEGIN
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 +