DBA Data[Home] [Help]

APPS.PA_FP_GEN_BUDGET_AMT_PUB dependencies on PA_PROJ_ELEMENTS_UTILS

Line 4689: NVL(pa_proj_elements_utils.get_task_version_id(

4685: CURSOR RES_ASG5 IS
4686: SELECT T.RESOURCE_LIST_MEMBER_ID,
4687: T.CBS_ELEMENT_ID, --bug#16827157
4688: NVL(PAT.TOP_TASK_ID,0),
4689: NVL(pa_proj_elements_utils.get_task_version_id(
4690: v1.MAPPED_FIN_STR_VERSION_ID,pat.top_task_id),0),
4691: MIN(T.TXN_PLANNING_START_DATE),
4692: MAX(T.TXN_PLANNING_END_DATE)
4693: FROM PA_RES_LIST_MAP_TMP4 T,

Line 4714: NVL(pa_proj_elements_utils.get_task_version_id(

4710: AND NVL(T.TXN_TASK_ID,0) > 0
4711: GROUP BY T.RESOURCE_LIST_MEMBER_ID,
4712: T.CBS_ELEMENT_ID, --bug#16827157
4713: NVL(PAT.TOP_TASK_ID,0),
4714: NVL(pa_proj_elements_utils.get_task_version_id(
4715: v1.MAPPED_FIN_STR_VERSION_ID,pat.top_task_id),0)
4716: union
4717: SELECT T.RESOURCE_LIST_MEMBER_ID resource_list_member_id,
4718: T.CBS_ELEMENT_ID, --bug#16827157