DBA Data[Home] [Help]

APPS.PA_FP_CI_MERGE dependencies on PA_PROJ_ELEMENTS_UTILS

Line 3299: PA_PROJ_ELEMENTS_UTILS.GET_DISPLAY_SEQUENCE(pra.task_id) as dispSeq, rlm.alias

3295: -- in this cursor might have to be done in src_delta_amt_adj_ra_cur1 also)
3296: CURSOR src_delta_amt_adj_ra_cur
3297: (c_budget_version_id pa_budget_versions.budget_version_id%TYPE)IS
3298: SELECT pra.task_id, pra.resource_list_member_id, pra.resource_assignment_id,
3299: PA_PROJ_ELEMENTS_UTILS.GET_DISPLAY_SEQUENCE(pra.task_id) as dispSeq, rlm.alias
3300: FROM pa_resource_assignments pra, pa_resource_list_members rlm
3301: WHERE pra.budget_version_id = c_budget_version_id
3302: AND rlm.resource_list_member_id = pra.resource_list_member_id
3303: AND EXISTS (SELECT 1

Line 3314: PA_PROJ_ELEMENTS_UTILS.GET_DISPLAY_SEQUENCE(pra.task_id) as dispSeq, rlm.alias

3310: --done in src_delta_amt_adj_ra_cur also)
3311: CURSOR src_delta_amt_adj_ra_cur1
3312: (c_budget_version_id pa_budget_versions.budget_version_id%TYPE)IS
3313: SELECT pra.task_id, tmp4.resource_list_member_id, pra.resource_assignment_id,
3314: PA_PROJ_ELEMENTS_UTILS.GET_DISPLAY_SEQUENCE(pra.task_id) as dispSeq, rlm.alias
3315: FROM pa_resource_assignments pra, pa_resource_list_members rlm,pa_res_list_map_tmp4 tmp4
3316: WHERE pra.budget_version_id = c_budget_version_id
3317: AND pra.resource_assignment_id=tmp4.txn_source_id
3318: AND rlm.resource_list_member_id = tmp4.resource_list_member_id