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

191: sum(tot_cmt_raw_cost),
192: sum(tot_cmt_burdened_cost),
193: Decode(sign(count(Distinct unit_of_measure)- 1), 0, max(unit_of_measure),null) unit_of_measure
194: FROM
195: pa_txn_accum pta
196: WHERE
197: pta.project_id = x_project_id
198: AND pta.task_id IN
199: (SELECT

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

239: sum(tot_cmt_raw_cost),
240: sum(tot_cmt_burdened_cost),
241: Decode(sign(count(Distinct unit_of_measure)- 1), 0, max(unit_of_measure),null) unit_of_measure
242: FROM
243: pa_txn_accum pta
244: WHERE
245: pta.project_id = x_project_id
246: AND pta.task_id IN
247: (SELECT

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

528: x_cmt_raw_cost,
529: x_cmt_burdened_cost,
530: x_unit_of_measure
531: FROM
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

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

600: x_cmt_raw_cost,
601: x_cmt_burdened_cost,
602: x_unit_of_measure
603: FROM
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

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

1113: x_cmt_raw_cost,
1114: x_cmt_burdened_cost,
1115: x_unit_of_measure
1116: FROM
1117: pa_txn_accum pta
1118: WHERE
1119: pta.project_id = x_project_id
1120: AND EXISTS
1121: ( SELECT 'Yes'

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

1212: x_cmt_raw_cost,
1213: x_cmt_burdened_cost,
1214: x_unit_of_measure
1215: FROM
1216: pa_txn_accum pta
1217: WHERE
1218: pta.project_id = x_project_id
1219: AND EXISTS
1220: ( SELECT 'Yes'

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

1731: x_cmt_raw_cost,
1732: x_cmt_burdened_cost,
1733: x_unit_of_measure
1734: FROM
1735: pa_txn_accum pta
1736: WHERE
1737: pta.project_id = x_project_id
1738: AND pta.task_id IN
1739: (SELECT

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

1816: x_cmt_raw_cost,
1817: x_cmt_burdened_cost,
1818: x_unit_of_measure
1819: FROM
1820: pa_txn_accum pta
1821: WHERE
1822: pta.project_id = x_project_id
1823: AND pta.task_id IN
1824: (SELECT

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

2171: x_cmt_raw_cost,
2172: x_cmt_burdened_cost,
2173: x_unit_of_measure
2174: FROM
2175: pa_txn_accum pta
2176: WHERE
2177: pta.project_id = x_project_id
2178: AND pta.task_id IN
2179: (SELECT

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

2299: x_cmt_raw_cost,
2300: x_cmt_burdened_cost,
2301: x_unit_of_measure
2302: FROM
2303: pa_txn_accum pta
2304: WHERE
2305: pta.project_id = x_project_id
2306: AND pta.task_id IN
2307: (SELECT

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

3024: x_cmt_raw_cost,
3025: x_cmt_burdened_cost,
3026: x_unit_of_measure
3027: FROM
3028: pa_txn_accum pta
3029: WHERE
3030: pta.project_id = x_project_id
3031: AND pta.task_id IN
3032: (SELECT

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

3114: x_cmt_raw_cost,
3115: x_cmt_burdened_cost,
3116: x_unit_of_measure
3117: FROM
3118: pa_txn_accum pta
3119: WHERE
3120: pta.project_id = x_project_id
3121: AND pta.task_id IN
3122: (SELECT

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

3478: x_cmt_raw_cost,
3479: x_cmt_burdened_cost,
3480: x_unit_of_measure
3481: FROM
3482: pa_txn_accum pta
3483: WHERE
3484: pta.project_id = x_project_id
3485: AND pta.task_id IN
3486: (SELECT

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

3597: x_cmt_raw_cost,
3598: x_cmt_burdened_cost,
3599: x_unit_of_measure
3600: FROM
3601: pa_txn_accum pta
3602: WHERE
3603: pta.project_id = x_project_id
3604: AND pta.task_id IN
3605: (SELECT

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