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_RESOURCE_ASSIGNMENTS

Line 814: from pa_resource_assignments

810: set start_date= v_project_start_date,
811: end_date = v_project_completion_date
812: where resource_assignment_id in
813: (select resource_assignment_id
814: from pa_resource_assignments
815: where budget_version_id = x_dest_version_id)
816: and ((start_date <> v_project_start_date) OR (end_date <> v_project_completion_date));
817:
818: -- fix 876456: Added check that rows should be updated only if the project start or end

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 1308: INSERT INTO pa_resource_assignments

1304: and s.closing_status in ('C','P'));
1305: end if;
1306:
1307: x_err_stage := 'About to create new resource assignments in dest';
1308: INSERT INTO pa_resource_assignments
1309: (resource_assignment_id,
1310: budget_version_id,
1311: project_id,
1312: task_id,

Line 1324: SELECT pa_resource_assignments_s.nextval,

1320: track_as_labor_flag,
1321: project_assignment_id,
1322: RESOURCE_ASSIGNMENT_TYPE
1323: )
1324: SELECT pa_resource_assignments_s.nextval,
1325: l_dest_version_id,
1326: sa.project_id,
1327: sa.task_id,
1328: sa.resource_list_member_id,

Line 1339: pa_resource_assignments sa,

1335: sa.track_as_labor_flag,
1336: -1,
1337: sa.RESOURCE_ASSIGNMENT_TYPE
1338: FROM
1339: pa_resource_assignments sa,
1340: pa_resource_assignments da
1341: WHERE sa.budget_version_id = p_src_version_id
1342: AND da.budget_version_id(+) = l_dest_version_id
1343: AND sa.project_assignment_id=-1

Line 1340: pa_resource_assignments da

1336: -1,
1337: sa.RESOURCE_ASSIGNMENT_TYPE
1338: FROM
1339: pa_resource_assignments sa,
1340: pa_resource_assignments da
1341: WHERE sa.budget_version_id = p_src_version_id
1342: AND da.budget_version_id(+) = l_dest_version_id
1343: AND sa.project_assignment_id=-1
1344: AND da.project_assignment_id(+)=-1

Line 1439: pa_resource_assignments sra,

1435: pbl.projfunc_currency_code,
1436: pbl.project_currency_code,
1437: pbl.txn_currency_code
1438: from pa_budget_lines pbl,
1439: pa_resource_assignments sra,
1440: pa_resource_assignments dra
1441: where dra.budget_version_id = l_dest_version_id
1442: and sra.budget_version_id = p_src_version_id
1443: and pbl.budget_version_id = p_src_version_id

Line 1440: pa_resource_assignments dra

1436: pbl.project_currency_code,
1437: pbl.txn_currency_code
1438: from pa_budget_lines pbl,
1439: pa_resource_assignments sra,
1440: pa_resource_assignments dra
1441: where dra.budget_version_id = l_dest_version_id
1442: and sra.budget_version_id = p_src_version_id
1443: and pbl.budget_version_id = p_src_version_id
1444: and sra.resource_assignment_id=pbl.resource_assignment_id

Line 1454: delete from pa_resource_assignments

