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 837: from pa_tasks t ,pa_resource_assignments r

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

Line 2149: pa_tasks st,

2145: -1,
2146: sa.RESOURCE_ASSIGNMENT_TYPE
2147: FROM
2148: pa_resource_assignments sa,
2149: pa_tasks st,
2150: pa_tasks dt,
2151: pa_budget_versions dv
2152: WHERE sa.budget_version_id = x_src_version_id
2153: AND sa.project_id = st.project_id

Line 2150: pa_tasks dt,

2146: sa.RESOURCE_ASSIGNMENT_TYPE
2147: FROM
2148: pa_resource_assignments sa,
2149: pa_tasks st,
2150: pa_tasks dt,
2151: pa_budget_versions dv
2152: WHERE sa.budget_version_id = x_src_version_id
2153: AND sa.project_id = st.project_id
2154: AND sa.task_id = st.task_id

Line 2235: FROM pa_tasks t

2231:
2232: IF l_min_start_date IS NULL THEN
2233: SELECt min(t.start_date)
2234: INTO l_min_start_date
2235: FROM pa_tasks t
2236: WHERE t.project_id = l_project_id;
2237:
2238: IF l_min_start_date is NULL THEN
2239:

Line 2300: from pa_tasks

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

Line 2448: pa_tasks st,

2444: l.project_currency_code,
2445: l.txn_currency_code
2446: from pa_budget_lines l,
2447: pa_resource_assignments sa,
2448: pa_tasks st,
2449: pa_tasks dt,
2450: pa_resource_assignments da,
2451: pa_fp_bl_map_tmp bmt /* FPB2
2452: where l.resource_assignment_id =

Line 2449: pa_tasks dt,

2445: l.txn_currency_code
2446: from pa_budget_lines l,
2447: pa_resource_assignments sa,
2448: pa_tasks st,
2449: pa_tasks dt,
2450: pa_resource_assignments da,
2451: pa_fp_bl_map_tmp bmt /* FPB2
2452: where l.resource_assignment_id =
2453: budget_line_row.resource_assignment_id

Line 2669: pa_tasks st,

2665: l_project_currency_code_tbl,
2666: l_txn_currency_code_tbl
2667: from pa_budget_lines l,
2668: pa_resource_assignments sa,
2669: pa_tasks st,
2670: pa_tasks dt,
2671: pa_resource_assignments da,
2672: pa_fp_bl_map_tmp bmt /* FPB2 */
2673: where l.budget_version_id = x_src_version_id

Line 2670: pa_tasks dt,

2666: l_txn_currency_code_tbl
2667: from pa_budget_lines l,
2668: pa_resource_assignments sa,
2669: pa_tasks st,
2670: pa_tasks dt,
2671: pa_resource_assignments da,
2672: pa_fp_bl_map_tmp bmt /* FPB2 */
2673: where l.budget_version_id = x_src_version_id
2674: and l.resource_assignment_id = sa.resource_assignment_id

Line 2876: pa_tasks st,

2872: l_project_currency_code_tbl,
2873: l_txn_currency_code_tbl
2874: from pa_budget_lines l,
2875: pa_resource_assignments sa,
2876: pa_tasks st,
2877: pa_tasks dt,
2878: pa_resource_assignments da,
2879: pa_fp_bl_map_tmp bmt, /* FPB2 */
2880: PA_FP_CPY_PERIODS_TMP pptmp

Line 2877: pa_tasks dt,

2873: l_txn_currency_code_tbl
2874: from pa_budget_lines l,
2875: pa_resource_assignments sa,
2876: pa_tasks st,
2877: pa_tasks dt,
2878: pa_resource_assignments da,
2879: pa_fp_bl_map_tmp bmt, /* FPB2 */
2880: PA_FP_CPY_PERIODS_TMP pptmp
2881: where l.budget_version_id = x_src_version_id

Line 3091: pa_tasks st,

3087: l_project_currency_code_tbl,
3088: l_txn_currency_code_tbl
3089: from pa_budget_lines l,
3090: pa_resource_assignments sa,
3091: pa_tasks st,
3092: pa_tasks dt,
3093: pa_resource_assignments da,
3094: pa_fp_bl_map_tmp bmt /* FPB2 */
3095: where l.budget_version_id = x_src_version_id

Line 3092: pa_tasks dt,

3088: l_txn_currency_code_tbl
3089: from pa_budget_lines l,
3090: pa_resource_assignments sa,
3091: pa_tasks st,
3092: pa_tasks dt,
3093: pa_resource_assignments da,
3094: pa_fp_bl_map_tmp bmt /* FPB2 */
3095: where l.budget_version_id = x_src_version_id
3096: and l.resource_assignment_id = sa.resource_assignment_id