DBA Data[Home] [Help]

APPS.PA_FP_GEN_BILLING_AMOUNTS dependencies on PA_MAP_WP_TO_FIN_TASKS_V

Line 2145: PA_MAP_WP_TO_FIN_TASKS_V V

2141: NVL(T.TXN_TASK_ID,0) txn_task_id ,
2142: NVL(V.MAPPED_FIN_TASK_ID,0) mapped_fin_task_id
2143: FROM PA_RESOURCE_ASSIGNMENTS P,
2144: PA_RES_LIST_MAP_TMP4 T,
2145: PA_MAP_WP_TO_FIN_TASKS_V V
2146: WHERE P.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID
2147: AND V.PARENT_STRUCTURE_VERSION_ID = P_WP_STRUCTURE_VER_ID
2148: AND NVL(T.TXN_TASK_ID,0) = NVL(V.PROJ_ELEMENT_ID,0)
2149: AND P.PROJECT_ASSIGNMENT_ID = -1

Line 2237: PA_MAP_WP_TO_FIN_TASKS_V V,

2233: NVL(T.TXN_TASK_ID,0) txn_task_id,
2234: NVL(V.MAPPED_FIN_TASK_ID,0) mapped_fin_task_id
2235: FROM PA_RESOURCE_ASSIGNMENTS P,
2236: PA_RES_LIST_MAP_TMP4 T,
2237: PA_MAP_WP_TO_FIN_TASKS_V V,
2238: PA_TASKS TS
2239: WHERE P.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID
2240: AND V.PARENT_STRUCTURE_VERSION_ID = P_WP_STRUCTURE_VER_ID
2241: AND t.txn_task_id = v.PROJ_ELEMENT_ID