1450: where s.application_id = pa_period_process_pkg.application_id
1451: and i.set_of_books_id = s.set_of_books_id
1452: and s.closing_status in ('C','P'));
1453: x_err_stage := 'About to delete unused resource assignments from dest';
1454: delete from pa_resource_assignments
1455: where budget_version_id = l_dest_version_id
1456: and resource_assignment_id not in
1457: (select distinct resource_assignment_id
1458: from pa_budget_lines

Line 1963: -- for insert into pa_resource_assignments:

1959: --
1960: -- History
1961: -- 27-JUN-2002 jwhite Bug 1877119
1962: -- For the Copy_Lines procedure, add new column
1963: -- for insert into pa_resource_assignments:
1964: -- project_assignment_id, default -1.
1965: --
1966: -- - MOdified to support the new FP model:
1967: -- a. added NVL(a.RESOURCE_ASSIGNMENT_TYPE,'USER_ENTERED') = 'USER_ENTERED'

Line 2113: INSERT INTO pa_resource_assignments

2109: || '>' ;
2110:
2111: IF (x_entry_level_code <> 'P') THEN
2112:
2113: INSERT INTO pa_resource_assignments
2114: (resource_assignment_id,
2115: budget_version_id,
2116: project_id,
2117: task_id,

Line 2129: SELECT pa_resource_assignments_s.nextval,

2125: track_as_labor_flag,
2126: project_assignment_id,
2127: RESOURCE_ASSIGNMENT_TYPE
2128: )
2129: SELECT pa_resource_assignments_s.nextval,
2130: x_dest_version_id,
2131: dt.project_id,
2132: dt.task_id,
2133: sa.resource_list_member_id,

Line 2144: pa_resource_assignments sa,

2140: sa.track_as_labor_flag,
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

Line 2158: INSERT INTO pa_resource_assignments

2154: AND NVL(sa.RESOURCE_ASSIGNMENT_TYPE,'USER_ENTERED') = 'USER_ENTERED';
2155:
2156: ELSE
2157:
2158: INSERT INTO pa_resource_assignments
2159: (resource_assignment_id,
2160: budget_version_id,
2161: project_id,
2162: task_id,

Line 2174: SELECT pa_resource_assignments_s.nextval,

2170: track_as_labor_flag,
2171: project_assignment_id,
2172: RESOURCE_ASSIGNMENT_TYPE
2173: )
2174: SELECT pa_resource_assignments_s.nextval,
2175: x_dest_version_id,
2176: dv.project_id,
2177: 0,
2178: sa.resource_list_member_id,

Line 2189: pa_resource_assignments sa,

2185: sa.track_as_labor_flag,
2186: -1,
2187: sa.RESOURCE_ASSIGNMENT_TYPE
2188: FROM
2189: pa_resource_assignments sa,
2190: pa_budget_versions dv
2191: WHERE sa.budget_version_id = x_src_version_id
2192: AND sa.task_id = 0
2193: AND dv.budget_version_id = x_dest_version_id

Line 2270: pa_resource_assignments a

2266:
2267: for budget_line_row in
2268: (select l.resource_assignment_id, l.start_date, l.end_date,a.task_id, l.period_name
2269: from pa_budget_lines l,
2270: pa_resource_assignments a
2271: where a.budget_version_id = x_src_version_id
2272: and a.resource_assignment_id = l.resource_assignment_id
2273: and NVL(a.RESOURCE_ASSIGNMENT_TYPE,'USER_ENTERED') = 'USER_ENTERED'
2274: ) loop

Line 2443: pa_resource_assignments sa,

2439: l.projfunc_currency_code,
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

Line 2446: pa_resource_assignments da,

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
2450: and l.start_date = budget_line_row.start_date

Line 2553: pa_resource_assignments sa,

2549: l.projfunc_currency_code,
2550: l.project_currency_code,
2551: l.txn_currency_code
2552: from pa_budget_lines l,
2553: pa_resource_assignments sa,
2554: pa_resource_assignments da,
2555: pa_fp_bl_map_tmp bmt /* FPB2
2556: where l.resource_assignment_id =
2557: budget_line_row.resource_assignment_id

Line 2554: pa_resource_assignments da,

2550: l.project_currency_code,
2551: l.txn_currency_code
2552: from pa_budget_lines l,
2553: pa_resource_assignments sa,
2554: pa_resource_assignments da,
2555: pa_fp_bl_map_tmp bmt /* FPB2
2556: where l.resource_assignment_id =
2557: budget_line_row.resource_assignment_id
2558: and l.start_date = budget_line_row.start_date

Line 2664: pa_resource_assignments sa,

2660: l_projfunc_currency_code_tbl,
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 */

Line 2667: pa_resource_assignments da,

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
2671: and sa.budget_version_id = x_src_version_id

Line 2769: pa_resource_assignments sa,

2765: l_projfunc_currency_code_tbl,
2766: l_project_currency_code_tbl,
2767: l_txn_currency_code_tbl
2768: from pa_budget_lines l,
2769: pa_resource_assignments sa,
2770: pa_resource_assignments da,
2771: pa_fp_bl_map_tmp bmt /* FPB2 */
2772: where l.budget_version_id = x_src_version_id
2773: and l.resource_assignment_id = sa.resource_assignment_id

Line 2770: pa_resource_assignments da,

2766: l_project_currency_code_tbl,
2767: l_txn_currency_code_tbl
2768: from pa_budget_lines l,
2769: pa_resource_assignments sa,
2770: pa_resource_assignments da,
2771: pa_fp_bl_map_tmp bmt /* FPB2 */
2772: where l.budget_version_id = x_src_version_id
2773: and l.resource_assignment_id = sa.resource_assignment_id
2774: and sa.budget_version_id = x_src_version_id

Line 2871: pa_resource_assignments sa,

2867: l_projfunc_currency_code_tbl,
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 */

Line 2874: pa_resource_assignments da,

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
2878: and l.resource_assignment_id = sa.resource_assignment_id

Line 2980: pa_resource_assignments sa,

2976: l_projfunc_currency_code_tbl,
2977: l_project_currency_code_tbl,
2978: l_txn_currency_code_tbl
2979: from pa_budget_lines l,
2980: pa_resource_assignments sa,
2981: pa_resource_assignments da,
2982: pa_fp_bl_map_tmp bmt, /* FPB2 */
2983: PA_FP_CPY_PERIODS_TMP pptmp
2984: where l.budget_version_id = x_src_version_id

Line 2981: pa_resource_assignments da,

2977: l_project_currency_code_tbl,
2978: l_txn_currency_code_tbl
2979: from pa_budget_lines l,
2980: pa_resource_assignments sa,
2981: pa_resource_assignments da,
2982: pa_fp_bl_map_tmp bmt, /* FPB2 */
2983: PA_FP_CPY_PERIODS_TMP pptmp
2984: where l.budget_version_id = x_src_version_id
2985: and l.resource_assignment_id = sa.resource_assignment_id

Line 3086: pa_resource_assignments sa,

3082: l_projfunc_currency_code_tbl,
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 */

Line 3089: pa_resource_assignments da,

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
3093: and sa.budget_version_id = x_src_version_id

Line 3192: pa_resource_assignments sa,

3188: l_projfunc_currency_code_tbl,
3189: l_project_currency_code_tbl,
3190: l_txn_currency_code_tbl
3191: from pa_budget_lines l,
3192: pa_resource_assignments sa,
3193: pa_resource_assignments da,
3194: pa_fp_bl_map_tmp bmt /* FPB2 */
3195: where l.budget_version_id = x_src_version_id
3196: and l.resource_assignment_id = sa.resource_assignment_id

Line 3193: pa_resource_assignments da,

3189: l_project_currency_code_tbl,
3190: l_txn_currency_code_tbl
3191: from pa_budget_lines l,
3192: pa_resource_assignments sa,
3193: pa_resource_assignments da,
3194: pa_fp_bl_map_tmp bmt /* FPB2 */
3195: where l.budget_version_id = x_src_version_id
3196: and l.resource_assignment_id = sa.resource_assignment_id
3197: and sa.budget_version_id = x_src_version_id