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_TASKS

Line 128: pa_tasks t,

124: m.resource_list_member_id,
125: m.resource_id,
126: m.track_as_labor_flag
127: from pa_periods p,
128: pa_tasks t,
129: pa_resource_list_members m
130: where m.resource_list_id = x_resource_list_id
131: and nvl(m.migration_code, 'M') = 'M'
132: and not exists

Line 140: from pa_tasks t1

136: m.resource_list_member_id)
137: and t.project_id = x_project_id
138: and not exists
139: (select 1
140: from pa_tasks t1
141: where t1.parent_task_id = t.task_id)
142: and p.start_date between x_start_period_start_date
143: and x_end_period_end_date;
144:

Line 158: pa_tasks t,

154: m.resource_id,
155: m.track_as_labor_flag
156: from gl_period_statuses p,
157: pa_implementations i,
158: pa_tasks t,
159: pa_resource_list_members m
160: where m.resource_list_id = x_resource_list_id
161: and not exists
162: (select 1

Line 169: from pa_tasks t1

165: m.resource_list_member_id)
166: and t.project_id = x_project_id
167: and not exists
168: (select 1
169: from pa_tasks t1
170: where t1.parent_task_id = t.task_id)
171: and p.application_id = pa_period_process_pkg.application_id
172: and p.set_of_books_id = i.set_of_books_id
173: and p.adjustment_period_flag = 'N'

Line 202: pa_tasks

198: AND pta.task_id IN
199: (SELECT
200: task_id
201: FROM
202: pa_tasks
203: CONNECT BY PRIOR task_id = parent_task_id
204: START WITH task_id = x_task_id
205: )
206: AND EXISTS

Line 250: pa_tasks

246: AND pta.task_id IN
247: (SELECT
248: task_id
249: FROM
250: pa_tasks
251: CONNECT BY PRIOR task_id = parent_task_id
252: START WITH task_id = x_task_id
253: )
254: AND EXISTS

Line 1701: pa_tasks t

1697: l_start_date,
1698: l_end_date,
1699: l_task_id
1700: from pa_periods p,
1701: pa_tasks t
1702: where t.project_id = x_project_id
1703: and t.task_id = t.top_task_id
1704: and p.start_date between x_start_period_start_date
1705: and x_end_period_end_date;

Line 1742: pa_tasks

1738: AND pta.task_id IN
1739: (SELECT
1740: task_id
1741: FROM
1742: pa_tasks
1743: CONNECT BY PRIOR task_id = parent_task_id
1744: START WITH task_id = l_task_id(i)
1745: )
1746: AND EXISTS

Line 1783: pa_tasks t

1779: l_end_date,
1780: l_task_id
1781: from gl_period_statuses p,
1782: pa_implementations i,
1783: pa_tasks t
1784: where t.project_id = x_project_id
1785: and t.task_id = t.top_task_id
1786: and p.application_id = pa_period_process_pkg.application_id
1787: and p.set_of_books_id = i.set_of_books_id

Line 1827: pa_tasks

1823: AND pta.task_id IN
1824: (SELECT
1825: task_id
1826: FROM
1827: pa_tasks
1828: CONNECT BY PRIOR task_id = parent_task_id
1829: START WITH task_id = l_task_id(i)
1830: )
1831: AND EXISTS

Line 2131: pa_tasks t,

2127: l_resource_list_member_id,
2128: l_resource_id,
2129: l_track_as_labor_flag
2130: from pa_periods p,
2131: pa_tasks t,
2132: pa_resource_list_members m
2133: where m.resource_list_id = x_resource_list_id
2134: and nvl(m.migration_code, 'M') = 'M'
2135: and not exists

Line 2182: pa_tasks

2178: AND pta.task_id IN
2179: (SELECT
2180: task_id
2181: FROM
2182: pa_tasks
2183: CONNECT BY PRIOR task_id = parent_task_id
2184: START WITH task_id = l_task_id(i)
2185: )
2186: AND EXISTS

Line 2247: pa_tasks t,

