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 4448: PA_TASKS PAT

4444: NVL(PAT.TOP_TASK_ID,0),
4445: MIN(T.TXN_PLANNING_START_DATE),
4446: MAX(T.TXN_PLANNING_END_DATE)
4447: FROM PA_RES_LIST_MAP_TMP4 T,
4448: PA_TASKS PAT
4449: WHERE NVL(T.TXN_TASK_ID,0) > 0
4450: AND NVL(T.TXN_TASK_ID,0) = PAT.TASK_ID
4451: AND NOT EXISTS
4452: (SELECT /*+ INDEX(T,PA_RES_LIST_MAP_TMP4_N1)*/ 1

Line 4453: FROM PA_RESOURCE_ASSIGNMENTS P,PA_TASKS TS

4449: WHERE NVL(T.TXN_TASK_ID,0) > 0
4450: AND NVL(T.TXN_TASK_ID,0) = PAT.TASK_ID
4451: AND NOT EXISTS
4452: (SELECT /*+ INDEX(T,PA_RES_LIST_MAP_TMP4_N1)*/ 1
4453: FROM PA_RESOURCE_ASSIGNMENTS P,PA_TASKS TS
4454: WHERE P.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID
4455: AND NVL(T.TXN_TASK_ID,0) > 0
4456: AND TS.TASK_ID = NVL(T.TXN_TASK_ID,0)
4457: AND NVL(TS.TOP_TASK_ID,0) = NVL(P.TASK_ID,0)

Line 4536: PA_TASKS PAT,

4532: v1.MAPPED_FIN_STR_VERSION_ID,pat.top_task_id),0),
4533: MIN(T.TXN_PLANNING_START_DATE),
4534: MAX(T.TXN_PLANNING_END_DATE)
4535: FROM PA_RES_LIST_MAP_TMP4 T,
4536: PA_TASKS PAT,
4537: PA_MAP_WP_TO_FIN_TASKS_V V1
4538: WHERE NVL(V1.MAPPED_FIN_TASK_ID,0) = PAT.TASK_ID (+)
4539: AND NOT EXISTS
4540: (SELECT /*+ INDEX(T,PA_RES_LIST_MAP_TMP4_N1)*/ 1

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

4537: PA_MAP_WP_TO_FIN_TASKS_V V1
4538: WHERE NVL(V1.MAPPED_FIN_TASK_ID,0) = PAT.TASK_ID (+)
4539: AND NOT EXISTS
4540: (SELECT /*+ INDEX(T,PA_RES_LIST_MAP_TMP4_N1)*/ 1
4541: FROM PA_RESOURCE_ASSIGNMENTS P,PA_TASKS TS,PA_MAP_WP_TO_FIN_TASKS_V V
4542: WHERE P.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID
4543: AND V.PARENT_STRUCTURE_VERSION_ID = P_WP_STRUCTURE_VER_ID
4544: AND NVL(T.TXN_TASK_ID,0) = NVL(V.PROJ_ELEMENT_ID,0)
4545: AND TS.TASK_ID(+) = NVL(V.MAPPED_FIN_TASK_ID,0)

Line 5295: PA_TASKS TS

5291: l_txn_top_task_id_tab,
5292: l_txn_sub_task_id_tab
5293: FROM PA_RESOURCE_ASSIGNMENTS P,
5294: PA_RES_LIST_MAP_TMP4 T,
5295: PA_TASKS TS
5296: WHERE P.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID
5297: AND TS.TASK_ID(+) = NVL(T.TXN_TASK_ID,0)
5298: AND NVL(P.TASK_ID,0) = NVL(TS.TOP_TASK_ID,0)
5299: AND P.PROJECT_ASSIGNMENT_ID = -1

Line 5424: PA_TASKS TS

5420: NVL(V.MAPPED_FIN_TASK_ID,0) mapped_fin_task_id
5421: FROM PA_RESOURCE_ASSIGNMENTS P,
5422: PA_RES_LIST_MAP_TMP4 T,
5423: PA_MAP_WP_TO_FIN_TASKS_V V,
5424: PA_TASKS TS
5425: WHERE P.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID
5426: AND V.PARENT_STRUCTURE_VERSION_ID = P_WP_STRUCTURE_VER_ID
5427: AND t.txn_task_id = v.PROJ_ELEMENT_ID
5428: AND NVL(TS.top_TASK_ID,0) = NVL(p.task_id,0)

Line 6432: pa_projects_all proj, pa_tasks t,

6428: l_cost_res_class_rt_sch_id_tab,
6429:
6430: l_res_format_id_tab
6431: FROM pa_fp_calc_amt_tmp2 tmp, pa_resource_assignments ra,
6432: pa_projects_all proj, pa_tasks t,
6433: pa_proj_fp_options fp,
6434: pa_resource_list_members rlm
6435: WHERE tmp.resource_assignment_id = ra.resource_assignment_id
6436: AND ra.project_id = proj.project_id

Line 6976: pa_projects_all proj, pa_tasks t,

6972: l_cost_res_class_rt_sch_id_tab,
6973:
6974: l_res_format_id_tab
6975: FROM pa_fp_calc_amt_tmp2 tmp, pa_resource_assignments ra,
6976: pa_projects_all proj, pa_tasks t,
6977: pa_proj_fp_options fp,
6978: pa_resource_list_members rlm
6979: WHERE tmp.resource_assignment_id = ra.resource_assignment_id
6980: AND ra.project_id = proj.project_id