eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_BUDGET_CORE1 dependencies on PA_TXN_ACCUM

Line 374: pa_txn_accum pta

370: x_cmt_raw_cost,
371: x_cmt_burdened_cost,
372: x_unit_of_measure
373: FROM
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

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 446: pa_txn_accum pta

442: x_cmt_raw_cost,
443: x_cmt_burdened_cost,
444: x_unit_of_measure
445: FROM
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

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 921: pa_txn_accum pta

917: x_cmt_raw_cost,
918: x_cmt_burdened_cost,
919: x_unit_of_measure
920: FROM
921: pa_txn_accum pta
922: WHERE
923: pta.project_id = x_project_id
924: AND EXISTS
925: ( SELECT 'Yes'

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 1020: pa_txn_accum pta

1016: x_cmt_raw_cost,
1017: x_cmt_burdened_cost,
1018: x_unit_of_measure
1019: FROM
1020: pa_txn_accum pta
1021: WHERE
1022: pta.project_id = x_project_id
1023: AND EXISTS
1024: ( SELECT 'Yes'

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 1503: pa_txn_accum pta

1499: x_cmt_raw_cost,
1500: x_cmt_burdened_cost,
1501: x_unit_of_measure
1502: FROM
1503: pa_txn_accum pta
1504: WHERE
1505: pta.project_id = x_project_id
1506: AND pta.task_id IN
1507: (SELECT

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 1588: pa_txn_accum pta

1584: x_cmt_raw_cost,
1585: x_cmt_burdened_cost,
1586: x_unit_of_measure
1587: FROM
1588: pa_txn_accum pta
1589: WHERE
1590: pta.project_id = x_project_id
1591: AND pta.task_id IN
1592: (SELECT

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 1906: pa_txn_accum pta

1902: x_cmt_raw_cost,
1903: x_cmt_burdened_cost,
1904: x_unit_of_measure
1905: FROM
1906: pa_txn_accum pta
1907: WHERE
1908: pta.project_id = x_project_id
1909: AND pta.task_id IN
1910: (SELECT

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 2022: pa_txn_accum pta

2018: x_cmt_raw_cost,
2019: x_cmt_burdened_cost,
2020: x_unit_of_measure
2021: FROM
2022: pa_txn_accum pta
2023: WHERE
2024: pta.project_id = x_project_id
2025: AND pta.task_id IN
2026: (SELECT

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 2684: pa_txn_accum pta

2680: x_cmt_raw_cost,
2681: x_cmt_burdened_cost,
2682: x_unit_of_measure
2683: FROM
2684: pa_txn_accum pta
2685: WHERE
2686: pta.project_id = x_project_id
2687: AND pta.task_id IN
2688: (SELECT

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 2774: pa_txn_accum pta

2770: x_cmt_raw_cost,
2771: x_cmt_burdened_cost,
2772: x_unit_of_measure
2773: FROM
2774: pa_txn_accum pta
2775: WHERE
2776: pta.project_id = x_project_id
2777: AND pta.task_id IN
2778: (SELECT

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 3101: pa_txn_accum pta

3097: x_cmt_raw_cost,
3098: x_cmt_burdened_cost,
3099: x_unit_of_measure
3100: FROM
3101: pa_txn_accum pta
3102: WHERE
3103: pta.project_id = x_project_id
3104: AND pta.task_id IN
3105: (SELECT

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 3220: pa_txn_accum pta

3216: x_cmt_raw_cost,
3217: x_cmt_burdened_cost,
3218: x_unit_of_measure
3219: FROM
3220: pa_txn_accum pta
3221: WHERE
3222: pta.project_id = x_project_id
3223: AND pta.task_id IN
3224: (SELECT

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);