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_FP_GEN_FCST_AMT_PUB dependencies on PA_RESOURCE_ASSIGNMENTS

Line 1113: l_ra_txn_source_code PA_RESOURCE_ASSIGNMENTS.TRANSACTION_SOURCE_CODE%TYPE;

1109: l_fp_cols_rec_src PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
1110: /* Bug 4369741: Replaced l_planning_options_flag with 2 separate
1111: * planning options flags for WP and FP later in the declaration. */
1112: --l_planning_options_flag VARCHAR2(1);
1113: l_ra_txn_source_code PA_RESOURCE_ASSIGNMENTS.TRANSACTION_SOURCE_CODE%TYPE;
1114: l_bl_count NUMBER;
1115:
1116: l_cnt NUMBER := 1;
1117: l_cal_ra_id_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

Line 1229: PA_RESOURCE_ASSIGNMENTS ra,

1225: nvl(c_gen_etc_source_code, /* Added for Bug 4369741 */
1226: nvl(tmp_ra.transaction_source_code, 'NONE'))
1227: FROM PA_FP_CALC_AMT_TMP1 tmp_ra,
1228: PA_FP_CALC_AMT_TMP2 tmp,
1229: PA_RESOURCE_ASSIGNMENTS ra,
1230: pa_tasks ta /* Added for ER 4376722 */
1231: WHERE tmp.target_res_asg_id = ra.resource_assignment_id
1232: AND tmp.TRANSACTION_SOURCE_CODE = 'ETC'
1233: AND tmp_ra.target_res_asg_id = tmp.target_res_asg_id

Line 1294: PA_RESOURCE_ASSIGNMENTS ra,

1290: nvl(c_gen_etc_source_code, /* Added for Bug 4369741 */
1291: nvl(tmp_ra.transaction_source_code, 'NONE'))
1292: FROM PA_FP_CALC_AMT_TMP1 tmp_ra, /* Added for Bug 4369741 */
1293: PA_FP_CALC_AMT_TMP2 tmp,
1294: PA_RESOURCE_ASSIGNMENTS ra,
1295: pa_tasks ta /* Added for ER 4376722 */
1296: WHERE tmp.target_res_asg_id = ra.resource_assignment_id
1297: AND tmp.TRANSACTION_SOURCE_CODE = 'ETC'
1298: and NVL(ra.task_id,0) = ta.task_id (+) /* Added for ER 4376722 */

Line 1346: PA_RESOURCE_ASSIGNMENTS ra,

1342: NVL(ta.billable_flag,'Y'), /* Added for ER 4376722 */
1343: tmp_ra.transaction_source_code /* Added for Bug 4369741 */
1344: FROM PA_FP_CALC_AMT_TMP1 tmp_ra,
1345: PA_FP_CALC_AMT_TMP2 tmp,
1346: PA_RESOURCE_ASSIGNMENTS ra,
1347: pa_tasks ta /* Added for ER 4376722 */
1348: WHERE tmp.target_res_asg_id = ra.resource_assignment_id
1349: AND tmp.TRANSACTION_SOURCE_CODE = 'ETC'
1350: AND tmp_ra.target_res_asg_id = tmp.target_res_asg_id

Line 1386: PA_RESOURCE_ASSIGNMENTS ra,

1382: NVL(ta.billable_flag,'Y'), /* Added for ER 4376722 */
1383: tmp_ra.transaction_source_code /* Added for Bug 4369741 */
1384: FROM PA_FP_CALC_AMT_TMP1 tmp_ra, /* Added for Bug 4369741 */
1385: PA_FP_CALC_AMT_TMP2 tmp,
1386: PA_RESOURCE_ASSIGNMENTS ra,
1387: pa_tasks ta /* Added for ER 4376722 */
1388: WHERE tmp.target_res_asg_id = ra.resource_assignment_id
1389: AND tmp.TRANSACTION_SOURCE_CODE = 'ETC'
1390: and NVL(ra.task_id,0) = ta.task_id (+) /* Added for ER 4376722 */

