APPS.PA_BUDGET_CORE1 dependencies on PA_RESOURCE_ACCUM_DETAILS

Line 926: FROM PA_RESOURCE_ACCUM_DETAILS PRAD

922: WHERE
923: pta.project_id = x_project_id
924: AND EXISTS
925: ( SELECT 'Yes'
926: FROM PA_RESOURCE_ACCUM_DETAILS PRAD
927: WHERE PRAD.TXN_ACCUM_ID = PTA.TXN_ACCUM_ID
928: AND PRAD.RESOURCE_LIST_MEMBER_ID IN
929: ( -- Fetch both 2nd level and group level resource list member
930: SELECT PRLM.RESOURCE_LIST_MEMBER_ID

Line 1025: FROM PA_RESOURCE_ACCUM_DETAILS PRAD

1021: WHERE
1022: pta.project_id = x_project_id
1023: AND EXISTS
1024: ( SELECT 'Yes'
1025: FROM PA_RESOURCE_ACCUM_DETAILS PRAD
1026: WHERE PRAD.TXN_ACCUM_ID = PTA.TXN_ACCUM_ID
1027: AND PRAD.RESOURCE_LIST_MEMBER_ID IN
1028: ( -- Fetch both 2nd level and group level resource list member
1029: SELECT PRLM.RESOURCE_LIST_MEMBER_ID

Line 1919: FROM PA_RESOURCE_ACCUM_DETAILS PRAD

1915: START WITH task_id = l_task_id(i)
1916: )
1917: AND EXISTS
1918: ( SELECT 'Yes'
1919: FROM PA_RESOURCE_ACCUM_DETAILS PRAD
1920: WHERE PRAD.TXN_ACCUM_ID = PTA.TXN_ACCUM_ID
1921: AND PRAD.RESOURCE_LIST_MEMBER_ID IN
1922: ( -- Fetch both 2nd level and group level resource list member
1923: SELECT PRLM.RESOURCE_LIST_MEMBER_ID

Line 2035: FROM PA_RESOURCE_ACCUM_DETAILS PRAD

2031: START WITH task_id = l_task_id(i)
2032: )
2033: AND EXISTS
2034: ( SELECT 'Yes'
2035: FROM PA_RESOURCE_ACCUM_DETAILS PRAD
2036: WHERE PRAD.TXN_ACCUM_ID = PTA.TXN_ACCUM_ID
2037: AND PRAD.RESOURCE_LIST_MEMBER_ID IN
2038: ( -- Fetch both 2nd level and group level resource list member
2039: SELECT PRLM.RESOURCE_LIST_MEMBER_ID

Line 3114: FROM PA_RESOURCE_ACCUM_DETAILS PRAD

3110: START WITH task_id = l_task_id(i)
3111: )
3112: AND EXISTS
3113: ( SELECT 'Yes'
3114: FROM PA_RESOURCE_ACCUM_DETAILS PRAD
3115: WHERE PRAD.TXN_ACCUM_ID = PTA.TXN_ACCUM_ID
3116: AND PRAD.RESOURCE_LIST_MEMBER_ID IN
3117: ( -- Fetch both 2nd level and group level resource list member
3118: SELECT PRLM.RESOURCE_LIST_MEMBER_ID

Line 3233: FROM PA_RESOURCE_ACCUM_DETAILS PRAD

3229: START WITH task_id = l_task_id(i)
3230: )
3231: AND EXISTS
3232: ( SELECT 'Yes'
3233: FROM PA_RESOURCE_ACCUM_DETAILS PRAD
3234: WHERE PRAD.TXN_ACCUM_ID = PTA.TXN_ACCUM_ID
3235: AND PRAD.RESOURCE_LIST_MEMBER_ID IN
3236: ( -- Fetch both 2nd level and group level resource list member
3237: SELECT PRLM.RESOURCE_LIST_MEMBER_ID