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_MAP_WP_TO_FIN_TASKS_V

Line 4586: PA_MAP_WP_TO_FIN_TASKS_V V1

4582: NVL(V1.MAPPED_FIN_TASK_VERSION_ID,0) mapped_fin_task_version_id,
4583: MIN(T.TXN_PLANNING_START_DATE) txn_planning_start_date,
4584: MAX(T.TXN_PLANNING_END_DATE) txn_planning_end_date
4585: FROM PA_RES_LIST_MAP_TMP4 T,
4586: PA_MAP_WP_TO_FIN_TASKS_V V1
4587: WHERE NOT EXISTS
4588: (SELECT /*+ INDEX(T,PA_RES_LIST_MAP_TMP4_N1)*/ 1
4589: FROM PA_RESOURCE_ASSIGNMENTS P,PA_MAP_WP_TO_FIN_TASKS_V V
4590: WHERE P.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID

Line 4589: FROM PA_RESOURCE_ASSIGNMENTS P,PA_MAP_WP_TO_FIN_TASKS_V V

4585: FROM PA_RES_LIST_MAP_TMP4 T,
4586: PA_MAP_WP_TO_FIN_TASKS_V V1
4587: WHERE NOT EXISTS
4588: (SELECT /*+ INDEX(T,PA_RES_LIST_MAP_TMP4_N1)*/ 1
4589: FROM PA_RESOURCE_ASSIGNMENTS P,PA_MAP_WP_TO_FIN_TASKS_V V
4590: WHERE P.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID
4591: AND V.PARENT_STRUCTURE_VERSION_ID = P_WP_STRUCTURE_VER_ID
4592: AND nvl(T.TXN_TASK_ID,0) = NVL(V.PROJ_ELEMENT_ID,0)
4593: AND P.PROJECT_ASSIGNMENT_ID = -1

Line 4639: PA_MAP_WP_TO_FIN_TASKS_V V1,

4635: MIN(T.TXN_PLANNING_START_DATE) txn_planning_start_date,
4636: MAX(T.TXN_PLANNING_END_DATE) txn_planning_end_date,
4637: PRA.CBS_ELEMENT_ID cbs_element_id
4638: FROM PA_RES_LIST_MAP_TMP4 T,
4639: PA_MAP_WP_TO_FIN_TASKS_V V1,
4640: PA_RESOURCE_ASSIGNMENTS PRA,
4641: PA_ALTERNATE_TASKS PAT
4642: WHERE NOT EXISTS
4643: (SELECT /*+ INDEX(T,PA_RES_LIST_MAP_TMP4_N1)*/ 1

Line 4644: FROM PA_RESOURCE_ASSIGNMENTS P,PA_MAP_WP_TO_FIN_TASKS_V V

4640: PA_RESOURCE_ASSIGNMENTS PRA,
4641: PA_ALTERNATE_TASKS PAT
4642: WHERE NOT EXISTS
4643: (SELECT /*+ INDEX(T,PA_RES_LIST_MAP_TMP4_N1)*/ 1
4644: FROM PA_RESOURCE_ASSIGNMENTS P,PA_MAP_WP_TO_FIN_TASKS_V V
4645: WHERE P.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID
4646: AND V.PARENT_STRUCTURE_VERSION_ID = P_WP_STRUCTURE_VER_ID
4647: AND nvl(T.TXN_TASK_ID,0) = NVL(V.PROJ_ELEMENT_ID,0)
4648: AND P.PROJECT_ASSIGNMENT_ID = -1

Line 4695: PA_MAP_WP_TO_FIN_TASKS_V V1

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
4699: FROM PA_RESOURCE_ASSIGNMENTS P,PA_TASKS TS,PA_MAP_WP_TO_FIN_TASKS_V V

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 5977: PA_MAP_WP_TO_FIN_TASKS_V V

5973: NVL(T.TXN_TASK_ID,0) txn_task_id ,
5974: NVL(V.MAPPED_FIN_TASK_ID,0) mapped_fin_task_id
5975: FROM PA_RESOURCE_ASSIGNMENTS P,
5976: PA_RES_LIST_MAP_TMP4 T,
5977: PA_MAP_WP_TO_FIN_TASKS_V V
5978: WHERE P.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID
5979: AND V.PARENT_STRUCTURE_VERSION_ID = P_WP_STRUCTURE_VER_ID
5980: AND NVL(T.TXN_TASK_ID,0) = NVL(V.PROJ_ELEMENT_ID,0)
5981: AND P.PROJECT_ASSIGNMENT_ID = -1

Line 6076: PA_MAP_WP_TO_FIN_TASKS_V V,

6072: NVL(T.TXN_TASK_ID,0) txn_task_id,
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