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 1328: SELECT pa_resource_assignments_s.nextval,

1324: track_as_labor_flag,
1325: project_assignment_id,
1326: RESOURCE_ASSIGNMENT_TYPE
1327: )
1328: SELECT pa_resource_assignments_s.nextval,
1329: l_dest_version_id,
1330: sa.project_id,
1331: sa.task_id,
1332: sa.resource_list_member_id,

Line 1343: pa_resource_assignments sa,

1339: sa.track_as_labor_flag,
1340: -1,
1341: sa.RESOURCE_ASSIGNMENT_TYPE
1342: FROM
1343: pa_resource_assignments sa,
1344: pa_resource_assignments da
1345: WHERE sa.budget_version_id = p_src_version_id
1346: AND da.budget_version_id(+) = l_dest_version_id
1347: AND sa.project_assignment_id=-1

Line 1443: pa_resource_assignments sra,

1439: pbl.projfunc_currency_code,
1440: pbl.project_currency_code,
1441: pbl.txn_currency_code
1442: from pa_budget_lines pbl,
1443: pa_resource_assignments sra,
1444: pa_resource_assignments dra
1445: where dra.budget_version_id = l_dest_version_id
1446: and sra.budget_version_id = p_src_version_id
1447: and pbl.budget_version_id = p_src_version_id

Line 2133: SELECT pa_resource_assignments_s.nextval,

2129: track_as_labor_flag,
2130: project_assignment_id,
2131: RESOURCE_ASSIGNMENT_TYPE
2132: )
2133: SELECT pa_resource_assignments_s.nextval,
2134: x_dest_version_id,
2135: dt.project_id,
2136: dt.task_id,
2137: sa.resource_list_member_id,

Line 2148: pa_resource_assignments sa,

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

Line 2178: SELECT pa_resource_assignments_s.nextval,

2174: track_as_labor_flag,
2175: project_assignment_id,
2176: RESOURCE_ASSIGNMENT_TYPE
2177: )
2178: SELECT pa_resource_assignments_s.nextval,
2179: x_dest_version_id,
2180: dv.project_id,
2181: 0,
2182: sa.resource_list_member_id,

Line 2193: pa_resource_assignments sa,

2189: sa.track_as_labor_flag,
2190: -1,
2191: sa.RESOURCE_ASSIGNMENT_TYPE
2192: FROM
2193: pa_resource_assignments sa,
2194: pa_budget_versions dv
2195: WHERE sa.budget_version_id = x_src_version_id
2196: AND sa.task_id = 0
2197: AND dv.budget_version_id = x_dest_version_id

Line 2447: pa_resource_assignments sa,

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

Line 2557: pa_resource_assignments sa,

2553: l.projfunc_currency_code,
2554: l.project_currency_code,
2555: l.txn_currency_code
2556: from pa_budget_lines l,
2557: pa_resource_assignments sa,
2558: pa_resource_assignments da,
2559: pa_fp_bl_map_tmp bmt /* FPB2
2560: where l.resource_assignment_id =
2561: budget_line_row.resource_assignment_id

Line 2668: pa_resource_assignments sa,

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

Line 2773: pa_resource_assignments sa,

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

Line 2875: pa_resource_assignments sa,

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

Line 2984: pa_resource_assignments sa,

2980: l_projfunc_currency_code_tbl,
2981: l_project_currency_code_tbl,
2982: l_txn_currency_code_tbl
2983: from pa_budget_lines l,
2984: pa_resource_assignments sa,
2985: pa_resource_assignments da,
2986: pa_fp_bl_map_tmp bmt, /* FPB2 */
2987: PA_FP_CPY_PERIODS_TMP pptmp
2988: where l.budget_version_id = x_src_version_id

Line 3090: pa_resource_assignments sa,

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

Line 3196: pa_resource_assignments sa,

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