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_RESOURCE_ASSIGNMENTS

Line 473: from pa_resource_assignments a

469: select rowid
470: from pa_budget_lines l
471: where l.resource_assignment_id in
472: (select a.resource_assignment_id
473: from pa_resource_assignments a
474: where a.budget_version_id = x_version_id)
475: and l.start_date between x_start_period_start_date and
476: x_end_period_end_date) loop
477:

Line 694: pa_resource_assignments pra,

690: from pa_budget_lines pbl
691: where pbl.resource_assignment_id in (
692: select distinct pbl1.resource_assignment_id
693: from pa_budget_lines pbl1,
694: pa_resource_assignments pra,
695: pa_resource_list_members p1,
696: pa_resource_list_members p2
697: where pra.resource_list_member_id = p2.resource_list_member_id
698: and p1.parent_member_id = p2.resource_list_member_id

Line 1323: pa_resource_assignments pra,

1319: from pa_budget_lines pbl
1320: where pbl.resource_assignment_id in (
1321: select distinct pbl1.resource_assignment_id
1322: from pa_budget_lines pbl1,
1323: pa_resource_assignments pra,
1324: pa_resource_list_members p1,
1325: pa_resource_list_members p2
1326: where pra.resource_list_member_id = p2.resource_list_member_id
1327: and p1.parent_member_id = p2.resource_list_member_id

Line 1920: pa_resource_assignments pra,

1916: from pa_budget_lines pbl
1917: where pbl.resource_assignment_id in (
1918: select distinct pbl1.resource_assignment_id
1919: from pa_budget_lines pbl1,
1920: pa_resource_assignments pra,
1921: pa_resource_list_members p1,
1922: pa_resource_list_members p2
1923: where pra.resource_list_member_id = p2.resource_list_member_id
1924: and p1.parent_member_id = p2.resource_list_member_id

Line 2441: pa_resource_assignments pra,

2437: from pa_budget_lines pbl
2438: where pbl.resource_assignment_id in (
2439: select distinct pbl1.resource_assignment_id
2440: from pa_budget_lines pbl1,
2441: pa_resource_assignments pra,
2442: pa_resource_list_members p1,
2443: pa_resource_list_members p2
2444: where pra.resource_list_member_id = p2.resource_list_member_id
2445: and p1.parent_member_id = p2.resource_list_member_id

Line 3223: pa_resource_assignments pra,

3219: from pa_budget_lines pbl
3220: where pbl.resource_assignment_id in (
3221: select distinct pbl1.resource_assignment_id
3222: from pa_budget_lines pbl1,
3223: pa_resource_assignments pra,
3224: pa_resource_list_members p1,
3225: pa_resource_list_members p2
3226: where pra.resource_list_member_id = p2.resource_list_member_id
3227: and p1.parent_member_id = p2.resource_list_member_id

Line 3719: pa_resource_assignments pra,

3715: from pa_budget_lines pbl
3716: where pbl.resource_assignment_id in (
3717: select distinct pbl1.resource_assignment_id
3718: from pa_budget_lines pbl1,
3719: pa_resource_assignments pra,
3720: pa_resource_list_members p1,
3721: pa_resource_list_members p2
3722: where pra.resource_list_member_id = p2.resource_list_member_id
3723: and p1.parent_member_id = p2.resource_list_member_id

Line 4297: pa_resource_assignments pra

4293: )
4294: is
4295: select pbl.resource_assignment_id resource_assignment_id
4296: from pa_budget_lines pbl,
4297: pa_resource_assignments pra
4298: where pra.resource_list_member_id = l_parent_id
4299: and pbl.resource_assignment_id = pra.resource_assignment_id
4300: and pra.budget_version_id = x_budget_version_id
4301: and nvl(pra.task_id, 0) = nvl(x_task_id, 0) ;

Line 4356: -- for insert into pa_resource_assignments:

4352: --
4353: --
4354: -- 27-JUN-2002 jwhite Bug 1877119
4355: -- For the Copy_Lines procedure, add new column
4356: -- for insert into pa_resource_assignments:
4357: -- project_assignment_id, default -1.
4358: --
4359: -- 13-AUG-2002 jwhite To prevent FP model queries from breaking,
4360: -- added the following columns to the insert:

Line 4366: -- pa_resource_assignments:

4362: -- b. project_currency_code
4363: -- c. txn_currency_code
4364: --
4365: -- Additionally, the following filter was added for
4366: -- pa_resource_assignments:
4367: -- NVL(RESOURCE_ASSIGNMENT_TYPE,'USER_ENTERED') = 'USER_ENTERED'
4368: --
4369:
4370:

Line 4418: insert into pa_resource_assignments

4414:
4415: x_err_stage := 'copy resource assignment <' || to_char(x_src_version_id)
4416: || '>' ;
4417:
4418: insert into pa_resource_assignments
4419: (resource_assignment_id,
4420: budget_version_id,
4421: project_id,
4422: task_id,

Line 4434: select pa_resource_assignments_s.nextval,

4430: track_as_labor_flag,
4431: project_assignment_id,
4432: RESOURCE_ASSIGNMENT_TYPE
4433: )
4434: select pa_resource_assignments_s.nextval,
4435: x_dest_version_id,
4436: s.project_id,
4437: s.task_id,
4438: s.resource_list_member_id,

Line 4449: pa_resource_assignments s

4445: s.track_as_labor_flag,
4446: -1,
4447: s.RESOURCE_ASSIGNMENT_TYPE
4448: from
4449: pa_resource_assignments s
4450: where s.budget_version_id = x_src_version_id
4451: and NVL(s.RESOURCE_ASSIGNMENT_TYPE,'USER_ENTERED') = 'USER_ENTERED';
4452:
4453: -- Bug Fix: 4569365. Removed MRC code.

Line 4562: pa_resource_assignments sa,

4558: l.projfunc_currency_code,
4559: l.project_currency_code,
4560: l.txn_currency_code
4561: from pa_budget_lines l,
4562: pa_resource_assignments sa,
4563: pa_resource_assignments da,
4564: pa_fp_bl_map_tmp bmt /* FPB2 */
4565: where l.resource_assignment_id = sa.resource_assignment_id
4566: and sa.budget_version_id = x_src_version_id

Line 4563: pa_resource_assignments da,

4559: l.project_currency_code,
4560: l.txn_currency_code
4561: from pa_budget_lines l,
4562: pa_resource_assignments sa,
4563: pa_resource_assignments da,
4564: pa_fp_bl_map_tmp bmt /* FPB2 */
4565: where l.resource_assignment_id = sa.resource_assignment_id
4566: and sa.budget_version_id = x_src_version_id
4567: and sa.task_id = da.task_id