PLAN_TABLE_OUTPUT Plan hash value: 2454355945 ----------------------------------------------------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | ----------------------------------------------------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 4 | 999 | 34070 (2)| 00:06:49 | | 1 | SORT ORDER BY | | 4 | 999 | 34069 (100)| 00:06:49 | | 2 | UNION-ALL | | | | | | | 3 | FAST DUAL | | 1 | | 2 (0)| 00:00:01 | | 4 | FAST DUAL | | 1 | | 2 (0)| 00:00:01 | | 5 | FAST DUAL | | 1 | | 2 (0)| 00:00:01 | | 6 | SORT UNIQUE | | 1 | 999 | 34063 (2)| 00:06:49 | |* 7 | TABLE ACCESS BY INDEX ROWID | PA_PROJECT_PARTIES | 1 | 19 | 2 (0)| 00:00:01 | | 8 | NESTED LOOPS | | 1 | 999 | 34062 (2)| 00:06:49 | | 9 | NESTED LOOPS | | 1 | 980 | 34060 (2)| 00:06:49 | | 10 | NESTED LOOPS | | 1 | 878 | 34058 (2)| 00:06:49 | |* 11 | HASH JOIN | | 1 | 854 | 34056 (2)| 00:06:49 | | 12 | NESTED LOOPS | | 1 | 823 | 34047 (2)| 00:06:49 | | 13 | NESTED LOOPS | | 1 | 795 | 34045 (2)| 00:06:49 | | 14 | NESTED LOOPS | | 1 | 775 | 34044 (2)| 00:06:49 | | 15 | NESTED LOOPS | | 1 | 755 | 34043 (2)| 00:06:49 | | 16 | NESTED LOOPS | | 1 | 735 | 34042 (2)| 00:06:49 | | 17 | NESTED LOOPS | | 1 | 715 | 34041 (2)| 00:06:49 | | 18 | NESTED LOOPS | | 1 | 695 | 34040 (2)| 00:06:49 | | 19 | NESTED LOOPS | | 1 | 675 | 34039 (2)| 00:06:49 | | 20 | NESTED LOOPS | | 1 | 655 | 34038 (2)| 00:06:49 | | 21 | NESTED LOOPS | | 1 | 635 | 34037 (2)| 00:06:49 | | 22 | NESTED LOOPS | | 1 | 616 | 34036 (2)| 00:06:49 | | 23 | NESTED LOOPS | | 1 | 595 | 34035 (2)| 00:06:49 | | 24 | NESTED LOOPS | | 1 | 586 | 34034 (2)| 00:06:49 | | 25 | NESTED LOOPS OUTER | | 1 | 558 | 34033 (2)| 00:06:49 | | 26 | NESTED LOOPS | | 1 | 456 | 34031 (2)| 00:06:49 | |* 27 | HASH JOIN OUTER | | 1 | 398 | 34030 (2)| 00:06:49 | |* 28 | HASH JOIN | | 1 | 336 | 29278 (2)| 00:05:52 | |* 29 | HASH JOIN | | 1 | 313 | 29240 (2)| 00:05:51 | |* 30 | HASH JOIN OUTER | | 4 | 848 | 1485 (2)| 00:00:18 | | 31 | NESTED LOOPS | | 4 | 600 | 16 (0)| 00:00:01 | | 32 | NESTED LOOPS | | 4 | 440 | 12 (0)| 00:00:01 | | 33 | NESTED LOOPS | | 2 | 190 | 9 (12)| 00:00:01 | | 34 | INLIST ITERATOR | | | | | | | 35 | TABLE ACCESS BY INDEX ROWID | GMS_AWARDS_ALL | 2 | 170 | 5 (0)| 00:00:01 | |* 36 | INDEX RANGE SCAN | GMS_AWARDS_U2 | 2 | | 3 (0)| 00:00:01 | | 37 | TABLE ACCESS BY INDEX ROWID | GMS_INSTALLMENTS | 1 | 10 | 2 (0)| 00:00:01 | |* 38 | INDEX RANGE SCAN | GMS_INSTALLMENTS_U2 | 1 | | 1 (0)| 00:00:01 | | 39 | TABLE ACCESS BY INDEX ROWID | GMS_PROJECT_FUNDINGS | 2 | 30 | 2 (0)| 00:00:01 | |* 40 | INDEX RANGE SCAN | GMS_PROJECT_FUNDINGS_N1 | 2 | | 1 (0)| 00:00:01 | |* 41 | TABLE ACCESS BY INDEX ROWID | PA_TASKS | 1 | 40 | 1 (0)| 00:00:01 | |* 42 | INDEX UNIQUE SCAN | PA_TASKS_U1 | 1 | | 0 (0)| 00:00:01 | | 43 | VIEW | | 1 | 62 | 1468 (2)| 00:00:18 | |* 44 | FILTER | | | | | | | 45 | SORT GROUP BY | | 1 | 188 | 1468 (2)| 00:00:18 | | 46 | NESTED LOOPS | | 1 | 188 | 1041 (2)| 00:00:13 | | 47 | NESTED LOOPS | | 1 | 163 | 1041 (2)| 00:00:13 | | 48 | NESTED LOOPS | | 1 | 128 | 1040 (2)| 00:00:13 | | 49 | NESTED LOOPS | | 1 | 101 | 1039 (2)| 00:00:13 | | 50 | NESTED LOOPS | | 1 | 91 | 1036 (2)| 00:00:13 | | 51 | NESTED LOOPS | | 1 | 84 | 1035 (2)| 00:00:13 | |* 52 | HASH JOIN | | 89 | 5429 | 679 (3)| 00:00:09 | |* 53 | HASH JOIN | | 2090 | 104K| 396 (3)| 00:00:05 | | 54 | TABLE ACCESS BY INDEX | PA_RESOURCE_LIST_MEMBERS | 62 | 744 | 4 (0)| 00:00:01 | | 55 | NESTED LOOPS | | 3 | 81 | 6 (0)| 00:00:01 | | 56 | NESTED LOOPS | | 1 | 15 | 2 (0)| 00:00:01 | |* 57 | TABLE ACCESS FULL | PA_RESOURCE_LISTS_ALL_BG | 1 | 8 | 2 (0)| 00:00:01 | |* 58 | INDEX UNIQUE SCAN | PA_RESOURCE_LISTS_TL_U1 | 1 | 7 | 0 (0)| 00:00:01 | |* 59 | INDEX RANGE SCAN | PA_RESOURCE_LIST_MEMBERS_N5 | 62 | | 1 (0)| 00:00:01 | | 60 | TABLE ACCESS FULL | GMS_RESOURCE_ASSIGNMENTS | 157K| 3682K| 387 (2)| 00:00:05 | | 61 | VIEW | VW_SQ_1 | 6689 | 66890 | 282 (3)| 00:00:04 | | 62 | SORT GROUP BY | | 6689 | 97K| 282 (3)| 00:00:04 | | 63 | TABLE ACCESS FULL | GMS_BUDGET_VERSIONS | 38910 | 569K| 278 (1)| 00:00:04 | |* 64 | TABLE ACCESS BY INDEX RO| GMS_BUDGETARY_CONTROLS | 1 | 23 | 4 (0)| 00:00:01 | |* 65 | INDEX RANGE SCAN | GMS_BUDGETARY_CONTROLS_U2 | 1 | | 3 (0)| 00:00:01 | |* 66 | TABLE ACCESS BY INDEX ROW| GMS_AWARDS_ALL | 1 | 7 | 1 (0)| 00:00:01 | |* 67 | INDEX UNIQUE SCAN | GMS_AWARDS_U1 | 1 | | 0 (0)| 00:00:01 | | 68 | TABLE ACCESS BY INDEX ROWI| GMS_BUDGET_LINES | 1 | 10 | 3 (0)| 00:00:01 | |* 69 | INDEX RANGE SCAN | GMS_BUDGET_LINES_U1 | 1 | | 2 (0)| 00:00:01 | | 70 | TABLE ACCESS BY INDEX ROWID| PA_RESOURCES | 1 | 27 | 1 (0)| 00:00:01 | |* 71 | INDEX UNIQUE SCAN | PA_RESOURCES_U1 | 1 | | 0 (0)| 00:00:01 | |* 72 | TABLE ACCESS BY INDEX ROWID | GMS_BUDGET_VERSIONS | 1 | 35 | 1 (0)| 00:00:01 | |* 73 | INDEX UNIQUE SCAN | GMS_BUDGET_VERSIONS_U1 | 1 | | 0 (0)| 00:00:01 | |* 74 | TABLE ACCESS BY INDEX ROWI| GMS_BUDGET_VERSIONS | 1 | 17 | 2 (0)| 00:00:01 | |* 75 | INDEX RANGE SCAN | GMS_BUDGET_VERSIONS_U2 | 1 | | 1 (0)| 00:00:01 | |* 76 | INDEX UNIQUE SCAN | PA_BUDGET_ENTRY_METHODS_U1 | 1 | 25 | 0 (0)| 00:00:01 | | 77 | VIEW | | 276 | 27876 | 27754 (2)| 00:05:34 | | 78 | SORT GROUP BY | | 276 | 37812 | 27754 (2)| 00:05:34 | |* 79 | FILTER | | | | | | | 80 | NESTED LOOPS | | 276 | 37812 | 27753 (2)| 00:05:34 | |* 81 | HASH JOIN OUTER | | 276 | 36432 | 27753 (2)| 00:05:34 | |* 82 | HASH JOIN | | 276 | 24564 | 27741 (2)| 00:05:33 | |* 83 | TABLE ACCESS FULL | GL_CODE_COMBINATIONS | 1792 | 17920 | 4310 (2)| 00:00:52 | | 84 | NESTED LOOPS | | 3983 | 307K| 23431 (2)| 00:04:42 | |* 85 | TABLE ACCESS FULL | TAMS_GMS_STATUS_ACTUALS | 3956 | 251K| 14701 (2)| 00:02:57 | | 86 | TABLE ACCESS BY INDEX ROWID| PA_COST_DISTRIBUTION_LINES_ALL | 1 | 14 | 3 (0)| 00:00:01 | |* 87 | INDEX UNIQUE SCAN | PA_COST_DISTRIBUTION_LINES_U1 | 1 | | 1 (0)| 00:00:01 | | 88 | TABLE ACCESS FULL | PA_EXPENDITURE_TYPES | 1237 | 53191 | 11 (0)| 00:00:01 | |* 89 | INDEX UNIQUE SCAN | GMS_AWARDS_U1 | 1 | 5 | 0 (0)| 00:00:01 | | 90 | VIEW | | 12024 | 270K| 37 (6)| 00:00:01 | | 91 | SORT GROUP BY | | 12024 | 176K| 37 (6)| 00:00:01 | | 92 | TABLE ACCESS FULL | GMS_PROJECT_FUNDINGS | 12024 | 176K| 36 (3)| 00:00:01 | | 93 | VIEW | | 1 | 62 | 4752 (3)| 00:00:58 | | 94 | SORT GROUP BY | | 1 | 45 | 4752 (3)| 00:00:58 | | 95 | VIEW | | 1 | 45 | 4752 (3)| 00:00:58 | | 96 | SORT UNIQUE | | 1 | 350 | 4752 (3)| 00:00:58 | | 97 | NESTED LOOPS | | 1 | 350 | 4749 (3)| 00:00:57 | | 98 | NESTED LOOPS | | 1 | 331 | 4749 (3)| 00:00:57 | | 99 | NESTED LOOPS | | 1 | 311 | 4748 (3)| 00:00:57 | | 100 | NESTED LOOPS | | 1 | 274 | 4748 (3)| 00:00:57 | | 101 | NESTED LOOPS | | 1 | 227 | 4746 (3)| 00:00:57 | | 102 | NESTED LOOPS | | 1 | 214 | 4745 (3)| 00:00:57 | | 103 | NESTED LOOPS | | 1 | 166 | 4742 (3)| 00:00:57 | | 104 | NESTED LOOPS | | 1 | 151 | 4740 (3)| 00:00:57 | | 105 | NESTED LOOPS | | 1 | 139 | 4739 (3)| 00:00:57 | | 106 | NESTED LOOPS | | 1 | 124 | 4738 (3)| 00:00:57 | | 107 | NESTED LOOPS | | 1 | 114 | 4736 (3)| 00:00:57 | | 108 | NESTED LOOPS | | 1 | 95 | 4736 (3)| 00:00:57 | |*109 | TABLE ACCESS FULL | GMS_BUDGETARY_CONTROLS | 1 | 35 | 4735 (3)| 00:00:57 | |*110 | TABLE ACCESS BY INDE| GMS_AWARDS_ALL | 1 | 60 | 1 (0)| 00:00:01 | |*111 | INDEX UNIQUE SCAN | GMS_AWARDS_U1 | 1 | | 0 (0)| 00:00:01 | |*112 | TABLE ACCESS BY INDEX| GMS_AWARDS_ALL | 1 | 19 | 0 (0)| 00:00:01 | |*113 | INDEX UNIQUE SCAN | GMS_AWARDS_U1 | 1 | | 0 (0)| 00:00:01 | | 114 | TABLE ACCESS BY INDEX | GMS_INSTALLMENTS | 1 | 10 | 2 (0)| 00:00:01 | |*115 | INDEX RANGE SCAN | GMS_INSTALLMENTS_U2 | 1 | | 1 (0)| 00:00:01 | |*116 | INDEX RANGE SCAN | GMS_SUMMARY_PROJECT_FUNDING_N1 | 1 | 15 | 1 (0)| 00:00:01 | |*117 | INDEX RANGE SCAN | GMS_BUDGET_VERSIONS_U2 | 1 | 12 | 1 (0)| 00:00:01 | |*118 | TABLE ACCESS BY INDEX ROW| PA_TASKS | 1 | 15 | 2 (0)| 00:00:01 | |*119 | INDEX RANGE SCAN | PA_TASKS_N8 | 1 | | 1 (0)| 00:00:01 | |*120 | TABLE ACCESS BY INDEX ROWI| PA_COMMITMENT_TXNS | 1 | 48 | 3 (0)| 00:00:01 | |*121 | INDEX RANGE SCAN | PA_COMMITMENT_TXNS_N1 | 11 | | 1 (0)| 00:00:01 | | 122 | TABLE ACCESS BY INDEX ROWID| PA_PROJECTS_ALL | 1 | 13 | 1 (0)| 00:00:01 | |*123 | INDEX UNIQUE SCAN | PA_PROJECTS_U1 | 1 | | 0 (0)| 00:00:01 | | 124 | TABLE ACCESS BY INDEX ROWID | GMS_BUDGET_VERSIONS | 1 | 47 | 1 (0)| 00:00:01 | |*125 | INDEX UNIQUE SCAN | GMS_BUDGET_VERSIONS_U1 | 1 | | 0 (0)| 00:00:01 | |*126 | TABLE ACCESS BY INDEX ROWI| GMS_BUDGET_VERSIONS | 1 | 17 | 2 (0)| 00:00:01 | |*127 | INDEX RANGE SCAN | GMS_BUDGET_VERSIONS_U2 | 1 | | 1 (0)| 00:00:01 | |*128 | INDEX UNIQUE SCAN | PA_BUDGET_ENTRY_METHODS_U1 | 1 | 37 | 0 (0)| 00:00:01 | |*129 | TABLE ACCESS BY INDEX ROWID | PA_RESOURCE_LISTS_ALL_BG | 1 | 20 | 1 (0)| 00:00:01 | |*130 | INDEX UNIQUE SCAN | PA_RESOURCE_LISTS_U1 | 1 | | 0 (0)| 00:00:01 | |*131 | INDEX UNIQUE SCAN | PA_RESOURCE_LISTS_TL_U1 | 1 | 19 | 0 (0)| 00:00:01 | |*132 | TABLE ACCESS BY INDEX ROWID | PA_PROJECTS_ALL | 1 | 58 | 1 (0)| 00:00:01 | |*133 | INDEX UNIQUE SCAN | PA_PROJECTS_U1 | 1 | | 0 (0)| 00:00:01 | |*134 | TABLE ACCESS BY INDEX ROWID | PER_ALL_PEOPLE_F | 1 | 102 | 2 (0)| 00:00:01 | |*135 | INDEX RANGE SCAN | PER_PEOPLE_F_PK | 1 | | 1 (0)| 00:00:01 | | 136 | TABLE ACCESS BY INDEX ROWID | HR_ALL_ORGANIZATION_UNITS | 1 | 28 | 1 (0)| 00:00:01 | |*137 | INDEX UNIQUE SCAN | HR_ORGANIZATION_UNITS_PK | 1 | | 0 (0)| 00:00:01 | | 138 | TABLE ACCESS BY INDEX ROWID | HZ_CUST_ACCOUNTS | 1 | 9 | 1 (0)| 00:00:01 | |*139 | INDEX UNIQUE SCAN | HZ_CUST_ACCOUNTS_U1 | 1 | | 0 (0)| 00:00:01 | | 140 | TABLE ACCESS BY INDEX ROWID | HZ_PARTIES | 1 | 21 | 1 (0)| 00:00:01 | |*141 | INDEX UNIQUE SCAN | HZ_PARTIES_U1 | 1 | | 0 (0)| 00:00:01 | | 142 | TABLE ACCESS BY INDEX ROWID | PA_IND_RATE_SCHEDULES_ALL_BG | 1 | 19 | 1 (0)| 00:00:01 | |*143 | INDEX UNIQUE SCAN | PA_IND_RATE_SCHEDULES_U1 | 1 | | 0 (0)| 00:00:01 | |*144 | INDEX RANGE SCAN | PA_PROJECT_CLASSES_N3 | 1 | 20 | 1 (0)| 00:00:01 | |*145 | INDEX RANGE SCAN | PA_PROJECT_CLASSES_N3 | 1 | 20 | 1 (0)| 00:00:01 | |*146 | INDEX RANGE SCAN | PA_PROJECT_CLASSES_N3 | 1 | 20 | 1 (0)| 00:00:01 | |*147 | INDEX RANGE SCAN | PA_PROJECT_CLASSES_N3 | 1 | 20 | 1 (0)| 00:00:01 | |*148 | INDEX RANGE SCAN | PA_PROJECT_CLASSES_N3 | 1 | 20 | 1 (0)| 00:00:01 | |*149 | INDEX RANGE SCAN | PA_PROJECT_CLASSES_N3 | 1 | 20 | 1 (0)| 00:00:01 | |*150 | INDEX RANGE SCAN | PA_PROJECT_CLASSES_N3 | 1 | 20 | 1 (0)| 00:00:01 | |*151 | INDEX RANGE SCAN | PA_PROJECT_CLASSES_N3 | 1 | 20 | 1 (0)| 00:00:01 | | 152 | TABLE ACCESS BY INDEX ROWID | HR_ALL_ORGANIZATION_UNITS | 1 | 28 | 1 (0)| 00:00:01 | |*153 | INDEX UNIQUE SCAN | HR_ORGANIZATION_UNITS_PK | 1 | | 0 (0)| 00:00:01 | |*154 | TABLE ACCESS FULL | PA_SEGMENT_VALUE_LOOKUPS | 3 | 93 | 9 (0)| 00:00:01 | |*155 | TABLE ACCESS BY INDEX ROWID | PA_PROJECT_PARTIES | 1 | 24 | 2 (0)| 00:00:01 | |*156 | INDEX RANGE SCAN | PA_PROJECT_PARTIES_N1 | 2 | | 1 (0)| 00:00:01 | |*157 | TABLE ACCESS BY INDEX ROWID | PER_ALL_PEOPLE_F | 1 | 102 | 2 (0)| 00:00:01 | |*158 | INDEX RANGE SCAN | PER_PEOPLE_F_PK | 1 | | 1 (0)| 00:00:01 | |*159 | INDEX RANGE SCAN | PA_PROJECT_PARTIES_N1 | 2 | | 1 (0)| 00:00:01 | ----------------------------------------------------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 7 - filter(NVL("PP2"."END_DATE_ACTIVE",SYSDATE@!)>=SYSDATE@! AND "PP2"."START_DATE_ACTIVE"<=SYSDATE@!) 11 - access("D1"."SEGMENT_VALUE_LOOKUP"="O1"."NAME") 27 - access("CT"."PROJECT_ID"(+)="T"."PROJECT_ID" AND "CT"."TASK_ID"(+)="T"."TASK_ID") 28 - access("F"."PROJECT_ID"="T"."PROJECT_ID" AND "F"."TASK_ID"="T"."TASK_ID") 29 - access("E"."PROJECT_ID"="T"."PROJECT_ID" AND "E"."TASK_ID"="T"."TASK_ID") 30 - access("B"."PROJECT_ID"(+)="T"."PROJECT_ID" AND "B"."TASK_ID"(+)="T"."TASK_ID") 36 - access("A"."AWARD_NUMBER"='532437C1' OR "A"."AWARD_NUMBER"='532437C2') 38 - access("A"."AWARD_ID"="GI"."AWARD_ID") 40 - access("GI"."INSTALLMENT_ID"="PF"."INSTALLMENT_ID") 41 - filter("PF"."PROJECT_ID"="T"."PROJECT_ID") 42 - access("PF"."TASK_ID"="T"."TASK_ID") 44 - filter(SUM("BL"."BURDENED_COST")>0) 52 - access("GRA"."BUDGET_VERSION_ID"="VW_COL_1" AND "PROJECT_ID"="GRA"."PROJECT_ID") 53 - access("GRA"."RESOURCE_LIST_MEMBER_ID"="RLM"."RESOURCE_LIST_MEMBER_ID") 57 - filter("PA_CROSS_BUSINESS_GRP"."ISCROSSBGPROFILE"()='Y' OR "PA_CROSS_BUSINESS_GRP"."ISCROSSBGPROFILE"()='N' AND "R"."BUSINESS_GROUP_ID"="PA_UTILS"."BUSINESS_GROUP_ID"()) 58 - access("RTL"."RESOURCE_LIST_ID"="R"."RESOURCE_LIST_ID" AND "RTL"."LANGUAGE"=USERENV('LANG')) 59 - access("R"."RESOURCE_LIST_ID"="RLM"."RESOURCE_LIST_ID") 64 - filter("GBC"."PARENT_MEMBER_ID" IS NULL) 65 - access("GBC"."PROJECT_ID"="GRA"."PROJECT_ID" AND "GBC"."TASK_ID" IS NULL AND "RESOURCE_LIST_MEMBER_ID" IS NULL) filter("GBC"."TASK_ID" IS NULL AND "RESOURCE_LIST_MEMBER_ID" IS NULL) 66 - filter(NVL("ORG_ID",NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),(-99)))=NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),(-99))) 67 - access("AWARD_ID"="GBC"."AWARD_ID") 69 - access("BL"."RESOURCE_ASSIGNMENT_ID"="GRA"."RESOURCE_ASSIGNMENT_ID") 71 - access("RLM"."RESOURCE_ID"="R"."RESOURCE_ID") 72 - filter("GBV"."RESOURCE_LIST_ID"="R"."RESOURCE_LIST_ID") 73 - access("GBV"."BUDGET_VERSION_ID"= (SELECT "BV"."BUDGET_VERSION_ID" FROM "GMS"."GMS_BUDGET_VERSIONS" "BV" WHERE "BV"."AWARD_ID"=:B1 AND "BV"."PROJECT_ID"=:B2 AND "BV"."CURRENT_FLAG"='Y')) 74 - filter("BV"."CURRENT_FLAG"='Y') 75 - access("BV"."PROJECT_ID"=:B1 AND "BV"."AWARD_ID"=:B2) 76 - access("GBV"."BUDGET_ENTRY_METHOD_CODE"="PBEM"."BUDGET_ENTRY_METHOD_CODE") 79 - filter(TO_DATE('##1','YYYY/MM/DD')<=TO_DATE('##2','YYYY/MM/DD')) 81 - access("ET"."EXPENDITURE_TYPE"(+)="GMSAC"."EXPENDITURE_TYPE") 82 - access("GCC"."CODE_COMBINATION_ID"="CDL"."DR_CODE_COMBINATION_ID") 83 - filter("GCC"."SEGMENT3">=NVL('##7',"GCC"."SEGMENT3") AND "GCC"."SEGMENT3"<=NVL('##8',"GCC"."SEGMENT3")) 85 - filter("GMSAC"."PA_DATE">=TO_DATE('##1','YYYY/MM/DD') AND "GMSAC"."PA_DATE"<=TO_DATE('##2','YYYY/MM/DD')) 87 - access("CDL"."EXPENDITURE_ITEM_ID"="GMSAC"."EXPENDITURE_ITEM_ID" AND "CDL"."LINE_NUM"=1) 89 - access("GMSAC"."AWARD_ID"="GMSA"."AWARD_ID") 109 - filter("GBC"."TASK_ID" IS NULL AND "GBC"."PARENT_MEMBER_ID" IS NULL AND "RESOURCE_LIST_MEMBER_ID" IS NULL) 110 - filter("AWARD_TEMPLATE_FLAG"='DEFERRED' AND "STATUS"<>'CLOSED' AND NVL("ORG_ID",NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),(-99)))=NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),(-99))) 111 - access("AWARD_ID"="GBC"."AWARD_ID") 112 - filter(NVL("ORG_ID",NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),(-99)))=NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),(-99))) 113 - access("AWARD_ID"="GBC"."AWARD_ID") 115 - access("INS"."AWARD_ID"="AWARD_ID") 116 - access("INS"."INSTALLMENT_ID"="SU"."INSTALLMENT_ID") 117 - access("SU"."PROJECT_ID"="BV"."PROJECT_ID" AND "BV"."AWARD_ID"="AWARD_ID") filter("BV"."BUDGET_STATUS_CODE"||''='B') 118 - filter("SU"."TASK_ID"="T"."TASK_ID" OR "SU"."TASK_ID" IS NULL OR "SU"."TASK_ID"="T"."TOP_TASK_ID") 119 - access("T"."PROJECT_ID"="BV"."PROJECT_ID") 120 - filter("T"."TASK_ID"="PCT"."TASK_ID") 121 - access("GBC"."PROJECT_ID"="PCT"."PROJECT_ID") 123 - access("P"."PROJECT_ID"="BV"."PROJECT_ID") 125 - access("GBV"."BUDGET_VERSION_ID"= (SELECT "BV"."BUDGET_VERSION_ID" FROM "GMS"."GMS_BUDGET_VERSIONS" "BV" WHERE "BV"."AWARD_ID"=:B1 AND "BV"."PROJECT_ID"=:B2 AND "BV"."CURRENT_FLAG"='Y')) 126 - filter("BV"."CURRENT_FLAG"='Y') 127 - access("BV"."PROJECT_ID"=:B1 AND "BV"."AWARD_ID"=:B2) 128 - access("GBV"."BUDGET_ENTRY_METHOD_CODE"="PBEM"."BUDGET_ENTRY_METHOD_CODE") 129 - filter("PA_CROSS_BUSINESS_GRP"."ISCROSSBGPROFILE"()='Y' OR "PA_CROSS_BUSINESS_GRP"."ISCROSSBGPROFILE"()='N' AND "R"."BUSINESS_GROUP_ID"="PA_UTILS"."BUSINESS_GROUP_ID"()) 130 - access("GBV"."RESOURCE_LIST_ID"="R"."RESOURCE_LIST_ID") 131 - access("RTL"."RESOURCE_LIST_ID"="R"."RESOURCE_LIST_ID" AND "RTL"."LANGUAGE"=USERENV('LANG')) 132 - filter("P"."PROJECT_TYPE"='Sponsored Program' AND "P"."SEGMENT1">=NVL('##5',"P"."SEGMENT1") AND "P"."SEGMENT1"<=NVL('##6',"P"."SEGMENT1")) 133 - access("T"."PROJECT_ID"="P"."PROJECT_ID") 134 - filter(DECODE("HR_SECURITY"."VIEW_ALL"(),'Y','TRUE',"HR_SECURITY"."SHOW_PERSON"("PAP"."PERSON_ID"(+),"PAP"."CURRENT_APPLICANT_FL AG"(+),"PAP"."CURRENT_EMPLOYEE_FLAG"(+),"PAP"."CURRENT_NPW_FLAG"(+),"PAP"."EMPLOYEE_NUMBER"(+),"PAP"."APPLICANT_NUMBER"(+),"PAP"."NPW_N UMBER"(+)))='TRUE' AND "PAP"."BUSINESS_GROUP_ID"(+)=DECODE("HR_GENERAL"."GET_XBG_PROFILE"(),'Y',"PAP"."BUSINESS_GROUP_ID"(+),"HR_GENERA L"."GET_BUSINESS_GROUP_ID"())) 135 - access("PERSON_ID"(+)="T"."TASK_MANAGER_PERSON_ID") 137 - access("O2"."ORGANIZATION_ID"="T"."CARRYING_OUT_ORGANIZATION_ID") 139 - access("CUST_ACCT"."CUST_ACCOUNT_ID"="A"."FUNDING_SOURCE_ID") 141 - access("CUST_ACCT"."PARTY_ID"="PARTY"."PARTY_ID") 143 - access("I"."IND_RATE_SCH_ID"="A"."IDC_SCHEDULE_ID") 144 - access("C1"."PROJECT_ID"="P"."PROJECT_ID" AND "C1"."CLASS_CATEGORY"='Expense Code') 145 - access("C2"."PROJECT_ID"="P"."PROJECT_ID" AND "C2"."CLASS_CATEGORY"='OMB A-21') 146 - access("C3"."PROJECT_ID"="P"."PROJECT_ID" AND "C3"."CLASS_CATEGORY"='Revenue Line') 147 - access("C4"."PROJECT_ID"="P"."PROJECT_ID" AND "C4"."CLASS_CATEGORY"='Burden Rate') 148 - access("C5"."PROJECT_ID"="P"."PROJECT_ID" AND "C5"."CLASS_CATEGORY"='Burden Structure') 149 - access("C6"."PROJECT_ID"="P"."PROJECT_ID" AND "C6"."CLASS_CATEGORY"='Site') 150 - access("C7"."PROJECT_ID"="P"."PROJECT_ID" AND "C7"."CLASS_CATEGORY"='Sponsor') 151 - access("C8"."PROJECT_ID"="P"."PROJECT_ID" AND "C8"."CLASS_CATEGORY"='Type') 153 - access("O1"."ORGANIZATION_ID"="P"."CARRYING_OUT_ORGANIZATION_ID") 154 - filter("D1"."SEGMENT_VALUE">=NVL('##3',"D1"."SEGMENT_VALUE") AND "D1"."SEGMENT_VALUE"<=NVL('##4',"D1"."SEGMENT_VALUE")) 155 - filter(NVL("PP1"."END_DATE_ACTIVE",SYSDATE@!)>=SYSDATE@! AND "PP1"."START_DATE_ACTIVE"<=SYSDATE@!) 156 - access("PP1"."PROJECT_ID"="P"."PROJECT_ID" AND "PP1"."PROJECT_ROLE_ID"=1) 157 - filter(DECODE("HR_SECURITY"."VIEW_ALL"(),'Y','TRUE',"HR_SECURITY"."SHOW_PERSON"("PAP"."PERSON_ID","PAP"."CURRENT_APPLICANT_FLAG" ,"PAP"."CURRENT_EMPLOYEE_FLAG","PAP"."CURRENT_NPW_FLAG","PAP"."EMPLOYEE_NUMBER","PAP"."APPLICANT_NUMBER","PAP"."NPW_NUMBER"))='TRUE' AND "PAP"."BUSINESS_GROUP_ID"=DECODE("HR_GENERAL"."GET_XBG_PROFILE"(),'Y',"PAP"."BUSINESS_GROUP_ID","HR_GENERAL"."GET_BUSINESS_GROUP_ID "())) 158 - access("PERSON_ID"="PP1"."RESOURCE_SOURCE_ID") 159 - access("PP2"."PROJECT_ID"="P"."PROJECT_ID" AND "PP2"."PROJECT_ROLE_ID"=1004)