DBA Data[Home] [Help]

APPS.PA_ADW_COLLECT_DIMENSIONS dependencies on PA_PRJ_BUSINESS_GRPS_IT

Line 2946: PA_PRJ_BUSINESS_GRPS_IT

2942:
2943: -- First Try to Update the Row in the Interface Table
2944:
2945: UPDATE
2946: PA_PRJ_BUSINESS_GRPS_IT
2947: SET
2948: LAST_UPDATE_DATE = TRUNC(SYSDATE),
2949: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
2950: CREATION_DATE = TRUNC(SYSDATE),

Line 2963: INSERT INTO PA_PRJ_BUSINESS_GRPS_IT

2959: BUSINESS_GROUP = project_bsns_grp_r.BUSINESS_GROUP;
2960:
2961: IF (SQL%ROWCOUNT = 0) THEN
2962: -- No row was updated, So Insert a new row into the interface table
2963: INSERT INTO PA_PRJ_BUSINESS_GRPS_IT
2964: (
2965: business_group,
2966: last_update_date,
2967: last_updated_by,