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_BUDGET_AMT_PUB dependencies on PA_TASKS

Line 4490: PA_TASKS PAT

4486: NVL(PAT.TOP_TASK_ID,0),
4487: MIN(T.TXN_PLANNING_START_DATE),
4488: MAX(T.TXN_PLANNING_END_DATE)
4489: FROM PA_RES_LIST_MAP_TMP4 T,
4490: PA_TASKS PAT
4491: WHERE NVL(T.TXN_TASK_ID,0) > 0
4492: AND NVL(T.TXN_TASK_ID,0) = PAT.TASK_ID
4493: AND NOT EXISTS
4494: (SELECT /*+ INDEX(T,PA_RES_LIST_MAP_TMP4_N1)*/ 1

Line 4495: FROM PA_RESOURCE_ASSIGNMENTS P,PA_TASKS TS

4491: WHERE NVL(T.TXN_TASK_ID,0) > 0
4492: AND NVL(T.TXN_TASK_ID,0) = PAT.TASK_ID
4493: AND NOT EXISTS
4494: (SELECT /*+ INDEX(T,PA_RES_LIST_MAP_TMP4_N1)*/ 1
4495: FROM PA_RESOURCE_ASSIGNMENTS P,PA_TASKS TS
4496: WHERE P.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID
4497: AND NVL(T.TXN_TASK_ID,0) > 0
4498: AND TS.TASK_ID = NVL(T.TXN_TASK_ID,0)
4499: AND NVL(TS.TOP_TASK_ID,0) = NVL(P.TASK_ID,0)

Line 4535: PA_TASKS PAT,

4531: MIN(T.TXN_PLANNING_START_DATE),
4532: MAX(T.TXN_PLANNING_END_DATE),
4533: PRA.CBS_ELEMENT_ID
4534: FROM PA_RES_LIST_MAP_TMP4 T,
4535: PA_TASKS PAT,
4536: PA_RESOURCE_ASSIGNMENTS PRA,
4537: PA_ALTERNATE_TASKS PALT
4538: WHERE NVL(T.TXN_TASK_ID,0) > 0
4539: AND NVL(T.TXN_TASK_ID,0) = PAT.TASK_ID

Line 4545: FROM PA_RESOURCE_ASSIGNMENTS P,PA_TASKS TS

4541: AND PALT.PROJ_ELEMENT_ID = NVL(PAT.TOP_TASK_ID,0)
4542: AND PRA.RESOURCE_ASSIGNMENT_ID = T.TXN_SOURCE_ID
4543: AND NOT EXISTS
4544: (SELECT /*+ INDEX(T,PA_RES_LIST_MAP_TMP4_N1)*/ 1
4545: FROM PA_RESOURCE_ASSIGNMENTS P,PA_TASKS TS
4546: WHERE P.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID
4547: AND NVL(T.TXN_TASK_ID,0) > 0
4548: AND TS.TASK_ID = NVL(T.TXN_TASK_ID,0)
4549: AND NVL(TS.TOP_TASK_ID,0) = NVL(P.TASK_ID,0)

Line 4694: PA_TASKS PAT,

4690: v1.MAPPED_FIN_STR_VERSION_ID,pat.top_task_id),0),
4691: MIN(T.TXN_PLANNING_START_DATE),
4692: MAX(T.TXN_PLANNING_END_DATE)
4693: FROM PA_RES_LIST_MAP_TMP4 T,
4694: PA_TASKS PAT,
4695: PA_MAP_WP_TO_FIN_TASKS_V V1
4696: WHERE NVL(V1.MAPPED_FIN_TASK_ID,0) = PAT.TASK_ID (+)
4697: AND NOT EXISTS
4698: (SELECT /*+ INDEX(T,PA_RES_LIST_MAP_TMP4_N1)*/ 1

Line 4699: FROM PA_RESOURCE_ASSIGNMENTS P,PA_TASKS TS,PA_MAP_WP_TO_FIN_TASKS_V V

4695: PA_MAP_WP_TO_FIN_TASKS_V V1
4696: WHERE NVL(V1.MAPPED_FIN_TASK_ID,0) = PAT.TASK_ID (+)
4697: AND NOT EXISTS
4698: (SELECT /*+ INDEX(T,PA_RES_LIST_MAP_TMP4_N1)*/ 1
4699: FROM PA_RESOURCE_ASSIGNMENTS P,PA_TASKS TS,PA_MAP_WP_TO_FIN_TASKS_V V
4700: WHERE P.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID
4701: AND V.PARENT_STRUCTURE_VERSION_ID = P_WP_STRUCTURE_VER_ID
4702: AND NVL(T.TXN_TASK_ID,0) = NVL(V.PROJ_ELEMENT_ID,0)
4703: AND TS.TASK_ID(+) = NVL(V.MAPPED_FIN_TASK_ID,0)

Line 5936: PA_TASKS TS

5932: l_txn_top_task_id_tab,
5933: l_txn_sub_task_id_tab
5934: FROM PA_RESOURCE_ASSIGNMENTS P,
5935: PA_RES_LIST_MAP_TMP4 T,
5936: PA_TASKS TS
5937: WHERE P.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID
5938: AND TS.TASK_ID(+) = NVL(T.TXN_TASK_ID,0)
5939: AND NVL(P.TASK_ID,0) = NVL(TS.TOP_TASK_ID,0)
5940: AND P.PROJECT_ASSIGNMENT_ID = -1

Line 6077: PA_TASKS TS

6073: NVL(V.MAPPED_FIN_TASK_ID,0) mapped_fin_task_id
6074: FROM PA_RESOURCE_ASSIGNMENTS P,
6075: PA_RES_LIST_MAP_TMP4 T,
6076: PA_MAP_WP_TO_FIN_TASKS_V V,
6077: PA_TASKS TS
6078: WHERE P.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID
6079: AND V.PARENT_STRUCTURE_VERSION_ID = P_WP_STRUCTURE_VER_ID
6080: AND t.txn_task_id = v.PROJ_ELEMENT_ID
6081: AND NVL(TS.top_TASK_ID,0) = NVL(p.task_id,0)

Line 7089: pa_projects_all proj, pa_tasks t,

7085: l_cost_res_class_rt_sch_id_tab,
7086:
7087: l_res_format_id_tab
7088: FROM pa_fp_calc_amt_tmp2 tmp, pa_resource_assignments ra,
7089: pa_projects_all proj, pa_tasks t,
7090: pa_proj_fp_options fp,
7091: pa_resource_list_members rlm
7092: WHERE tmp.resource_assignment_id = ra.resource_assignment_id
7093: AND ra.project_id = proj.project_id

Line 7633: pa_projects_all proj, pa_tasks t,

7629: l_cost_res_class_rt_sch_id_tab,
7630:
7631: l_res_format_id_tab
7632: FROM pa_fp_calc_amt_tmp2 tmp, pa_resource_assignments ra,
7633: pa_projects_all proj, pa_tasks t,
7634: pa_proj_fp_options fp,
7635: pa_resource_list_members rlm
7636: WHERE tmp.resource_assignment_id = ra.resource_assignment_id
7637: AND ra.project_id = proj.project_id