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 1269: l_ra_txn_source_code PA_RESOURCE_ASSIGNMENTS.TRANSACTION_SOURCE_CODE%TYPE;

1265: l_fp_cols_rec_src PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
1266: /* Bug 4369741: Replaced l_planning_options_flag with 2 separate
1267: * planning options flags for WP and FP later in the declaration. */
1268: --l_planning_options_flag VARCHAR2(1);
1269: l_ra_txn_source_code PA_RESOURCE_ASSIGNMENTS.TRANSACTION_SOURCE_CODE%TYPE;
1270: l_bl_count NUMBER;
1271:
1272: l_cnt NUMBER := 1;
1273: l_cal_ra_id_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

Line 1387: PA_RESOURCE_ASSIGNMENTS ra,

1383: nvl(c_gen_etc_source_code, /* Added for Bug 4369741 */
1384: nvl(tmp_ra.transaction_source_code, 'NONE'))
1385: FROM PA_FP_CALC_AMT_TMP1 tmp_ra,
1386: PA_FP_CALC_AMT_TMP2 tmp,
1387: PA_RESOURCE_ASSIGNMENTS ra,
1388: pa_tasks ta /* Added for ER 4376722 */
1389: WHERE tmp.target_res_asg_id = ra.resource_assignment_id
1390: AND tmp.TRANSACTION_SOURCE_CODE = 'ETC'
1391: AND tmp_ra.target_res_asg_id = tmp.target_res_asg_id

Line 1454: PA_RESOURCE_ASSIGNMENTS ra,

1450: nvl(c_gen_etc_source_code, /* Added for Bug 4369741 */
1451: nvl(tmp_ra.transaction_source_code, 'NONE'))
1452: FROM PA_FP_CALC_AMT_TMP1 tmp_ra, /* Added for Bug 4369741 */
1453: PA_FP_CALC_AMT_TMP2 tmp,
1454: PA_RESOURCE_ASSIGNMENTS ra,
1455: pa_tasks ta /* Added for ER 4376722 */
1456: WHERE tmp.target_res_asg_id = ra.resource_assignment_id
1457: AND tmp.TRANSACTION_SOURCE_CODE = 'ETC'
1458: and NVL(ra.task_id,0) = ta.task_id (+) /* Added for ER 4376722 */

Line 1508: PA_RESOURCE_ASSIGNMENTS ra,

1504: NVL(ta.billable_flag,'Y'), /* Added for ER 4376722 */
1505: tmp_ra.transaction_source_code /* Added for Bug 4369741 */
1506: FROM PA_FP_CALC_AMT_TMP1 tmp_ra,
1507: PA_FP_CALC_AMT_TMP2 tmp,
1508: PA_RESOURCE_ASSIGNMENTS ra,
1509: pa_tasks ta /* Added for ER 4376722 */
1510: WHERE tmp.target_res_asg_id = ra.resource_assignment_id
1511: AND tmp.TRANSACTION_SOURCE_CODE = 'ETC'
1512: AND tmp_ra.target_res_asg_id = tmp.target_res_asg_id

Line 1550: PA_RESOURCE_ASSIGNMENTS ra,

1546: NVL(ta.billable_flag,'Y'), /* Added for ER 4376722 */
1547: tmp_ra.transaction_source_code /* Added for Bug 4369741 */
1548: FROM PA_FP_CALC_AMT_TMP1 tmp_ra, /* Added for Bug 4369741 */
1549: PA_FP_CALC_AMT_TMP2 tmp,
1550: PA_RESOURCE_ASSIGNMENTS ra,
1551: pa_tasks ta /* Added for ER 4376722 */
1552: WHERE tmp.target_res_asg_id = ra.resource_assignment_id
1553: AND tmp.TRANSACTION_SOURCE_CODE = 'ETC'
1554: and NVL(ra.task_id,0) = ta.task_id (+) /* Added for ER 4376722 */

Line 1604: PA_RESOURCE_ASSIGNMENTS ra,

