APPS.PA_BUDGET_CORE1 dependencies on PA_TXN_ACCUM_DETAILS

Line 220: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD

216: PRLM.PARENT_MEMBER_ID = x_resource_list_member_id )
217: )
218: )
219: AND EXISTS
220: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD
221: WHERE
222: PTA.TXN_ACCUM_ID = PTAD.TXN_ACCUM_ID
223: )
224: AND pta.pa_period = x_period_name;

Line 268: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD

264: PRLM.PARENT_MEMBER_ID = x_resource_list_member_id)
265: )
266: )
267: AND EXISTS
268: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD
269: WHERE
270: PTA.TXN_ACCUM_ID = PTAD.TXN_ACCUM_ID
271: )
272: AND pta.gl_period = x_period_name;

Line 536: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD

532: pa_txn_accum pta
533: WHERE
534: pta.project_id = x_project_id
535: AND EXISTS
536: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD
537: WHERE
538: PTA.TXN_ACCUM_ID = PTAD.TXN_ACCUM_ID
539: )
540: AND pta.pa_period = l_period_name(i);

Line 608: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD

604: pa_txn_accum pta
605: WHERE
606: pta.project_id = x_project_id
607: AND EXISTS
608: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD
609: WHERE
610: PTA.TXN_ACCUM_ID = PTAD.TXN_ACCUM_ID
611: )
612: AND pta.gl_period = l_period_name(i);

Line 1134: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD

1130: PRLM.PARENT_MEMBER_ID = l_RESOURCE_LIST_MEMBER_ID(i) )
1131: )
1132: )
1133: AND EXISTS
1134: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD
1135: WHERE
1136: PTA.TXN_ACCUM_ID = PTAD.TXN_ACCUM_ID
1137: )
1138: AND pta.pa_period = l_period_name(i) ;

Line 1233: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD

1229: PRLM.PARENT_MEMBER_ID = l_RESOURCE_LIST_MEMBER_ID(i) )
1230: )
1231: )
1232: AND EXISTS
1233: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD
1234: WHERE
1235: PTA.TXN_ACCUM_ID = PTAD.TXN_ACCUM_ID
1236: )
1237: AND pta.gl_period = l_period_name(i);

Line 1747: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD

1743: CONNECT BY PRIOR task_id = parent_task_id
1744: START WITH task_id = l_task_id(i)
1745: )
1746: AND EXISTS
1747: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD
1748: WHERE
1749: PTA.TXN_ACCUM_ID = PTAD.TXN_ACCUM_ID
1750: )
1751: AND pta.pa_period = l_period_name(i) ;

Line 1832: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD

1828: CONNECT BY PRIOR task_id = parent_task_id
1829: START WITH task_id = l_task_id(i)
1830: )
1831: AND EXISTS
1832: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD
1833: WHERE
1834: PTA.TXN_ACCUM_ID = PTAD.TXN_ACCUM_ID
1835: )
1836: AND pta.gl_period = l_period_name(i);

Line 2200: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD

2196: PRLM.PARENT_MEMBER_ID = l_RESOURCE_LIST_MEMBER_ID(i) )
2197: )
2198: )
2199: AND EXISTS
2200: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD
2201: WHERE
2202: PTA.TXN_ACCUM_ID = PTAD.TXN_ACCUM_ID
2203: )
2204: AND pta.pa_period = l_period_name(i) ;

Line 2328: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD

2324: PRLM.PARENT_MEMBER_ID = l_RESOURCE_LIST_MEMBER_ID(i) )
2325: )
2326: )
2327: AND EXISTS
2328: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD
2329: WHERE
2330: PTA.TXN_ACCUM_ID = PTAD.TXN_ACCUM_ID
2331: )
2332: AND pta.gl_period = l_period_name(i); */

Line 3040: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD

3036: CONNECT BY PRIOR task_id = parent_task_id
3037: START WITH task_id = l_task_id(i)
3038: )
3039: AND EXISTS
3040: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD
3041: WHERE
3042: PTA.TXN_ACCUM_ID = PTAD.TXN_ACCUM_ID
3043: )
3044: AND pta.pa_period = l_period_name(i) ;

Line 3130: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD

3126: CONNECT BY PRIOR task_id = parent_task_id
3127: START WITH task_id = l_task_id(i)
3128: )
3129: AND EXISTS
3130: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD
3131: WHERE
3132: PTA.TXN_ACCUM_ID = PTAD.TXN_ACCUM_ID
3133: )
3134: AND pta.gl_period = l_period_name(i);

Line 3507: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD

3503: PRLM.PARENT_MEMBER_ID = l_RESOURCE_LIST_MEMBER_ID(i) )
3504: )
3505: )
3506: AND EXISTS
3507: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD
3508: WHERE
3509: PTA.TXN_ACCUM_ID = PTAD.TXN_ACCUM_ID
3510: )
3511: AND pta.pa_period = l_period_name(i) ;

Line 3626: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD

3622: PRLM.PARENT_MEMBER_ID = l_RESOURCE_LIST_MEMBER_ID(i) )
3623: )
3624: )
3625: AND EXISTS
3626: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD
3627: WHERE
3628: PTA.TXN_ACCUM_ID = PTAD.TXN_ACCUM_ID
3629: )
3630: AND pta.gl_period = l_period_name(i);