APPS.PA_FP_CI_MERGE dependencies on PA_RES_LIST_MAP_TMP4

Line 3315: FROM pa_resource_assignments pra, pa_resource_list_members rlm,pa_res_list_map_tmp4 tmp4

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
3319: AND EXISTS (SELECT 1

Line 4234: pa_res_list_map_tmp4 rlmap

4230: pra.sp_fixed_date AS sp_fixed_date, -- Bug 8350296
4231: pra.cbs_element_id AS cbs_element_id --bug#16200605
4232: FROM
4233: pa_resource_assignments pra,
4234: pa_res_list_map_tmp4 rlmap
4235: WHERE
4236: pra.resource_assignment_id=rlmap.txn_source_id)rlmap
4237: WHERE prat.budget_version_id(+)=p_budget_version_id
4238: AND prat.resource_list_member_id(+)=rlmap.resource_list_member_id

Line 5737: ,pa_res_list_map_tmp4 tmp

5733: sum(pbl.revenue) revenue,
5734: DECODE(l_copy_pfc_for_txn_amt_flag,'Y',l_projfunc_currency_code,
5735: DECODE(l_same_multi_curr_flag,'Y', pbl.txn_currency_code,l_project_currency_code)) txn_currency_code
5736: FROM pa_resource_assignments pra
5737: ,pa_res_list_map_tmp4 tmp
5738: ,pa_budget_lines pbl
5739: WHERE pra.resource_assignment_id=tmp.txn_source_id
5740: AND pra.budget_version_id=l_src_ver_id_tbl(j)
5741: AND pbl.resource_assignment_id=pra.resource_assignment_id

Line 6725: pa_res_list_map_tmp4 rlmap

6721: decode(count(pbls.budget_line_id),1,max(pbls.PC_CUR_CONV_REJECTION_CODE),null) pc_cur_conv_rejection_code,
6722: decode(count(pbls.budget_line_id),1,max(pbls.PFC_CUR_CONV_REJECTION_CODE),null) pfc_cur_conv_rejection_code
6723: from pa_budget_lines pbls,
6724: pa_resource_assignments pras,
6725: pa_res_list_map_tmp4 rlmap
6726: where l_ra_dml_code_tbl(kk)='INSERT'
6727: and pras.resource_assignment_id = pbls.resource_assignment_id
6728: and pras.budget_version_id = l_src_ver_id_tbl(j)
6729: AND pras.resource_assignment_id=rlmap.txn_source_id

Line 7538: pa_res_list_map_tmp4 tmp4

7534: (SELECT pra.task_id task_id,
7535: tmp4.resource_list_member_id resource_list_member_id,
7536: tmp4.txn_source_id resource_assignment_id
7537: FROM pa_resource_assignments pra,
7538: pa_res_list_map_tmp4 tmp4
7539: WHERE tmp4.txn_source_id=pra.resource_assignment_id) rlmap
7540: where l_ra_dml_code_tbl(kk)='INSERT'
7541: and rlmap.resource_assignment_id = pbls.resource_assignment_id
7542: and get_mapped_ra_id(get_task_id(l_targ_plan_level_code,rlmap.task_id), rlmap.resource_list_member_id)=L_targ_ra_id_tbl(kk)

Line 8146: pa_res_list_map_tmp4 tmp4,

8142: ,pras.resource_assignment_id
8143: ,pras.task_id
8144: ,tmp4.resource_list_member_id
8145: FROM pa_resource_assignments pras,
8146: pa_res_list_map_tmp4 tmp4,
8147: pa_budget_lines pbls
8148: WHERE tmp4.txn_source_id=pras.resource_assignment_id
8149: AND pbls.resource_assignment_id=pras.resource_assignment_id) pbls
8150: where get_mapped_dml_code(get_task_id(l_targ_plan_level_code,pbls.task_id),pbls.resource_list_member_id)='UPDATE'

Line 8745: pa_res_list_map_tmp4 tmp4,

8741: ,pras.resource_assignment_id
8742: ,pras.task_id
8743: ,tmp4.resource_list_member_id
8744: FROM pa_resource_assignments pras,
8745: pa_res_list_map_tmp4 tmp4,
8746: pa_budget_lines pbls
8747: WHERE tmp4.txn_source_id=pras.resource_assignment_id
8748: AND pbls.resource_assignment_id=pras.resource_assignment_id) pbls
8749: where get_mapped_dml_code(get_task_id(l_targ_plan_level_code,pbls.task_id),pbls.resource_list_member_id)='UPDATE'