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_CORE dependencies on PA_TASKS

Line 833: from pa_tasks t ,pa_resource_assignments r

829:
830: for bl_rec in (select start_date,
831: completion_date ,
832: resource_assignment_id
833: from pa_tasks t ,pa_resource_assignments r
834: where t.task_id = r.task_id
835: and r.budget_version_id = x_dest_version_id) loop
836: bl_rec.start_date := nvl(bl_rec.start_date,v_project_start_date);
837: bl_rec.completion_date := nvl(bl_rec.completion_date

Line 2145: pa_tasks st,

2141: -1,
2142: sa.RESOURCE_ASSIGNMENT_TYPE
2143: FROM
2144: pa_resource_assignments sa,
2145: pa_tasks st,
2146: pa_tasks dt,
2147: pa_budget_versions dv
2148: WHERE sa.budget_version_id = x_src_version_id
2149: AND sa.project_id = st.project_id

Line 2146: pa_tasks dt,

2142: sa.RESOURCE_ASSIGNMENT_TYPE
2143: FROM
2144: pa_resource_assignments sa,
2145: pa_tasks st,
2146: pa_tasks dt,
2147: pa_budget_versions dv
2148: WHERE sa.budget_version_id = x_src_version_id
2149: AND sa.project_id = st.project_id
2150: AND sa.task_id = st.task_id

Line 2231: FROM pa_tasks t

2227:
2228: IF l_min_start_date IS NULL THEN
2229: SELECt min(t.start_date)
2230: INTO l_min_start_date
2231: FROM pa_tasks t
2232: WHERE t.project_id = l_project_id;
2233:
2234: IF l_min_start_date is NULL THEN
2235:

Line 2296: from pa_tasks

2292: if (x_entry_level_code <> 'P') then
2293: x_err_stage := 'Getting Task Start Date <'|| to_char(x_src_version_id);
2294: select start_date
2295: into x_task_start_date
2296: from pa_tasks
2297: where task_id = budget_line_row.task_id;
2298: end if;
2299:
2300: x_err_stage := 'Getting no of periods by which line budget period needs to be shifted<'||

Line 2444: pa_tasks st,

2440: l.project_currency_code,
2441: l.txn_currency_code
2442: from pa_budget_lines l,
2443: pa_resource_assignments sa,
2444: pa_tasks st,
2445: pa_tasks dt,
2446: pa_resource_assignments da,
2447: pa_fp_bl_map_tmp bmt /* FPB2
2448: where l.resource_assignment_id =

Line 2445: pa_tasks dt,

2441: l.txn_currency_code
2442: from pa_budget_lines l,
2443: pa_resource_assignments sa,
2444: pa_tasks st,
2445: pa_tasks dt,
2446: pa_resource_assignments da,
2447: pa_fp_bl_map_tmp bmt /* FPB2
2448: where l.resource_assignment_id =
2449: budget_line_row.resource_assignment_id

Line 2665: pa_tasks st,

2661: l_project_currency_code_tbl,
2662: l_txn_currency_code_tbl
2663: from pa_budget_lines l,
2664: pa_resource_assignments sa,
2665: pa_tasks st,
2666: pa_tasks dt,
2667: pa_resource_assignments da,
2668: pa_fp_bl_map_tmp bmt /* FPB2 */
2669: where l.budget_version_id = x_src_version_id

Line 2666: pa_tasks dt,

2662: l_txn_currency_code_tbl
2663: from pa_budget_lines l,
2664: pa_resource_assignments sa,
2665: pa_tasks st,
2666: pa_tasks dt,
2667: pa_resource_assignments da,
2668: pa_fp_bl_map_tmp bmt /* FPB2 */
2669: where l.budget_version_id = x_src_version_id
2670: and l.resource_assignment_id = sa.resource_assignment_id

Line 2872: pa_tasks st,

2868: l_project_currency_code_tbl,
2869: l_txn_currency_code_tbl
2870: from pa_budget_lines l,
2871: pa_resource_assignments sa,
2872: pa_tasks st,
2873: pa_tasks dt,
2874: pa_resource_assignments da,
2875: pa_fp_bl_map_tmp bmt, /* FPB2 */
2876: PA_FP_CPY_PERIODS_TMP pptmp

Line 2873: pa_tasks dt,

2869: l_txn_currency_code_tbl
2870: from pa_budget_lines l,
2871: pa_resource_assignments sa,
2872: pa_tasks st,
2873: pa_tasks dt,
2874: pa_resource_assignments da,
2875: pa_fp_bl_map_tmp bmt, /* FPB2 */
2876: PA_FP_CPY_PERIODS_TMP pptmp
2877: where l.budget_version_id = x_src_version_id

Line 3087: pa_tasks st,

3083: l_project_currency_code_tbl,
3084: l_txn_currency_code_tbl
3085: from pa_budget_lines l,
3086: pa_resource_assignments sa,
3087: pa_tasks st,
3088: pa_tasks dt,
3089: pa_resource_assignments da,
3090: pa_fp_bl_map_tmp bmt /* FPB2 */
3091: where l.budget_version_id = x_src_version_id

Line 3088: pa_tasks dt,

3084: l_txn_currency_code_tbl
3085: from pa_budget_lines l,
3086: pa_resource_assignments sa,
3087: pa_tasks st,
3088: pa_tasks dt,
3089: pa_resource_assignments da,
3090: pa_fp_bl_map_tmp bmt /* FPB2 */
3091: where l.budget_version_id = x_src_version_id
3092: and l.resource_assignment_id = sa.resource_assignment_id