DBA Data[Home] [Help]

APPS.PA_ADW_COLLECT_FACTS dependencies on PA_PRJ_ACT_CMT_IT

Line 1712: PA_PRJ_ACT_CMT_IT

1708:
1709: -- First Try to Update the Row in the Interface Table
1710:
1711: UPDATE
1712: PA_PRJ_ACT_CMT_IT
1713: SET
1714: LAST_UPDATE_DATE = TRUNC(SYSDATE),
1715: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
1716: CREATION_DATE = TRUNC(SYSDATE),

Line 1760: INSERT INTO PA_PRJ_ACT_CMT_IT

1756: -- Check If Any row was updated
1757:
1758: IF (SQL%ROWCOUNT = 0) THEN
1759: -- No row was updated, So Insert a new row into the interface table
1760: INSERT INTO PA_PRJ_ACT_CMT_IT
1761: (
1762: PRJ_ACT_CMT_KEY,
1763: PROJECT_ID,
1764: PA_PERIOD_KEY,