Line 1438: PA_RESOURCE_ASSIGNMENTS ra,

1434: NVL(ta.billable_flag,'Y'), /* Added for ER 4376722 */
1435: tmp_ra.transaction_source_code /* Added for Bug 4369741 */
1436: FROM PA_FP_CALC_AMT_TMP1 tmp_ra,
1437: PA_FP_CALC_AMT_TMP2 tmp,
1438: PA_RESOURCE_ASSIGNMENTS ra,
1439: pa_tasks ta /* Added for ER 4376722 */
1440: WHERE tmp.target_res_asg_id = ra.resource_assignment_id
1441: AND tmp.TRANSACTION_SOURCE_CODE = 'ETC'
1442: AND tmp_ra.target_res_asg_id = tmp.target_res_asg_id

Line 1478: PA_RESOURCE_ASSIGNMENTS ra,

1474: NVL(ta.billable_flag,'Y'), /* Added for ER 4376722 */
1475: tmp_ra.transaction_source_code /* Added for Bug 4369741 */
1476: FROM PA_FP_CALC_AMT_TMP1 tmp_ra, /* Added for Bug 4369741 */
1477: PA_FP_CALC_AMT_TMP2 tmp,
1478: PA_RESOURCE_ASSIGNMENTS ra,
1479: pa_tasks ta /* Added for ER 4376722 */
1480: WHERE tmp.target_res_asg_id = ra.resource_assignment_id
1481: AND tmp.TRANSACTION_SOURCE_CODE = 'ETC'
1482: and NVL(ra.task_id,0) = ta.task_id (+) /* Added for ER 4376722 */

Line 2964: pa_resource_assignments ra

2960: DISTINCT tmp1.target_res_asg_id
2961: BULK COLLECT
2962: INTO l_res_asg_uom_update_tab
2963: FROM PA_FP_CALC_AMT_TMP1 tmp1,
2964: pa_resource_assignments ra
2965: WHERE ra.budget_version_id = p_budget_version_id
2966: AND ra.resource_assignment_id = tmp1.target_res_asg_id
2967: AND ( ra.transaction_source_code IS NOT NULL
2968: OR ( ra.transaction_source_code IS NULL

Line 2986: pa_resource_assignments ra

2982: DISTINCT tmp1.target_res_asg_id
2983: BULK COLLECT
2984: INTO l_res_asg_uom_update_tab
2985: FROM PA_FP_CALC_AMT_TMP1 tmp1,
2986: pa_resource_assignments ra
2987: WHERE ra.budget_version_id = p_budget_version_id
2988: AND ra.resource_assignment_id = tmp1.target_res_asg_id
2989: AND ( ra.transaction_source_code IS NOT NULL
2990: OR ( ra.transaction_source_code IS NULL

Line 3007: UPDATE pa_resource_assignments

3003: END IF; -- time phase check
3004: END IF;
3005:
3006: FORALL i IN 1..l_res_asg_uom_update_tab.count
3007: UPDATE pa_resource_assignments
3008: SET unit_of_measure = 'DOLLARS',
3009: rate_based_flag = 'N'
3010: WHERE resource_assignment_id = l_res_asg_uom_update_tab(i);
3011: END IF;

Line 3172: FROM pa_resource_assignments

3168:
3169: FOR i in 1..l_cal_ra_id_tab_tmp.count LOOP
3170: SELECT transaction_source_code
3171: INTO l_ra_txn_source_code
3172: FROM pa_resource_assignments
3173: WHERE resource_assignment_id = l_cal_ra_id_tab_tmp(i);
3174:
3175: l_bl_count := 0;
3176:

Line 4397: FROM pa_resource_assignments

4393: SELECT planning_start_date,
4394: planning_end_date
4395: INTO l_start_date,
4396: l_end_date
4397: FROM pa_resource_assignments
4398: WHERE resource_assignment_id = l_cal_ra_id_tab(i);
4399:
4400: /*Start of the rounding handing*/
4401: IF l_cal_rate_based_flag_tab(i) = 'Y' THEN