DBA Data[Home] [Help]

APPS.PA_ADW_COLLECT_DIMENSIONS dependencies on PA_FINANCIAL_QTRS_IT

Line 2347: PA_FINANCIAL_QTRS_IT

2343:
2344: x_timespan := x_end_date - x_start_date + 1 ;
2345:
2346: UPDATE
2347: PA_FINANCIAL_QTRS_IT
2348: SET
2349: START_DATE = x_start_date,
2350: END_DATE = x_end_date ,
2351: TIMESPAN = x_timespan,

Line 2368: Insert Into PA_FINANCIAL_QTRS_IT

2364: FINANCIAL_QUARTER = fin_qtr_r.FINANCIAL_QUARTER;
2365:
2366: IF (SQL%ROWCOUNT = 0) THEN
2367: -- No row was updated, So Insert a new row into the interface table
2368: Insert Into PA_FINANCIAL_QTRS_IT
2369: (
2370: FINANCIAL_QUARTER,
2371: START_DATE,
2372: END_DATE,