DBA Data[Home] [Help]

APPS.PA_ADW_COLLECT_DIMENSIONS dependencies on PA_FINANCIAL_YRS_IT

Line 2424: PA_FINANCIAL_YRS_IT

2420:
2421: x_timespan := x_end_date - x_start_date + 1 ;
2422:
2423: UPDATE
2424: PA_FINANCIAL_YRS_IT
2425: SET
2426: START_DATE = x_start_date,
2427: END_DATE = x_end_date ,
2428: TIMESPAN = x_timespan,

Line 2445: Insert Into PA_FINANCIAL_YRS_IT

2441: FINANCIAL_YEAR = fin_year_r.FINANCIAL_YEAR;
2442:
2443: IF (SQL%ROWCOUNT = 0) THEN
2444: -- No row was updated, So Insert a new row into the interface table
2445: Insert Into PA_FINANCIAL_YRS_IT
2446: (
2447: FINANCIAL_YEAR,
2448: START_DATE,
2449: END_DATE,