APPS.PA_FP_CI_MERGE dependencies on PA_RES_LIST_MAP_TMP4

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

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

Line 4847: pa_res_list_map_tmp4 rlmap

4843: pra.resource_rate_based_flag as rrbf, --IPM Arch Enhancement
4844: pra.unit_of_measure as uom
4845: FROM
4846: pa_resource_assignments pra,
4847: pa_res_list_map_tmp4 rlmap
4848: WHERE
4849: pra.resource_assignment_id=rlmap.txn_source_id)rlmap
4850: WHERE prat.budget_version_id(+)=p_budget_version_id
4851: AND prat.resource_list_member_id(+)=rlmap.resource_list_member_id

Line 6337: ,pa_res_list_map_tmp4 tmp

6333: sum(pbl.revenue) revenue,
6334: DECODE(l_copy_pfc_for_txn_amt_flag,'Y',l_projfunc_currency_code,
6335: DECODE(l_same_multi_curr_flag,'Y', pbl.txn_currency_code,l_project_currency_code)) txn_currency_code
6336: FROM pa_resource_assignments pra
6337: ,pa_res_list_map_tmp4 tmp
6338: ,pa_budget_lines pbl
6339: WHERE pra.resource_assignment_id=tmp.txn_source_id
6340: AND pra.budget_version_id=l_src_ver_id_tbl(j)
6341: AND pbl.resource_assignment_id=pra.resource_assignment_id

Line 7325: pa_res_list_map_tmp4 rlmap

7321: decode(count(pbls.budget_line_id),1,max(pbls.PC_CUR_CONV_REJECTION_CODE),null) pc_cur_conv_rejection_code,
7322: decode(count(pbls.budget_line_id),1,max(pbls.PFC_CUR_CONV_REJECTION_CODE),null) pfc_cur_conv_rejection_code
7323: from pa_budget_lines pbls,
7324: pa_resource_assignments pras,
7325: pa_res_list_map_tmp4 rlmap
7326: where l_ra_dml_code_tbl(kk)='INSERT'
7327: and pras.resource_assignment_id = pbls.resource_assignment_id
7328: and pras.budget_version_id = l_src_ver_id_tbl(j)
7329: AND pras.resource_assignment_id=rlmap.txn_source_id

Line 8138: pa_res_list_map_tmp4 tmp4

8134: (SELECT pra.task_id task_id,
8135: tmp4.resource_list_member_id resource_list_member_id,
8136: tmp4.txn_source_id resource_assignment_id
8137: FROM pa_resource_assignments pra,
8138: pa_res_list_map_tmp4 tmp4
8139: WHERE tmp4.txn_source_id=pra.resource_assignment_id) rlmap
8140: where l_ra_dml_code_tbl(kk)='INSERT'
8141: and rlmap.resource_assignment_id = pbls.resource_assignment_id
8142: 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 8746: pa_res_list_map_tmp4 tmp4,

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

Line 9345: pa_res_list_map_tmp4 tmp4,

9341: ,pras.resource_assignment_id
9342: ,pras.task_id
9343: ,tmp4.resource_list_member_id
9344: FROM pa_resource_assignments pras,
9345: pa_res_list_map_tmp4 tmp4,
9346: pa_budget_lines pbls
9347: WHERE tmp4.txn_source_id=pras.resource_assignment_id
9348: AND pbls.resource_assignment_id=pras.resource_assignment_id) pbls
9349: where get_mapped_dml_code(get_task_id(l_targ_plan_level_code,pbls.task_id),pbls.resource_list_member_id)='UPDATE'