APPS.PA_ADW_COLLECT_FACTS dependencies on PA_OLD_RES_ACCUM_DTLS

Line 760: FROM PA_OLD_RES_ACCUM_DTLS

756: AND PTHL.TASK_HISTORY_ID > PTH.TASK_HISTORY_ID
757: )
758: AND NOT EXISTS
759: ( SELECT 'Yes'
760: FROM PA_OLD_RES_ACCUM_DTLS
761: WHERE PROJECT_ID = sel_prjs_r.project_id
762: AND TASK_ID = PTH.TASK_ID
763: AND ADW_NOTIFY_FLAG = 'Y'
764: );

Line 791: FROM PA_OLD_RES_ACCUM_DTLS

787: AND PTHL.ADW_NOTIFY_FLAG = 'S'
788: )
789: AND NOT EXISTS
790: ( SELECT 'Yes'
791: FROM PA_OLD_RES_ACCUM_DTLS
792: WHERE PROJECT_ID = sel_prjs_r.project_id
793: AND TASK_ID = PTH.TASK_ID
794: AND ADW_NOTIFY_FLAG = 'Y'
795: );

Line 815: FROM PA_OLD_RES_ACCUM_DTLS

811: AND PTHL.ADW_NOTIFY_FLAG = 'S'
812: )
813: AND NOT EXISTS
814: ( SELECT 'Yes'
815: FROM PA_OLD_RES_ACCUM_DTLS
816: WHERE PROJECT_ID = sel_prjs_r.project_id
817: AND TASK_ID = PTH.TASK_ID
818: AND ADW_NOTIFY_FLAG = 'Y'
819: );

Line 825: PA_OLD_RES_ACCUM_DTLS

821:
822: -- Mark all the resource accum rows need to be refreshed
823:
824: UPDATE
825: PA_OLD_RES_ACCUM_DTLS
826: SET
827: ADW_NOTIFY_FLAG = 'S'
828: WHERE
829: PROJECT_ID = sel_prjs_r.project_id

Line 1001: PA_OLD_RES_ACCUM_DTLS

997: -- PLEASE NOTE THAT WE ARE UPDATING THE BASE TABLE SINCE THE
998: -- PA_ADW_R_ACT_CMT_V IS DEFINED ON MULTIPLE TABLES
999:
1000: UPDATE
1001: PA_OLD_RES_ACCUM_DTLS
1002: SET
1003: ADW_NOTIFY_FLAG = 'N'
1004: WHERE
1005: ADW_NOTIFY_FLAG = 'S';