APPS.PA_BUDGET_CORE1 dependencies on PA_TXN_ACCUM_DETAILS

Line 378: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD

374: pa_txn_accum pta
375: WHERE
376: pta.project_id = x_project_id
377: AND EXISTS
378: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD
379: WHERE
380: PTA.TXN_ACCUM_ID = PTAD.TXN_ACCUM_ID
381: )
382: AND pta.pa_period = l_period_name(i);

Line 450: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD

446: pa_txn_accum pta
447: WHERE
448: pta.project_id = x_project_id
449: AND EXISTS
450: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD
451: WHERE
452: PTA.TXN_ACCUM_ID = PTAD.TXN_ACCUM_ID
453: )
454: AND pta.gl_period = l_period_name(i);

Line 938: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD

934: PRLM.PARENT_MEMBER_ID = l_RESOURCE_LIST_MEMBER_ID(i) )
935: )
936: )
937: AND EXISTS
938: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD
939: WHERE
940: PTA.TXN_ACCUM_ID = PTAD.TXN_ACCUM_ID
941: )
942: AND pta.pa_period = l_period_name(i) ;

Line 1037: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD

1033: PRLM.PARENT_MEMBER_ID = l_RESOURCE_LIST_MEMBER_ID(i) )
1034: )
1035: )
1036: AND EXISTS
1037: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD
1038: WHERE
1039: PTA.TXN_ACCUM_ID = PTAD.TXN_ACCUM_ID
1040: )
1041: AND pta.gl_period = l_period_name(i);

Line 1515: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD

1511: CONNECT BY PRIOR task_id = parent_task_id
1512: START WITH task_id = l_task_id(i)
1513: )
1514: AND EXISTS
1515: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD
1516: WHERE
1517: PTA.TXN_ACCUM_ID = PTAD.TXN_ACCUM_ID
1518: )
1519: AND pta.pa_period = l_period_name(i) ;

Line 1600: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD

1596: CONNECT BY PRIOR task_id = parent_task_id
1597: START WITH task_id = l_task_id(i)
1598: )
1599: AND EXISTS
1600: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD
1601: WHERE
1602: PTA.TXN_ACCUM_ID = PTAD.TXN_ACCUM_ID
1603: )
1604: AND pta.gl_period = l_period_name(i);

Line 1931: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD

1927: PRLM.PARENT_MEMBER_ID = l_RESOURCE_LIST_MEMBER_ID(i) )
1928: )
1929: )
1930: AND EXISTS
1931: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD
1932: WHERE
1933: PTA.TXN_ACCUM_ID = PTAD.TXN_ACCUM_ID
1934: )
1935: AND pta.pa_period = l_period_name(i) ;

Line 2047: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD

2043: PRLM.PARENT_MEMBER_ID = l_RESOURCE_LIST_MEMBER_ID(i) )
2044: )
2045: )
2046: AND EXISTS
2047: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD
2048: WHERE
2049: PTA.TXN_ACCUM_ID = PTAD.TXN_ACCUM_ID
2050: )
2051: AND pta.gl_period = l_period_name(i);

Line 2696: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD

2692: CONNECT BY PRIOR task_id = parent_task_id
2693: START WITH task_id = l_task_id(i)
2694: )
2695: AND EXISTS
2696: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD
2697: WHERE
2698: PTA.TXN_ACCUM_ID = PTAD.TXN_ACCUM_ID
2699: )
2700: AND pta.pa_period = l_period_name(i) ;

Line 2786: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD

2782: CONNECT BY PRIOR task_id = parent_task_id
2783: START WITH task_id = l_task_id(i)
2784: )
2785: AND EXISTS
2786: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD
2787: WHERE
2788: PTA.TXN_ACCUM_ID = PTAD.TXN_ACCUM_ID
2789: )
2790: AND pta.gl_period = l_period_name(i);

Line 3126: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD

3122: PRLM.PARENT_MEMBER_ID = l_RESOURCE_LIST_MEMBER_ID(i) )
3123: )
3124: )
3125: AND EXISTS
3126: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD
3127: WHERE
3128: PTA.TXN_ACCUM_ID = PTAD.TXN_ACCUM_ID
3129: )
3130: AND pta.pa_period = l_period_name(i) ;

Line 3245: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD

3241: PRLM.PARENT_MEMBER_ID = l_RESOURCE_LIST_MEMBER_ID(i) )
3242: )
3243: )
3244: AND EXISTS
3245: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD
3246: WHERE
3247: PTA.TXN_ACCUM_ID = PTAD.TXN_ACCUM_ID
3248: )
3249: AND pta.gl_period = l_period_name(i);