APPS.PA_ADW_COLLECT_DIMENSIONS dependencies on PA_ADW_PERIODS_V

Line 2103: PA_ADW_PERIODS_V;

2099: USER_COL8,
2100: USER_COL9,
2101: USER_COL10
2102: FROM
2103: PA_ADW_PERIODS_V;
2104:
2105: -- Cursor for selecting GL Periods
2106:
2107: CURSOR gl_periods IS

Line 2115: PA_ADW_PERIODS_V;

2111: GL_PERIOD_END_DATE,
2112: GL_PERIOD_END_DATE - GL_PERIOD_START_DATE + 1 TIMESPAN,
2113: FINANCIAL_QUARTER
2114: FROM
2115: PA_ADW_PERIODS_V;
2116:
2117: -- Cursor for selecting Financial Quarters
2118:
2119: CURSOR fin_qtr IS

Line 2124: PA_ADW_PERIODS_V;

2120: SELECT DISTINCT
2121: FINANCIAL_QUARTER,
2122: FINANCIAL_YEAR
2123: FROM
2124: PA_ADW_PERIODS_V;
2125:
2126: -- Cursor for selecting Financial Years
2127:
2128: CURSOR fin_year IS

Line 2133: PA_ADW_PERIODS_V;

2129: SELECT DISTINCT
2130: FINANCIAL_YEAR,
2131: ALL_FINANCIAL_YEARS
2132: FROM
2133: PA_ADW_PERIODS_V;
2134:
2135: -- define procedure variables
2136:
2137: periods_r sel_periods%ROWTYPE;

Line 2340: PA_ADW_PERIODS_V

2336: INTO
2337: x_start_date,
2338: x_end_date
2339: FROM
2340: PA_ADW_PERIODS_V
2341: WHERE
2342: FINANCIAL_QUARTER = fin_qtr_r.FINANCIAL_QUARTER ;
2343:
2344: x_timespan := x_end_date - x_start_date + 1 ;

Line 2417: PA_ADW_PERIODS_V

2413: INTO
2414: x_start_date,
2415: x_end_date
2416: FROM
2417: PA_ADW_PERIODS_V
2418: WHERE
2419: FINANCIAL_YEAR = fin_year_r.FINANCIAL_YEAR ;
2420:
2421: x_timespan := x_end_date - x_start_date + 1 ;

Line 2519: PA_ADW_PERIODS_V;

2515: X_PROGRAM_ID,
2516: TRUNC(SYSDATE),
2517: 'P'
2518: FROM
2519: PA_ADW_PERIODS_V;
2520: END IF;
2521:
2522: x_err_stack := x_old_err_stack;
2523: