DBA Data[Home] [Help]

APPS.PA_ADW_COLLECT_DIMENSIONS dependencies on PA_PERIODS_IT

Line 2163: PA_PERIODS_IT

2159:
2160: -- First Try to Update the Row in the Interface Table
2161:
2162: UPDATE
2163: PA_PERIODS_IT
2164: SET
2165: PA_PERIOD = PERIODS_R.PA_PERIOD,
2166: START_DATE = PERIODS_R.PA_PERIOD_START_DATE,
2167: END_DATE = PERIODS_R.PA_PERIOD_END_DATE,

Line 2200: INSERT INTO PA_PERIODS_IT

2196: -- Check If Any row was updated
2197:
2198: IF (SQL%ROWCOUNT = 0) THEN
2199: -- No row was updated, So Insert a new row into the interface table
2200: INSERT INTO PA_PERIODS_IT
2201: (
2202: PA_PERIOD_KEY,
2203: PA_PERIOD,
2204: START_DATE,