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_S

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 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 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 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 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 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 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 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 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 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 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 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