2243: l_resource_id,
2244: l_track_as_labor_flag
2245: from gl_period_statuses p,
2246: pa_implementations i,
2247: pa_tasks t,
2248: pa_resource_list_members m
2249: where m.resource_list_id = x_resource_list_id
2250: and not exists
2251: (select 1

Line 2310: pa_tasks

2306: AND pta.task_id IN
2307: (SELECT
2308: task_id
2309: FROM
2310: pa_tasks
2311: CONNECT BY PRIOR task_id = parent_task_id
2312: START WITH task_id = l_task_id(i)
2313: )
2314: AND EXISTS

Line 2647: from pa_tasks t

2643: /* elsif (x_entry_level_code = 'T') then
2644:
2645: -- go through every top level task
2646: for top_task_rec in (select t.task_id
2647: from pa_tasks t
2648: where t.project_id = x_project_id
2649: and t.task_id = t.top_task_id) loop
2650:
2651: x_raw_cost:= 0;

Line 2989: pa_tasks t

2985: l_start_date,
2986: l_end_date,
2987: l_task_id
2988: from pa_periods p,
2989: pa_tasks t
2990: where t.project_id = x_project_id
2991: and not exists
2992: (select 1
2993: from pa_tasks t1

Line 2993: from pa_tasks t1

2989: pa_tasks t
2990: where t.project_id = x_project_id
2991: and not exists
2992: (select 1
2993: from pa_tasks t1
2994: where t1.parent_task_id = t.task_id)
2995: and p.start_date between x_start_period_start_date
2996: and x_end_period_end_date;
2997:

Line 3035: pa_tasks

3031: AND pta.task_id IN
3032: (SELECT
3033: task_id
3034: FROM
3035: pa_tasks
3036: CONNECT BY PRIOR task_id = parent_task_id
3037: START WITH task_id = l_task_id(i)
3038: )
3039: AND EXISTS

Line 3078: pa_tasks t

3074: l_end_date,
3075: l_task_id
3076: from gl_period_statuses p,
3077: pa_implementations i,
3078: pa_tasks t
3079: where t.project_id = x_project_id
3080: and not exists
3081: (select 1
3082: from pa_tasks t1

Line 3082: from pa_tasks t1

3078: pa_tasks t
3079: where t.project_id = x_project_id
3080: and not exists
3081: (select 1
3082: from pa_tasks t1
3083: where t1.parent_task_id = t.task_id)
3084: and p.application_id = pa_period_process_pkg.application_id
3085: and p.set_of_books_id = i.set_of_books_id
3086: and p.adjustment_period_flag = 'N'

Line 3125: pa_tasks

3121: AND pta.task_id IN
3122: (SELECT
3123: task_id
3124: FROM
3125: pa_tasks
3126: CONNECT BY PRIOR task_id = parent_task_id
3127: START WITH task_id = l_task_id(i)
3128: )
3129: AND EXISTS

Line 3435: pa_tasks t,

3431: l_resource_list_member_id,
3432: l_resource_id,
3433: l_track_as_labor_flag
3434: from pa_periods p,
3435: pa_tasks t,
3436: pa_resource_list_members m
3437: where m.resource_list_id = x_resource_list_id
3438: and nvl(m.migration_code, 'M') = 'M'
3439: and not exists

Line 3447: from pa_tasks t1

3443: m.resource_list_member_id)
3444: and t.project_id = x_project_id
3445: and not exists
3446: (select 1
3447: from pa_tasks t1
3448: where t1.parent_task_id = t.task_id)
3449: and p.start_date between x_start_period_start_date
3450: and x_end_period_end_date;
3451:

Line 3489: pa_tasks

3485: AND pta.task_id IN
3486: (SELECT
3487: task_id
3488: FROM
3489: pa_tasks
3490: CONNECT BY PRIOR task_id = parent_task_id
3491: START WITH task_id = l_task_id(i)
3492: )
3493: AND EXISTS

Line 3554: pa_tasks t,

3550: l_resource_id,
3551: l_track_as_labor_flag
3552: from gl_period_statuses p,
3553: pa_implementations i,
3554: pa_tasks t,
3555: pa_resource_list_members m
3556: where m.resource_list_id = x_resource_list_id
3557: and not exists
3558: (select 1

Line 3565: from pa_tasks t1

3561: m.resource_list_member_id)
3562: and t.project_id = x_project_id
3563: and not exists
3564: (select 1
3565: from pa_tasks t1
3566: where t1.parent_task_id = t.task_id)
3567: and p.application_id = pa_period_process_pkg.application_id
3568: and p.set_of_books_id = i.set_of_books_id
3569: and p.adjustment_period_flag = 'N'

Line 3608: pa_tasks

3604: AND pta.task_id IN
3605: (SELECT
3606: task_id
3607: FROM
3608: pa_tasks
3609: CONNECT BY PRIOR task_id = parent_task_id
3610: START WITH task_id = l_task_id(i)
3611: )
3612: AND EXISTS

Line 3919: from pa_tasks t

3915: end if;
3916: /* End of part 4 for BUg 4889056 */
3917: /* Begin of commented code
3918: for task_rec in (select t.task_id
3919: from pa_tasks t
3920: where t.project_id = x_project_id
3921: and not exists
3922: (select 1
3923: from pa_tasks t1

Line 3923: from pa_tasks t1

3919: from pa_tasks t
3920: where t.project_id = x_project_id
3921: and not exists
3922: (select 1
3923: from pa_tasks t1
3924: where t1.parent_task_id = t.task_id)
3925:
3926: ) loop
3927: