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 315: from pa_resource_assignments a

311: select rowid
312: from pa_budget_lines l
313: where l.resource_assignment_id in
314: (select a.resource_assignment_id
315: from pa_resource_assignments a
316: where a.budget_version_id = x_version_id)
317: and l.start_date between x_start_period_start_date and
318: x_end_period_end_date) loop
319:

Line 530: pa_resource_assignments pra,

526: from pa_budget_lines pbl
527: where pbl.resource_assignment_id in (
528: select distinct pbl1.resource_assignment_id
529: from pa_budget_lines pbl1,
530: pa_resource_assignments pra,
531: pa_resource_list_members p1,
532: pa_resource_list_members p2
533: where pra.resource_list_member_id = p2.resource_list_member_id
534: and p1.parent_member_id = p2.resource_list_member_id

Line 1122: pa_resource_assignments pra,

1118: from pa_budget_lines pbl
1119: where pbl.resource_assignment_id in (
1120: select distinct pbl1.resource_assignment_id
1121: from pa_budget_lines pbl1,
1122: pa_resource_assignments pra,
1123: pa_resource_list_members p1,
1124: pa_resource_list_members p2
1125: where pra.resource_list_member_id = p2.resource_list_member_id
1126: and p1.parent_member_id = p2.resource_list_member_id

Line 1682: pa_resource_assignments pra,

1678: from pa_budget_lines pbl
1679: where pbl.resource_assignment_id in (
1680: select distinct pbl1.resource_assignment_id
1681: from pa_budget_lines pbl1,
1682: pa_resource_assignments pra,
1683: pa_resource_list_members p1,
1684: pa_resource_list_members p2
1685: where pra.resource_list_member_id = p2.resource_list_member_id
1686: and p1.parent_member_id = p2.resource_list_member_id

Line 2134: pa_resource_assignments pra,

2130: from pa_budget_lines pbl
2131: where pbl.resource_assignment_id in (
2132: select distinct pbl1.resource_assignment_id
2133: from pa_budget_lines pbl1,
2134: pa_resource_assignments pra,
2135: pa_resource_list_members p1,
2136: pa_resource_list_members p2
2137: where pra.resource_list_member_id = p2.resource_list_member_id
2138: and p1.parent_member_id = p2.resource_list_member_id

Line 2873: pa_resource_assignments pra,

2869: from pa_budget_lines pbl
2870: where pbl.resource_assignment_id in (
2871: select distinct pbl1.resource_assignment_id
2872: from pa_budget_lines pbl1,
2873: pa_resource_assignments pra,
2874: pa_resource_list_members p1,
2875: pa_resource_list_members p2
2876: where pra.resource_list_member_id = p2.resource_list_member_id
2877: and p1.parent_member_id = p2.resource_list_member_id

Line 3332: pa_resource_assignments pra,

3328: from pa_budget_lines pbl
3329: where pbl.resource_assignment_id in (
3330: select distinct pbl1.resource_assignment_id
3331: from pa_budget_lines pbl1,
3332: pa_resource_assignments pra,
3333: pa_resource_list_members p1,
3334: pa_resource_list_members p2
3335: where pra.resource_list_member_id = p2.resource_list_member_id
3336: and p1.parent_member_id = p2.resource_list_member_id

Line 3879: pa_resource_assignments pra

3875: )
3876: is
3877: select pbl.resource_assignment_id resource_assignment_id
3878: from pa_budget_lines pbl,
3879: pa_resource_assignments pra
3880: where pra.resource_list_member_id = l_parent_id
3881: and pbl.resource_assignment_id = pra.resource_assignment_id
3882: and pra.budget_version_id = x_budget_version_id
3883: and nvl(pra.task_id, 0) = nvl(x_task_id, 0) ;

Line 3938: -- for insert into pa_resource_assignments:

3934: --
3935: --
3936: -- 27-JUN-2002 jwhite Bug 1877119
3937: -- For the Copy_Lines procedure, add new column
3938: -- for insert into pa_resource_assignments:
3939: -- project_assignment_id, default -1.
3940: --
3941: -- 13-AUG-2002 jwhite To prevent FP model queries from breaking,
3942: -- added the following columns to the insert:

Line 3948: -- pa_resource_assignments:

3944: -- b. project_currency_code
3945: -- c. txn_currency_code
3946: --
3947: -- Additionally, the following filter was added for
3948: -- pa_resource_assignments:
3949: -- NVL(RESOURCE_ASSIGNMENT_TYPE,'USER_ENTERED') = 'USER_ENTERED'
3950: --
3951:
3952:

Line 4000: insert into pa_resource_assignments

3996:
3997: x_err_stage := 'copy resource assignment <' || to_char(x_src_version_id)
3998: || '>' ;
3999:
4000: insert into pa_resource_assignments
4001: (resource_assignment_id,
4002: budget_version_id,
4003: project_id,
4004: task_id,

Line 4016: select pa_resource_assignments_s.nextval,

4012: track_as_labor_flag,
4013: project_assignment_id,
4014: RESOURCE_ASSIGNMENT_TYPE
4015: )
4016: select pa_resource_assignments_s.nextval,
4017: x_dest_version_id,
4018: s.project_id,
4019: s.task_id,
4020: s.resource_list_member_id,

Line 4031: pa_resource_assignments s

4027: s.track_as_labor_flag,
4028: -1,
4029: s.RESOURCE_ASSIGNMENT_TYPE
4030: from
4031: pa_resource_assignments s
4032: where s.budget_version_id = x_src_version_id
4033: and NVL(s.RESOURCE_ASSIGNMENT_TYPE,'USER_ENTERED') = 'USER_ENTERED';
4034:
4035: -- Bug Fix: 4569365. Removed MRC code.

Line 4144: pa_resource_assignments sa,

4140: l.projfunc_currency_code,
4141: l.project_currency_code,
4142: l.txn_currency_code
4143: from pa_budget_lines l,
4144: pa_resource_assignments sa,
4145: pa_resource_assignments da,
4146: pa_fp_bl_map_tmp bmt /* FPB2 */
4147: where l.resource_assignment_id = sa.resource_assignment_id
4148: and sa.budget_version_id = x_src_version_id

Line 4145: pa_resource_assignments da,

4141: l.project_currency_code,
4142: l.txn_currency_code
4143: from pa_budget_lines l,
4144: pa_resource_assignments sa,
4145: pa_resource_assignments da,
4146: pa_fp_bl_map_tmp bmt /* FPB2 */
4147: where l.resource_assignment_id = sa.resource_assignment_id
4148: and sa.budget_version_id = x_src_version_id
4149: and sa.task_id = da.task_id