DBA Data[Home] [Help]

APPS.PA_FP_COPY_ACTUALS_PUB dependencies on PA_FP_CALC_AMT_TMP1

Line 1400: FROM PA_FP_CALC_AMT_TMP1 tmp,

1396: tmp.TARGET_RLM_ID AS RESOURCE_LIST_MEMBER_ID,
1397: PRA.CBS_ELEMENT_ID AS CBS_ELEMENT_ID,
1398: min(tmp.planning_start_date) AS planning_start_date,
1399: max(tmp.planning_end_date) AS planning_end_date
1400: FROM PA_FP_CALC_AMT_TMP1 tmp,
1401: PA_RESOURCE_ASSIGNMENTS PRA
1402: WHERE tmp.RESOURCE_ASSIGNMENT_ID = PRA.RESOURCE_ASSIGNMENT_ID
1403: GROUP BY mapped_fin_task_id,TARGET_RLM_ID,PRA.CBS_ELEMENT_ID) tmp1,
1404: pa_tasks task

Line 1437: FROM PA_FP_CALC_AMT_TMP1 tmp,

1433: tmp.TARGET_RLM_ID AS RESOURCE_LIST_MEMBER_ID,
1434: PRA.CBS_ELEMENT_ID AS CBS_ELEMENT_ID,
1435: min(tmp.planning_start_date) AS planning_start_date,
1436: max(tmp.planning_end_date) AS planning_end_date
1437: FROM PA_FP_CALC_AMT_TMP1 tmp,
1438: PA_RESOURCE_ASSIGNMENTS PRA
1439: WHERE tmp.RESOURCE_ASSIGNMENT_ID = PRA.RESOURCE_ASSIGNMENT_ID
1440: GROUP BY mapped_fin_task_id,TARGET_RLM_ID,PRA.CBS_ELEMENT_ID) tmp1,
1441: pa_tasks task, pa_tasks task_t