1600: NVL(ta.billable_flag,'Y'), /* Added for ER 4376722 */
1601: tmp_ra.transaction_source_code /* Added for Bug 4369741 */
1602: FROM PA_FP_CALC_AMT_TMP1 tmp_ra,
1603: PA_FP_CALC_AMT_TMP2 tmp,
1604: PA_RESOURCE_ASSIGNMENTS ra,
1605: pa_tasks ta /* Added for ER 4376722 */
1606: WHERE tmp.target_res_asg_id = ra.resource_assignment_id
1607: AND tmp.TRANSACTION_SOURCE_CODE = 'ETC'
1608: AND tmp_ra.target_res_asg_id = tmp.target_res_asg_id

Line 1646: PA_RESOURCE_ASSIGNMENTS ra,

1642: NVL(ta.billable_flag,'Y'), /* Added for ER 4376722 */
1643: tmp_ra.transaction_source_code /* Added for Bug 4369741 */
1644: FROM PA_FP_CALC_AMT_TMP1 tmp_ra, /* Added for Bug 4369741 */
1645: PA_FP_CALC_AMT_TMP2 tmp,
1646: PA_RESOURCE_ASSIGNMENTS ra,
1647: pa_tasks ta /* Added for ER 4376722 */
1648: WHERE tmp.target_res_asg_id = ra.resource_assignment_id
1649: AND tmp.TRANSACTION_SOURCE_CODE = 'ETC'
1650: and NVL(ra.task_id,0) = ta.task_id (+) /* Added for ER 4376722 */

Line 3191: pa_resource_assignments ra

3187: DISTINCT tmp1.target_res_asg_id
3188: BULK COLLECT
3189: INTO l_res_asg_uom_update_tab
3190: FROM PA_FP_CALC_AMT_TMP1 tmp1,
3191: pa_resource_assignments ra
3192: WHERE ra.budget_version_id = p_budget_version_id
3193: AND ra.resource_assignment_id = tmp1.target_res_asg_id
3194: AND ( ra.transaction_source_code IS NOT NULL
3195: OR ( ra.transaction_source_code IS NULL

Line 3213: pa_resource_assignments ra

3209: DISTINCT tmp1.target_res_asg_id
3210: BULK COLLECT
3211: INTO l_res_asg_uom_update_tab
3212: FROM PA_FP_CALC_AMT_TMP1 tmp1,
3213: pa_resource_assignments ra
3214: WHERE ra.budget_version_id = p_budget_version_id
3215: AND ra.resource_assignment_id = tmp1.target_res_asg_id
3216: AND ( ra.transaction_source_code IS NOT NULL
3217: OR ( ra.transaction_source_code IS NULL

Line 3234: UPDATE pa_resource_assignments

3230: END IF; -- time phase check
3231: END IF;
3232:
3233: FORALL i IN 1..l_res_asg_uom_update_tab.count
3234: UPDATE pa_resource_assignments
3235: SET unit_of_measure = 'DOLLARS',
3236: rate_based_flag = 'N'
3237: WHERE resource_assignment_id = l_res_asg_uom_update_tab(i);
3238: END IF;

Line 3406: FROM pa_resource_assignments

3402:
3403: FOR i in 1..l_cal_ra_id_tab_tmp.count LOOP
3404: SELECT transaction_source_code
3405: INTO l_ra_txn_source_code
3406: FROM pa_resource_assignments
3407: WHERE resource_assignment_id = l_cal_ra_id_tab_tmp(i);
3408:
3409: l_bl_count := 0;
3410:

Line 4653: FROM pa_resource_assignments

4649: SELECT planning_start_date,
4650: planning_end_date
4651: INTO l_start_date,
4652: l_end_date
4653: FROM pa_resource_assignments
4654: WHERE resource_assignment_id = l_cal_ra_id_tab(i);
4655:
4656: /*Start of the rounding handing*/
4657: IF l_cal_rate_based_flag_tab(i) = 'Y' THEN