DBA Data[Home] [Help]

APPS.PA_FORECAST_GRC_PVT dependencies on PA_REP_PERIODS_V

Line 331: FROM pa_rep_periods_v

327: period_year AS PERIOD_YEAR
328: ,mon_or_qtr AS PERIOD_MONTH
329: ,ge_week_dt AS GE_DATE
330: ,period_start_date AS PERIOD_START_DATE
331: FROM pa_rep_periods_v
332: WHERE period_type = 'GE'
333: AND p_run_start_date <= ge_week_dt
334: AND p_run_end_date >= period_start_date
335: AND to_number(to_char(ge_week_dt,'YYYY')) = period_year