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_TASKS

Line 754: FROM pa_tasks

750: IF p_fp_cols_rec.x_gen_incl_change_doc_flag = 'Y' THEN
751: IF p_etc_plan_version_id IS NOT NULL THEN
752: SELECT count(*)
753: INTO l_task_count
754: FROM pa_tasks
755: WHERE project_id = p_project_id
756: AND gen_etc_source_code = 'FINANCIAL_PLAN'
757: AND gen_etc_source_code IS NOT NULL;
758:

Line 1079: FROM pa_tasks t

1075: SELECT task_id,
1076: DECODE(c_gen_etc_src_code,
1077: NULL,NVL(gen_etc_source_code,'NONE'),
1078: c_gen_etc_src_code)
1079: FROM pa_tasks t
1080: WHERE project_id = P_PROJECT_ID;
1081:
1082: CURSOR traverse_top_tasks_cur(c_gen_etc_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE) IS
1083: SELECT task_id,

Line 1087: FROM pa_tasks t

1083: SELECT task_id,
1084: DECODE(c_gen_etc_src_code,
1085: NULL,NVL(gen_etc_source_code,'NONE'),
1086: c_gen_etc_src_code)
1087: FROM pa_tasks t
1088: WHERE project_id = P_PROJECT_ID and
1089: parent_task_id is null;
1090:
1091: l_temp_top_task_id PA_TASKS.TOP_TASK_ID%TYPE;

Line 1091: l_temp_top_task_id PA_TASKS.TOP_TASK_ID%TYPE;

1087: FROM pa_tasks t
1088: WHERE project_id = P_PROJECT_ID and
1089: parent_task_id is null;
1090:
1091: l_temp_top_task_id PA_TASKS.TOP_TASK_ID%TYPE;
1092: CURSOR traverse_child_tasks_cur IS
1093: SELECT task_id
1094: FROM pa_tasks t
1095: WHERE project_id = P_PROJECT_ID and

Line 1094: FROM pa_tasks t

1090:
1091: l_temp_top_task_id PA_TASKS.TOP_TASK_ID%TYPE;
1092: CURSOR traverse_child_tasks_cur IS
1093: SELECT task_id
1094: FROM pa_tasks t
1095: WHERE project_id = P_PROJECT_ID and
1096: top_task_id = l_temp_top_task_id and
1097: task_id <> top_task_id; -- don't want to retrieve the current node
1098:

Line 1104: l_curr_task_id PA_TASKS.TASK_ID%TYPE;

1100: l_child_task_id_tab PA_PLSQL_DATATYPES.NumTabTyp; -- ETC Enhancements 10/2004
1101: l_top_gen_etc_src_code_tab pa_plsql_datatypes.Char30TabTyp; -- ETC Enhancements 10/2004
1102: l_task_id_tab PA_PLSQL_DATATYPES.NumTabTyp;
1103: l_gen_etc_source_code_tab pa_plsql_datatypes.Char30TabTyp;
1104: l_curr_task_id PA_TASKS.TASK_ID%TYPE;
1105: l_curr_etc_source PA_TASKS.GEN_ETC_SOURCE_CODE%TYPE;
1106: l_curr_etc_ver_id NUMBER;
1107: l_curr_etc_method_code VARCHAR2(30);
1108: l_curr_src_ra_id NUMBER;

Line 1105: l_curr_etc_source PA_TASKS.GEN_ETC_SOURCE_CODE%TYPE;

1101: l_top_gen_etc_src_code_tab pa_plsql_datatypes.Char30TabTyp; -- ETC Enhancements 10/2004
1102: l_task_id_tab PA_PLSQL_DATATYPES.NumTabTyp;
1103: l_gen_etc_source_code_tab pa_plsql_datatypes.Char30TabTyp;
1104: l_curr_task_id PA_TASKS.TASK_ID%TYPE;
1105: l_curr_etc_source PA_TASKS.GEN_ETC_SOURCE_CODE%TYPE;
1106: l_curr_etc_ver_id NUMBER;
1107: l_curr_etc_method_code VARCHAR2(30);
1108: l_curr_src_ra_id NUMBER;
1109: l_curr_tgt_ra_id NUMBER;

Line 1149: -- join with pa_tasks to get the ETC source code. Instead, we return

1145: -- tasks with source of Average of Actuals separately after copying actuals.
1146: l_avg_actuals_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1147:
1148: -- Bug 4089850: Modified traverse_tasks_rlm_cur so that we no longer
1149: -- join with pa_tasks to get the ETC source code. Instead, we return
1150: -- the transaction_source_code from tmp1.
1151:
1152: CURSOR traverse_tasks_rlm_cur (c_gen_etc_source_code VARCHAR2) IS
1153: SELECT tmp1.task_id,

Line 1388: pa_tasks ta /* Added for ER 4376722 */

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
1392: AND tmp_ra.transaction_source_code <> 'OPEN_COMMITMENTS' /* Bug 4346172 */

Line 1455: pa_tasks ta /* Added for ER 4376722 */

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 */
1459: --and ta.project_id = P_PROJECT_ID /* Added for ER 4376722 */

Line 1509: pa_tasks ta /* 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
1513: AND tmp_ra.transaction_source_code = 'WORKPLAN_RESOURCES' /* Added for Bug 4369741 */

Line 1551: pa_tasks ta /* 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 */
1555: --and ta.project_id = P_PROJECT_ID /* Added for ER 4376722 */

Line 1605: pa_tasks ta /* 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
1609: AND tmp_ra.transaction_source_code = 'FINANCIAL_PLAN' /* Added for Bug 4369741 */

Line 1647: pa_tasks ta /* 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 */
1651: --and ta.project_id = P_PROJECT_ID /* Added for ER 4376722 */

Line 2421: FROM pa_tasks pt

2417: IF p_fp_cols_rec.x_fin_plan_level_code = 'T' THEN
2418:
2419: UPDATE pa_fp_fcst_gen_tmp1 tmp
2420: SET tmp.project_element_id = (SELECT pt.top_task_id
2421: FROM pa_tasks pt
2422: WHERE tmp.project_element_id = pt.task_id)
2423: WHERE tmp.data_type_code = 'ETC_FP'
2424: AND tmp.project_element_id
2425: IN

Line 2427: FROM pa_tasks pt

2423: WHERE tmp.data_type_code = 'ETC_FP'
2424: AND tmp.project_element_id
2425: IN
2426: (SELECT pt.task_id
2427: FROM pa_tasks pt
2428: WHERE pt.top_task_id IN (SELECT tmp1.task_id
2429: FROM pa_fp_calc_amt_tmp1 tmp1
2430: WHERE tmp1.budget_version_id =
2431: p_etc_fp_plan_version_id)

Line 3613: -- Note: An outer join on pa_tasks is not needed in the query

3609: l_fp_cols_rec_target.x_version_type IN ('REVENUE','ALL') THEN
3610:
3611: DELETE pa_resource_asgn_curr_tmp;
3612:
3613: -- Note: An outer join on pa_tasks is not needed in the query
3614: -- below because we are only interested in updating resources
3615: -- for non-billable tasks. Project-level tasks that require an
3616: -- outer join are always billable.
3617: INSERT INTO pa_resource_asgn_curr_tmp