APPS.PA_BUDGET_CORE1 dependencies on PA_RESOURCE_ACCUM_DETAILS

Line 208: FROM PA_RESOURCE_ACCUM_DETAILS PRAD

204: START WITH task_id = x_task_id
205: )
206: AND EXISTS
207: ( SELECT 'Yes'
208: FROM PA_RESOURCE_ACCUM_DETAILS PRAD
209: WHERE PRAD.TXN_ACCUM_ID = PTA.TXN_ACCUM_ID
210: AND PRAD.RESOURCE_LIST_MEMBER_ID IN
211: ( -- Fetch both 2nd level and group level resource list member
212: SELECT PRLM.RESOURCE_LIST_MEMBER_ID

Line 256: FROM PA_RESOURCE_ACCUM_DETAILS PRAD

252: START WITH task_id = x_task_id
253: )
254: AND EXISTS
255: ( SELECT 'Yes'
256: FROM PA_RESOURCE_ACCUM_DETAILS PRAD
257: WHERE PRAD.TXN_ACCUM_ID = PTA.TXN_ACCUM_ID
258: AND PRAD.RESOURCE_LIST_MEMBER_ID IN
259: ( -- Fetch both 2nd level and group level resource list member
260: SELECT PRLM.RESOURCE_LIST_MEMBER_ID

Line 1122: FROM PA_RESOURCE_ACCUM_DETAILS PRAD

1118: WHERE
1119: pta.project_id = x_project_id
1120: AND EXISTS
1121: ( SELECT 'Yes'
1122: FROM PA_RESOURCE_ACCUM_DETAILS PRAD
1123: WHERE PRAD.TXN_ACCUM_ID = PTA.TXN_ACCUM_ID
1124: AND PRAD.RESOURCE_LIST_MEMBER_ID IN
1125: ( -- Fetch both 2nd level and group level resource list member
1126: SELECT PRLM.RESOURCE_LIST_MEMBER_ID

Line 1221: FROM PA_RESOURCE_ACCUM_DETAILS PRAD

1217: WHERE
1218: pta.project_id = x_project_id
1219: AND EXISTS
1220: ( SELECT 'Yes'
1221: FROM PA_RESOURCE_ACCUM_DETAILS PRAD
1222: WHERE PRAD.TXN_ACCUM_ID = PTA.TXN_ACCUM_ID
1223: AND PRAD.RESOURCE_LIST_MEMBER_ID IN
1224: ( -- Fetch both 2nd level and group level resource list member
1225: SELECT PRLM.RESOURCE_LIST_MEMBER_ID

Line 2188: FROM PA_RESOURCE_ACCUM_DETAILS PRAD

2184: START WITH task_id = l_task_id(i)
2185: )
2186: AND EXISTS
2187: ( SELECT 'Yes'
2188: FROM PA_RESOURCE_ACCUM_DETAILS PRAD
2189: WHERE PRAD.TXN_ACCUM_ID = PTA.TXN_ACCUM_ID
2190: AND PRAD.RESOURCE_LIST_MEMBER_ID IN
2191: ( -- Fetch both 2nd level and group level resource list member
2192: SELECT PRLM.RESOURCE_LIST_MEMBER_ID

Line 2316: FROM PA_RESOURCE_ACCUM_DETAILS PRAD

2312: START WITH task_id = l_task_id(i)
2313: )
2314: AND EXISTS
2315: ( SELECT 'Yes'
2316: FROM PA_RESOURCE_ACCUM_DETAILS PRAD
2317: WHERE PRAD.TXN_ACCUM_ID = PTA.TXN_ACCUM_ID
2318: AND PRAD.RESOURCE_LIST_MEMBER_ID IN
2319: ( -- Fetch both 2nd level and group level resource list member
2320: SELECT PRLM.RESOURCE_LIST_MEMBER_ID

Line 3495: FROM PA_RESOURCE_ACCUM_DETAILS PRAD

3491: START WITH task_id = l_task_id(i)
3492: )
3493: AND EXISTS
3494: ( SELECT 'Yes'
3495: FROM PA_RESOURCE_ACCUM_DETAILS PRAD
3496: WHERE PRAD.TXN_ACCUM_ID = PTA.TXN_ACCUM_ID
3497: AND PRAD.RESOURCE_LIST_MEMBER_ID IN
3498: ( -- Fetch both 2nd level and group level resource list member
3499: SELECT PRLM.RESOURCE_LIST_MEMBER_ID

Line 3614: FROM PA_RESOURCE_ACCUM_DETAILS PRAD

3610: START WITH task_id = l_task_id(i)
3611: )
3612: AND EXISTS
3613: ( SELECT 'Yes'
3614: FROM PA_RESOURCE_ACCUM_DETAILS PRAD
3615: WHERE PRAD.TXN_ACCUM_ID = PTA.TXN_ACCUM_ID
3616: AND PRAD.RESOURCE_LIST_MEMBER_ID IN
3617: ( -- Fetch both 2nd level and group level resource list member
3618: SELECT PRLM.RESOURCE_LIST_MEMBER_ID