DBA Data[Home] [Help]

APPS.PA_MAINT_PROJECT_BUDGETS dependencies on PA_RESOURCES

Line 162: , PA_RESOURCES PAR

158: BGT.UNIT_OF_MEASURE_ORIG,
159: PAR.ROLLUP_QUANTITY_FLAG,
160: PARLA.RESOURCE_LIST_ASSIGNMENT_ID
161: FROM PA_TODATE_BASE_ORIG_BUDGET_V BGT
162: , PA_RESOURCES PAR
163: , PA_RESOURCE_LIST_ASSIGNMENTS PARLA
164: WHERE BGT.PROJECT_ID = x_project_id
165: and BGT.RESOURCE_ACCUMULATED_FLAG = 'N'
166: and BGT.RESOURCE_ID = PAR.RESOURCE_ID

Line 255: , PA_RESOURCES PAR

251: BGT.UNIT_OF_MEASURE_ORIG,
252: PAR.ROLLUP_QUANTITY_FLAG,
253: PARLA.RESOURCE_LIST_ASSIGNMENT_ID
254: FROM PA_TODATE_BASE_ORIG_BUDGET_V BGT
255: , PA_RESOURCES PAR
256: , PA_RESOURCE_LIST_ASSIGNMENTS PARLA
257: WHERE BGT.PROJECT_ID = x_project_id
258: and BGT.RESOURCE_ACCUMULATED_FLAG = 'N'
259: and BGT.RESOURCE_ID = PAR.RESOURCE_ID

Line 348: , PA_RESOURCES PAR

344: BGT.UNIT_OF_MEASURE_ORIG,
345: PAR.ROLLUP_QUANTITY_FLAG,
346: PARLA.RESOURCE_LIST_ASSIGNMENT_ID
347: FROM PA_TODATE_BASE_ORIG_BUDGET_V BGT
348: , PA_RESOURCES PAR
349: , PA_RESOURCE_LIST_ASSIGNMENTS PARLA
350: WHERE BGT.PROJECT_ID = x_project_id
351: and BGT.RESOURCE_ACCUMULATED_FLAG = 'N'
352: and BGT.RESOURCE_ID = PAR.RESOURCE_ID

Line 442: , PA_RESOURCES PAR

438: BGT.UNIT_OF_MEASURE_ORIG,
439: PAR.ROLLUP_QUANTITY_FLAG,
440: PARLA.RESOURCE_LIST_ASSIGNMENT_ID
441: FROM PA_TODATE_BASE_ORIG_BUDGET_V BGT
442: , PA_RESOURCES PAR
443: , PA_RESOURCE_LIST_ASSIGNMENTS PARLA
444: WHERE BGT.PROJECT_ID = x_project_id
445: and BGT.RESOURCE_ACCUMULATED_FLAG = 'N'
446: and BGT.RESOURCE_ID = PAR.RESOURCE_ID

Line 536: , PA_RESOURCES PAR

532: BGT.UNIT_OF_MEASURE_ORIG,
533: PAR.ROLLUP_QUANTITY_FLAG,
534: PARLA.RESOURCE_LIST_ASSIGNMENT_ID
535: FROM PA_TODATE_BASE_ORIG_BUDGET_V BGT
536: , PA_RESOURCES PAR
537: , PA_RESOURCE_LIST_ASSIGNMENTS PARLA
538: WHERE BGT.PROJECT_ID = x_project_id
539: and BGT.RESOURCE_ACCUMULATED_FLAG = 'N'
540: and BGT.RESOURCE_ID = PAR.RESOURCE_ID

Line 630: , PA_RESOURCES PAR

626: BGT.UNIT_OF_MEASURE_ORIG,
627: PAR.ROLLUP_QUANTITY_FLAG,
628: PARLA.RESOURCE_LIST_ASSIGNMENT_ID
629: FROM PA_TODATE_BASE_ORIG_BUDGET_V BGT
630: , PA_RESOURCES PAR
631: , PA_RESOURCE_LIST_ASSIGNMENTS PARLA
632: WHERE BGT.PROJECT_ID = x_project_id
633: and BGT.RESOURCE_ACCUMULATED_FLAG = 'N'
634: and BGT.RESOURCE_ID = PAR.RESOURCE_ID

Line 1233: PA_RESOURCES PAR,

1229: PAR.ROLLUP_QUANTITY_FLAG,
1230: PARLA.RESOURCE_LIST_ASSIGNMENT_ID
1231: FROM
1232: PA_BUDGET_BY_RESOURCE_V PAB,
1233: PA_RESOURCES PAR,
1234: PA_RESOURCE_LIST_ASSIGNMENTS PARLA
1235: WHERE PAB.PROJECT_ID = x_project_id
1236: AND PAB.RESOURCE_ACCUMULATED_FLAG = 'N'
1237: AND PAB.RESOURCE_ID = PAR.RESOURCE_ID