DBA Data[Home] [Help]

APPS.PA_FP_GEN_BUDGET_AMT_PUB dependencies on PA_PROJ_ELEMENTS_UTILS

Line 4531: NVL(pa_proj_elements_utils.get_task_version_id(

4527: (both Financial task and Workplan task)*/
4528: CURSOR RES_ASG5 IS
4529: SELECT T.RESOURCE_LIST_MEMBER_ID,
4530: NVL(PAT.TOP_TASK_ID,0),
4531: NVL(pa_proj_elements_utils.get_task_version_id(
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,

Line 4554: NVL(pa_proj_elements_utils.get_task_version_id(

4550: AND NVL(T.TXN_TASK_ID,0) = NVL(V1.PROJ_ELEMENT_ID,0)
4551: AND NVL(T.TXN_TASK_ID,0) > 0
4552: GROUP BY T.RESOURCE_LIST_MEMBER_ID,
4553: NVL(PAT.TOP_TASK_ID,0),
4554: NVL(pa_proj_elements_utils.get_task_version_id(
4555: v1.MAPPED_FIN_STR_VERSION_ID,pat.top_task_id),0)
4556: union
4557: SELECT T.RESOURCE_LIST_MEMBER_ID resource_list_member_id,
4558: 0,