DBA Data[Home] [Help]

APPS.PA_ADW_COLLECT_FACTS dependencies on PA_TSK_ACT_CMT_IT

Line 1507: PA_TSK_ACT_CMT_IT

1503:
1504: -- First Try to Update the Row in the Interface Table
1505:
1506: UPDATE
1507: PA_TSK_ACT_CMT_IT
1508: SET
1509: LAST_UPDATE_DATE = TRUNC(SYSDATE),
1510: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
1511: CREATION_DATE = TRUNC(SYSDATE),

Line 1556: INSERT INTO PA_TSK_ACT_CMT_IT

1552:
1553: IF (SQL%ROWCOUNT = 0) THEN
1554:
1555: -- No row was updated, So Insert a new row into the interface table
1556: INSERT INTO PA_TSK_ACT_CMT_IT
1557: (
1558: TASK_ACT_CMT_KEY,
1559: TASK_ID,
1560: PA_PERIOD_KEY,