DBA Data[Home] [Help]

APPS.PA_FP_CI_MERGE dependencies on PA_PROJ_ELEMENTS_UTILS

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

3935: -- in this cursor might have to be done in src_delta_amt_adj_ra_cur1 also)
3936: CURSOR src_delta_amt_adj_ra_cur
3937: (c_budget_version_id pa_budget_versions.budget_version_id%TYPE)IS
3938: SELECT pra.task_id, pra.resource_list_member_id, pra.resource_assignment_id,
3939: PA_PROJ_ELEMENTS_UTILS.GET_DISPLAY_SEQUENCE(pra.task_id) as dispSeq, rlm.alias
3940: FROM pa_resource_assignments pra, pa_resource_list_members rlm
3941: WHERE pra.budget_version_id = c_budget_version_id
3942: AND rlm.resource_list_member_id = pra.resource_list_member_id
3943: AND EXISTS (SELECT 1

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

3950: --done in src_delta_amt_adj_ra_cur also)
3951: CURSOR src_delta_amt_adj_ra_cur1
3952: (c_budget_version_id pa_budget_versions.budget_version_id%TYPE)IS
3953: SELECT pra.task_id, tmp4.resource_list_member_id, pra.resource_assignment_id,
3954: PA_PROJ_ELEMENTS_UTILS.GET_DISPLAY_SEQUENCE(pra.task_id) as dispSeq, rlm.alias
3955: FROM pa_resource_assignments pra, pa_resource_list_members rlm,pa_res_list_map_tmp4 tmp4
3956: WHERE pra.budget_version_id = c_budget_version_id
3957: AND pra.resource_assignment_id=tmp4.txn_source_id
3958: AND rlm.resource_list_member_id = tmp4.resource_list_member_id