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 654: FROM pa_tasks

650: IF p_fp_cols_rec.x_gen_incl_change_doc_flag = 'Y' THEN
651: IF p_etc_plan_version_id IS NOT NULL THEN
652: SELECT count(*)
653: INTO l_task_count
654: FROM pa_tasks
655: WHERE project_id = p_project_id
656: AND gen_etc_source_code = 'FINANCIAL_PLAN'
657: AND gen_etc_source_code IS NOT NULL;
658:

Line 941: FROM pa_tasks t

937: SELECT task_id,
938: DECODE(c_gen_etc_src_code,
939: NULL,NVL(gen_etc_source_code,'NONE'),
940: c_gen_etc_src_code)
941: FROM pa_tasks t
942: WHERE project_id = P_PROJECT_ID;
943:
944: CURSOR traverse_top_tasks_cur(c_gen_etc_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE) IS
945: SELECT task_id,

Line 949: FROM pa_tasks t

945: SELECT task_id,
946: DECODE(c_gen_etc_src_code,
947: NULL,NVL(gen_etc_source_code,'NONE'),
948: c_gen_etc_src_code)
949: FROM pa_tasks t
950: WHERE project_id = P_PROJECT_ID and
951: parent_task_id is null;
952:
953: l_temp_top_task_id PA_TASKS.TOP_TASK_ID%TYPE;

Line 953: l_temp_top_task_id PA_TASKS.TOP_TASK_ID%TYPE;

949: FROM pa_tasks t
950: WHERE project_id = P_PROJECT_ID and
951: parent_task_id is null;
952:
953: l_temp_top_task_id PA_TASKS.TOP_TASK_ID%TYPE;
954: CURSOR traverse_child_tasks_cur IS
955: SELECT task_id
956: FROM pa_tasks t
957: WHERE project_id = P_PROJECT_ID and

Line 956: FROM pa_tasks t

952:
953: l_temp_top_task_id PA_TASKS.TOP_TASK_ID%TYPE;
954: CURSOR traverse_child_tasks_cur IS
955: SELECT task_id
956: FROM pa_tasks t
957: WHERE project_id = P_PROJECT_ID and
958: top_task_id = l_temp_top_task_id and
959: task_id <> top_task_id; -- don't want to retrieve the current node
960:

Line 966: l_curr_task_id PA_TASKS.TASK_ID%TYPE;

962: l_child_task_id_tab PA_PLSQL_DATATYPES.NumTabTyp; -- ETC Enhancements 10/2004
963: l_top_gen_etc_src_code_tab pa_plsql_datatypes.Char30TabTyp; -- ETC Enhancements 10/2004
964: l_task_id_tab PA_PLSQL_DATATYPES.NumTabTyp;
965: l_gen_etc_source_code_tab pa_plsql_datatypes.Char30TabTyp;
966: l_curr_task_id PA_TASKS.TASK_ID%TYPE;
967: l_curr_etc_source PA_TASKS.GEN_ETC_SOURCE_CODE%TYPE;
968: l_curr_etc_ver_id NUMBER;
969: l_curr_etc_method_code VARCHAR2(30);
970: l_curr_src_ra_id NUMBER;

Line 967: l_curr_etc_source PA_TASKS.GEN_ETC_SOURCE_CODE%TYPE;

963: l_top_gen_etc_src_code_tab pa_plsql_datatypes.Char30TabTyp; -- ETC Enhancements 10/2004
964: l_task_id_tab PA_PLSQL_DATATYPES.NumTabTyp;
965: l_gen_etc_source_code_tab pa_plsql_datatypes.Char30TabTyp;
966: l_curr_task_id PA_TASKS.TASK_ID%TYPE;
967: l_curr_etc_source PA_TASKS.GEN_ETC_SOURCE_CODE%TYPE;
968: l_curr_etc_ver_id NUMBER;
969: l_curr_etc_method_code VARCHAR2(30);
970: l_curr_src_ra_id NUMBER;
971: l_curr_tgt_ra_id NUMBER;

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

1003: -- tasks with source of Average of Actuals separately after copying actuals.
1004: l_avg_actuals_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1005:
1006: -- Bug 4089850: Modified traverse_tasks_rlm_cur so that we no longer
1007: -- join with pa_tasks to get the ETC source code. Instead, we return
1008: -- the transaction_source_code from tmp1.
1009:
1010: CURSOR traverse_tasks_rlm_cur (c_gen_etc_source_code VARCHAR2) IS
1011: SELECT tmp1.task_id,

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

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

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

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

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

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

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

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

Line 2239: FROM pa_tasks pt

2235: IF p_fp_cols_rec.x_fin_plan_level_code = 'T' THEN
2236:
2237: UPDATE pa_fp_fcst_gen_tmp1 tmp
2238: SET tmp.project_element_id = (SELECT pt.top_task_id
2239: FROM pa_tasks pt
2240: WHERE tmp.project_element_id = pt.task_id)
2241: WHERE tmp.data_type_code = 'ETC_FP'
2242: AND tmp.project_element_id
2243: IN

Line 2245: FROM pa_tasks pt

2241: WHERE tmp.data_type_code = 'ETC_FP'
2242: AND tmp.project_element_id
2243: IN
2244: (SELECT pt.task_id
2245: FROM pa_tasks pt
2246: WHERE pt.top_task_id IN (SELECT tmp1.task_id
2247: FROM pa_fp_calc_amt_tmp1 tmp1
2248: WHERE tmp1.budget_version_id =
2249: p_etc_fp_plan_version_id)

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

3369: l_fp_cols_rec_target.x_version_type IN ('REVENUE','ALL') THEN
3370:
3371: DELETE pa_resource_asgn_curr_tmp;
3372:
3373: -- Note: An outer join on pa_tasks is not needed in the query
3374: -- below because we are only interested in updating resources
3375: -- for non-billable tasks. Project-level tasks that require an
3376: -- outer join are always billable.
3377: INSERT INTO pa_resource_asgn_curr_tmp