DBA Data[Home] [Help]

APPS.PA_MAINT_PROJECT_BUDGETS dependencies on PA_RESOURCE_LIST_ASSIGNMENTS

Line 163: , PA_RESOURCE_LIST_ASSIGNMENTS PARLA

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
167: And PARLA.PROJECT_ID = x_project_id

Line 256: , PA_RESOURCE_LIST_ASSIGNMENTS PARLA

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
260: And PARLA.PROJECT_ID = x_project_id

Line 349: , PA_RESOURCE_LIST_ASSIGNMENTS PARLA

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
353: And PARLA.PROJECT_ID = x_project_id

Line 443: , PA_RESOURCE_LIST_ASSIGNMENTS PARLA

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
447: And PARLA.PROJECT_ID = x_project_id

Line 537: , PA_RESOURCE_LIST_ASSIGNMENTS PARLA

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
541: And PARLA.PROJECT_ID = x_project_id

Line 631: , PA_RESOURCE_LIST_ASSIGNMENTS PARLA

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
635: And PARLA.PROJECT_ID = x_project_id

Line 1234: PA_RESOURCE_LIST_ASSIGNMENTS PARLA

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
1238: And PARLA.PROJECT_ID = x_project_id