APPS.PA_ADW_COLLECT_FACTS dependencies on PA_RESOURCE_ACCUM_DETAILS

Line 1200: PA_RESOURCE_ACCUM_DETAILS PRAD

1196:
1197: -- First mark all the rows need to be transferred
1198:
1199: UPDATE
1200: PA_RESOURCE_ACCUM_DETAILS PRAD
1201: SET
1202: PRAD.ADW_NOTIFY_FLAG = 'S'
1203: WHERE
1204: PRAD.PROJECT_ID = SEL_PRJS_R.PROJECT_ID

Line 1392: FROM PA_RESOURCE_ACCUM_DETAILS

1388: WHERE
1389: ADW_NOTIFY_FLAG = 'Y'
1390: AND PTH.TASK_ID IN
1391: (SELECT TASK_ID
1392: FROM PA_RESOURCE_ACCUM_DETAILS
1393: WHERE ADW_NOTIFY_FLAG = 'S'
1394: UNION
1395: SELECT TASK_ID
1396: FROM PA_TXN_ACCUM

Line 1413: FROM PA_RESOURCE_ACCUM_DETAILS

1409: WHERE
1410: PTHT.ADW_NOTIFY_FLAG = 'Y'
1411: AND PTHT.TASK_ID IN
1412: (SELECT TASK_ID
1413: FROM PA_RESOURCE_ACCUM_DETAILS
1414: WHERE ADW_NOTIFY_FLAG = 'S'
1415: UNION
1416: SELECT TASK_ID
1417: FROM PA_TXN_ACCUM

Line 1427: PA_RESOURCE_ACCUM_DETAILS

1423: -- PLEASE NOTE THAT WE ARE UPDATING THE BASE TABLE SINCE THE
1424: -- PA_ADW_R_ACT_CMT_V IS DEFINED ON MULTIPLE TABLES
1425:
1426: UPDATE
1427: PA_RESOURCE_ACCUM_DETAILS
1428: SET
1429: ADW_NOTIFY_FLAG = 'N'
1430: WHERE
1431: ADW_NOTIFY_FLAG = 'S';