DBA Data[Home] [Help]

APPS.PA_ADW_COLLECT_FACTS dependencies on PA_PRJ_BGT_LINES_IT

Line 2758: PA_PRJ_BGT_LINES_IT

2754:
2755: -- First Try to Update the Row in the Interface Table
2756:
2757: UPDATE
2758: PA_PRJ_BGT_LINES_IT
2759: SET
2760: LAST_UPDATE_DATE = TRUNC(SYSDATE),
2761: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
2762: CREATION_DATE = TRUNC(SYSDATE),

Line 2800: INSERT INTO PA_PRJ_BGT_LINES_IT

2796:
2797: IF (SQL%ROWCOUNT = 0) THEN
2798:
2799: -- No row was updated, So Insert a new row into the interface table
2800: INSERT INTO PA_PRJ_BGT_LINES_IT
2801: (
2802: PRJ_BUDGET_LINE_KEY,
2803: PROJECT_ID,
2804: PA_PERIOD_KEY,