eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_CI_MERGE dependencies on PA_RESOURCE_ASSIGNMENTS

Line 36: ,resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE

32: --resource assignment already exists.Bug 3678314
33: TYPE res_assmt_map_rec IS RECORD
34: (task_id pa_tasks.task_id%TYPE
35: ,resource_list_member_id pa_resource_list_members.resource_list_member_id%TYPE
36: ,resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE
37: ,ra_dml_code VARCHAR2(30));
38:
39: TYPE res_assmt_map_rec_tbl_type IS TABLE OF res_assmt_map_rec
40: INDEX BY BINARY_INTEGER;

Line 3294: p_task_id IN pa_resource_assignments.task_id%TYPE)

3290:
3291: -- Start of functions to be used only in implement_ci_into_single_ver API
3292:
3293: FUNCTION get_task_id(p_planning_level IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE,
3294: p_task_id IN pa_resource_assignments.task_id%TYPE)
3295: RETURN NUMBER IS
3296: l_temp NUMBER;
3297: BEGIN
3298: IF P_PA_DEBUG_MODE='Y' THEN

Line 3329: FUNCTION get_mapped_ra_id(p_task_id IN pa_resource_assignments.task_id%TYPE,

3325: END IF;
3326: return l_src_targ_task_tbl(l_temp).value;
3327: END;
3328:
3329: FUNCTION get_mapped_ra_id(p_task_id IN pa_resource_assignments.task_id%TYPE,
3330: p_rlm_id IN pa_resource_assignments.resource_list_member_id%TYPE,
3331: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
3332: p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
3333: )

Line 3330: p_rlm_id IN pa_resource_assignments.resource_list_member_id%TYPE,

3326: return l_src_targ_task_tbl(l_temp).value;
3327: END;
3328:
3329: FUNCTION get_mapped_ra_id(p_task_id IN pa_resource_assignments.task_id%TYPE,
3330: p_rlm_id IN pa_resource_assignments.resource_list_member_id%TYPE,
3331: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
3332: p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
3333: )
3334: RETURN NUMBER IS

Line 3331: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,

3327: END;
3328:
3329: FUNCTION get_mapped_ra_id(p_task_id IN pa_resource_assignments.task_id%TYPE,
3330: p_rlm_id IN pa_resource_assignments.resource_list_member_id%TYPE,
3331: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
3332: p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
3333: )
3334: RETURN NUMBER IS
3335: l_index NUMBER;

Line 3349: FROM pa_resource_assignments

3345: SELECT get_task_id(p_fin_plan_level_code,task_id),
3346: resource_list_member_id
3347: INTO l_task_id,
3348: l_rlm_id
3349: FROM pa_resource_assignments
3350: WHERE resource_assignment_id=p_resource_assignment_id;
3351: END IF;
3352:
3353: l_index := 1;

Line 3373: FUNCTION get_mapped_dml_code(p_task_id IN pa_resource_assignments.task_id%TYPE,

3369:
3370: END IF;
3371: END;
3372:
3373: FUNCTION get_mapped_dml_code(p_task_id IN pa_resource_assignments.task_id%TYPE,
3374: p_rlm_id IN pa_resource_assignments.resource_list_member_id%TYPE,
3375: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
3376: p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
3377:

Line 3374: p_rlm_id IN pa_resource_assignments.resource_list_member_id%TYPE,

3370: END IF;
3371: END;
3372:
3373: FUNCTION get_mapped_dml_code(p_task_id IN pa_resource_assignments.task_id%TYPE,
3374: p_rlm_id IN pa_resource_assignments.resource_list_member_id%TYPE,
3375: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
3376: p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
3377:
3378: )

Line 3375: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,

3371: END;
3372:
3373: FUNCTION get_mapped_dml_code(p_task_id IN pa_resource_assignments.task_id%TYPE,
3374: p_rlm_id IN pa_resource_assignments.resource_list_member_id%TYPE,
3375: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
3376: p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
3377:
3378: )
3379: RETURN VARCHAR2 IS

Line 3395: FROM pa_resource_assignments

3391: SELECT get_task_id(p_fin_plan_level_code,task_id),
3392: resource_list_member_id
3393: INTO l_task_id,
3394: l_rlm_id
3395: FROM pa_resource_assignments
3396: WHERE resource_assignment_id=p_resource_assignment_id;
3397: END IF;
3398:
3399: l_index := 1;

Line 3537: -- Start of tables used to bulk collect and insert into pa_resource_assignments

3533: l_rbs_element_id_prm_tbl_1 system.PA_NUM_TBL_TYPE:= system.PA_NUM_TBL_TYPE();
3534: -- for End bug 5291484
3535:
3536:
3537: -- Start of tables used to bulk collect and insert into pa_resource_assignments
3538: L_TARG_RLM_ID_TBL SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();
3539: L_TARG_RA_ID_TBL SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();
3540: L_RA_DML_CODE_TBL SYSTEM.PA_VARCHAR2_15_TBL_TYPE:= SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
3541: L_targ_task_id_tbl SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();

Line 3581: -- End of tables used to bulk collect and insert into pa_resource_assignments

3577: l_targ_RATE_EXPEND_ORG_ID_tbl SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();
3578: l_targ_INCR_BY_RES_CLS_COD_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3579: l_targ_INCUR_BY_ROLE_ID_tbl SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();
3580:
3581: -- End of tables used to bulk collect and insert into pa_resource_assignments
3582:
3583: --These pl/sql tbls will store the data corresponding to the details such as task_id, rate based flag
3584: --etc of RAs that have got updated. Bug 3678314.
3585: l_upd_ra_task_id_tbl SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();

Line 3726: l_proj_raw_cost pa_resource_assignments.TOTAL_PROJECT_RAW_COST%TYPE;

3722: -- End of variable to be used in Calculate API Call
3723:
3724:
3725:
3726: l_proj_raw_cost pa_resource_assignments.TOTAL_PROJECT_RAW_COST%TYPE;
3727: l_proj_burdened_cost pa_resource_assignments.TOTAL_PROJECT_BURDENED_COST%TYPE;
3728: l_proj_revenue pa_resource_assignments.TOTAL_PROJECT_REVENUE%TYPE;
3729:
3730: l_projfunc_raw_cost pa_resource_assignments.TOTAL_PLAN_RAW_COST%TYPE;

Line 3727: l_proj_burdened_cost pa_resource_assignments.TOTAL_PROJECT_BURDENED_COST%TYPE;

3723:
3724:
3725:
3726: l_proj_raw_cost pa_resource_assignments.TOTAL_PROJECT_RAW_COST%TYPE;
3727: l_proj_burdened_cost pa_resource_assignments.TOTAL_PROJECT_BURDENED_COST%TYPE;
3728: l_proj_revenue pa_resource_assignments.TOTAL_PROJECT_REVENUE%TYPE;
3729:
3730: l_projfunc_raw_cost pa_resource_assignments.TOTAL_PLAN_RAW_COST%TYPE;
3731: l_projfunc_burdened_cost pa_resource_assignments.TOTAL_PLAN_BURDENED_COST%TYPE;

Line 3728: l_proj_revenue pa_resource_assignments.TOTAL_PROJECT_REVENUE%TYPE;

3724:
3725:
3726: l_proj_raw_cost pa_resource_assignments.TOTAL_PROJECT_RAW_COST%TYPE;
3727: l_proj_burdened_cost pa_resource_assignments.TOTAL_PROJECT_BURDENED_COST%TYPE;
3728: l_proj_revenue pa_resource_assignments.TOTAL_PROJECT_REVENUE%TYPE;
3729:
3730: l_projfunc_raw_cost pa_resource_assignments.TOTAL_PLAN_RAW_COST%TYPE;
3731: l_projfunc_burdened_cost pa_resource_assignments.TOTAL_PLAN_BURDENED_COST%TYPE;
3732: l_projfunc_revenue pa_resource_assignments.TOTAL_PLAN_REVENUE%TYPE;

Line 3730: l_projfunc_raw_cost pa_resource_assignments.TOTAL_PLAN_RAW_COST%TYPE;

3726: l_proj_raw_cost pa_resource_assignments.TOTAL_PROJECT_RAW_COST%TYPE;
3727: l_proj_burdened_cost pa_resource_assignments.TOTAL_PROJECT_BURDENED_COST%TYPE;
3728: l_proj_revenue pa_resource_assignments.TOTAL_PROJECT_REVENUE%TYPE;
3729:
3730: l_projfunc_raw_cost pa_resource_assignments.TOTAL_PLAN_RAW_COST%TYPE;
3731: l_projfunc_burdened_cost pa_resource_assignments.TOTAL_PLAN_BURDENED_COST%TYPE;
3732: l_projfunc_revenue pa_resource_assignments.TOTAL_PLAN_REVENUE%TYPE;
3733: l_labor_quantity pa_resource_assignments.TOTAL_PLAN_QUANTITY%TYPE;
3734: l_equip_quantity pa_resource_assignments.TOTAL_PLAN_QUANTITY%TYPE;

Line 3731: l_projfunc_burdened_cost pa_resource_assignments.TOTAL_PLAN_BURDENED_COST%TYPE;

3727: l_proj_burdened_cost pa_resource_assignments.TOTAL_PROJECT_BURDENED_COST%TYPE;
3728: l_proj_revenue pa_resource_assignments.TOTAL_PROJECT_REVENUE%TYPE;
3729:
3730: l_projfunc_raw_cost pa_resource_assignments.TOTAL_PLAN_RAW_COST%TYPE;
3731: l_projfunc_burdened_cost pa_resource_assignments.TOTAL_PLAN_BURDENED_COST%TYPE;
3732: l_projfunc_revenue pa_resource_assignments.TOTAL_PLAN_REVENUE%TYPE;
3733: l_labor_quantity pa_resource_assignments.TOTAL_PLAN_QUANTITY%TYPE;
3734: l_equip_quantity pa_resource_assignments.TOTAL_PLAN_QUANTITY%TYPE;
3735:

Line 3732: l_projfunc_revenue pa_resource_assignments.TOTAL_PLAN_REVENUE%TYPE;

3728: l_proj_revenue pa_resource_assignments.TOTAL_PROJECT_REVENUE%TYPE;
3729:
3730: l_projfunc_raw_cost pa_resource_assignments.TOTAL_PLAN_RAW_COST%TYPE;
3731: l_projfunc_burdened_cost pa_resource_assignments.TOTAL_PLAN_BURDENED_COST%TYPE;
3732: l_projfunc_revenue pa_resource_assignments.TOTAL_PLAN_REVENUE%TYPE;
3733: l_labor_quantity pa_resource_assignments.TOTAL_PLAN_QUANTITY%TYPE;
3734: l_equip_quantity pa_resource_assignments.TOTAL_PLAN_QUANTITY%TYPE;
3735:
3736:

Line 3733: l_labor_quantity pa_resource_assignments.TOTAL_PLAN_QUANTITY%TYPE;

3729:
3730: l_projfunc_raw_cost pa_resource_assignments.TOTAL_PLAN_RAW_COST%TYPE;
3731: l_projfunc_burdened_cost pa_resource_assignments.TOTAL_PLAN_BURDENED_COST%TYPE;
3732: l_projfunc_revenue pa_resource_assignments.TOTAL_PLAN_REVENUE%TYPE;
3733: l_labor_quantity pa_resource_assignments.TOTAL_PLAN_QUANTITY%TYPE;
3734: l_equip_quantity pa_resource_assignments.TOTAL_PLAN_QUANTITY%TYPE;
3735:
3736:
3737:

Line 3734: l_equip_quantity pa_resource_assignments.TOTAL_PLAN_QUANTITY%TYPE;

3730: l_projfunc_raw_cost pa_resource_assignments.TOTAL_PLAN_RAW_COST%TYPE;
3731: l_projfunc_burdened_cost pa_resource_assignments.TOTAL_PLAN_BURDENED_COST%TYPE;
3732: l_projfunc_revenue pa_resource_assignments.TOTAL_PLAN_REVENUE%TYPE;
3733: l_labor_quantity pa_resource_assignments.TOTAL_PLAN_QUANTITY%TYPE;
3734: l_equip_quantity pa_resource_assignments.TOTAL_PLAN_QUANTITY%TYPE;
3735:
3736:
3737:
3738:

Line 3906: l_src_delta_amt_adj_ra_id pa_resource_assignments.resource_assignment_id%TYPE;

3902:
3903: -- Start of variables declared for bug 4035856
3904: l_src_delta_amt_adj_task_id pa_tasks.task_id%TYPE;
3905: l_targ_delta_amt_adj_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
3906: l_src_delta_amt_adj_ra_id pa_resource_assignments.resource_assignment_id%TYPE;
3907: l_src_delta_amt_adj_start_date pa_budget_lines.start_date%TYPE;
3908: l_pc_revenue_delta pa_budget_lines.project_revenue%TYPE;
3909: l_pfc_revenue_delta pa_budget_lines.revenue%TYPE;
3910: l_pc_rev_merged pa_budget_lines.project_revenue%TYPE;

Line 3922: l_rounded_bl_rbf pa_resource_assignments.rate_based_flag%TYPE;

3918: l_impl_quantity pa_fp_merged_ctrl_items.impl_quantity%TYPE;-- bug 4035856
3919: l_agreement_id pa_agreements_all.agreement_id%TYPE;
3920: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE;
3921: l_rounded_bl_id pa_budget_lines.budget_line_id%TYPE;
3922: l_rounded_bl_rbf pa_resource_assignments.rate_based_flag%TYPE;
3923: l_qty_adjusted_flag VARCHAR2(1);
3924: --These variables will be used in calling create_ci_impact_fund_lines
3925: l_impl_pc_rev_amt NUMBER;
3926: l_impl_pfc_rev_amt NUMBER;

Line 3940: FROM pa_resource_assignments pra, pa_resource_list_members rlm

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
3944: FROM pa_budget_lines pbl

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 3967: (c_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE)IS

3963:
3964: -- Cursor to identify against which period/date the adjustment amount should be placed
3965: -- Note that revenue only change orders can have amounts against agreement currency only.
3966: CURSOR src_delta_amt_adj_date_cur
3967: (c_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE)IS
3968: SELECT max(start_date)
3969: FROM pa_budget_lines
3970: WHERE resource_assignment_id = c_resource_assignment_id;
3971:

Line 4811: FROM Pa_resource_assignments prat,

4807: l_targ_unit_of_measure_tbl,
4808: l_targ_rbs_element_id_tbl,
4809: l_targ_txn_accum_header_id_tbl
4810:
4811: FROM Pa_resource_assignments prat,
4812: (SELECT
4813: rlmap.txn_spread_curve_id,
4814: rlmap.txn_etc_method_code,
4815: rlmap.resource_type_code,

Line 4846: pa_resource_assignments pra,

4842: pra.rate_based_flag as rbf,
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

Line 4995: FROM pa_resource_assignments pras,

4991: l_targ_INCUR_BY_ROLE_ID_tbl,
4992: l_targ_RATE_BASED_FLAG_tbl,
4993: l_targ_RES_RATE_BASED_FLAG_tbl, --IPM Arch Enhancement Bug 4865563
4994: l_targ_unit_of_measure_tbl
4995: FROM pa_resource_assignments pras,
4996: Pa_resource_assignments prat
4997: WHERE pras.budget_version_id=l_src_ver_id_tbl(j)
4998: AND prat.budget_version_id(+)=p_budget_version_id
4999: AND prat.resource_list_member_id(+)=pras.resource_list_member_id

Line 4996: Pa_resource_assignments prat

4992: l_targ_RATE_BASED_FLAG_tbl,
4993: l_targ_RES_RATE_BASED_FLAG_tbl, --IPM Arch Enhancement Bug 4865563
4994: l_targ_unit_of_measure_tbl
4995: FROM pa_resource_assignments pras,
4996: Pa_resource_assignments prat
4997: WHERE pras.budget_version_id=l_src_ver_id_tbl(j)
4998: AND prat.budget_version_id(+)=p_budget_version_id
4999: AND prat.resource_list_member_id(+)=pras.resource_list_member_id
5000: AND prat.task_id(+)=get_task_id(l_targ_plan_level_code,pras.task_id)

Line 5038: SELECT pa_resource_assignments_s.nextval

5034: so that it will be easy later to identify the resource assignment id corresponding to the given task id
5035: and resource list member id*/
5036: FOR ind IN L_targ_ra_id_tbl.FIRST..L_targ_ra_id_tbl.LAST LOOP
5037: IF L_targ_ra_id_tbl(ind) IS NULL THEN
5038: SELECT pa_resource_assignments_s.nextval
5039: INTO L_targ_ra_id_tbl(ind)
5040: FROM dual;
5041: END IF;
5042: l_res_assmt_map_rec_tbl(ind).task_id:=l_targ_task_id_tbl(ind);

Line 5929: INSERT INTO PA_RESOURCE_ASSIGNMENTS (

5925: -- 1) If p_calling_context is null, insert transaction source code as null
5926: -- 2) If p_calling_context is generation insert transaction source code as 'CHANGE DOCUMENTS'
5927:
5928: FORALL kk in L_targ_ra_id_tbl.FIRST ..L_targ_ra_id_tbl.LAST
5929: INSERT INTO PA_RESOURCE_ASSIGNMENTS (
5930: RESOURCE_ASSIGNMENT_ID,BUDGET_VERSION_ID,PROJECT_ID,TASK_ID,RESOURCE_LIST_MEMBER_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY
5931: ,LAST_UPDATE_LOGIN,UNIT_OF_MEASURE,TRACK_AS_LABOR_FLAG,STANDARD_BILL_RATE,AVERAGE_BILL_RATE,AVERAGE_COST_RATE
5932: ,PROJECT_ASSIGNMENT_ID,PLAN_ERROR_CODE,TOTAL_PLAN_REVENUE,TOTAL_PLAN_RAW_COST,TOTAL_PLAN_BURDENED_COST,TOTAL_PLAN_QUANTITY
5933: ,AVERAGE_DISCOUNT_PERCENTAGE,TOTAL_BORROWED_REVENUE,TOTAL_TP_REVENUE_IN,TOTAL_TP_REVENUE_OUT,TOTAL_REVENUE_ADJ

Line 6096: UPDATE pa_resource_assignments pra

6092: -- Howeever, in oracle 8i select can not be used inside a decode. So, two sqls are used for better performance
6093: -- Bug 4171006: Updating UOM and rate_based_flag as well with the values already derived.
6094: IF p_calling_context IN ('BUDGET_GENERATION','FORECAST_GENERATION') THEN
6095: FORALL kk IN L_targ_ra_id_tbl.FIRST ..L_targ_ra_id_tbl.LAST
6096: UPDATE pa_resource_assignments pra
6097: SET PLANNING_START_DATE = l_planning_start_date_tbl(kk),
6098: PLANNING_END_DATE = l_planning_end_date_tbl(kk),
6099: UNIT_OF_MEASURE = l_targ_unit_of_measure_tbl(kk), -- bug 4171006
6100: TRANSACTION_SOURCE_CODE =

Line 6125: UPDATE pa_resource_assignments pra

6121: l_upd_ra_rbf_tbl,
6122: l_upd_ra_res_asmt_id_tbl;
6123: ELSE
6124: FORALL kk IN L_targ_ra_id_tbl.FIRST ..L_targ_ra_id_tbl.LAST
6125: UPDATE pa_resource_assignments pra
6126: SET PLANNING_START_DATE = l_planning_start_date_tbl(kk),
6127: PLANNING_END_DATE = l_planning_end_date_tbl(kk),
6128: UNIT_OF_MEASURE = l_targ_unit_of_measure_tbl(kk), -- bug 4171006
6129: TRANSACTION_SOURCE_CODE = null,

Line 6244: pa_resource_assignments pra

6240: sum(pbl.revenue) revenue,
6241: DECODE(l_copy_pfc_for_txn_amt_flag,'Y',l_projfunc_currency_code,
6242: DECODE(l_same_multi_curr_flag,'Y', pbl.txn_currency_code,l_project_currency_code)) txn_currency_code
6243: FROM pa_budget_lines pbl,
6244: pa_resource_assignments pra
6245: WHERE pbl.resource_assignment_id = pra.resource_assignment_id
6246: AND pra.budget_version_id=l_src_ver_id_tbl(j)
6247: GROUP BY pra.resource_assignment_id, pra.task_id, pra.resource_list_member_id,
6248: DECODE(l_copy_pfc_for_txn_amt_flag,'Y',l_projfunc_currency_code,

Line 6336: FROM pa_resource_assignments pra

6332: sum(pbl.burdened_cost) burdened_cost,
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)

Line 6921: pa_resource_assignments pras

6917:
6918: decode(count(pbls.budget_line_id),1,max(pbls.PC_CUR_CONV_REJECTION_CODE),null) pc_cur_conv_rejection_code,
6919: decode(count(pbls.budget_line_id),1,max(pbls.PFC_CUR_CONV_REJECTION_CODE),null) pfc_cur_conv_rejection_code
6920: from pa_budget_lines pbls,
6921: pa_resource_assignments pras
6922: where l_ra_dml_code_tbl(kk)='INSERT'
6923: and pras.resource_assignment_id = pbls.resource_assignment_id
6924: and pras.budget_version_id = l_src_ver_id_tbl(j)
6925: and PA_FP_CI_MERGE.get_mapped_ra_id(PA_FP_CI_MERGE.get_task_id(l_targ_plan_level_code,pras.task_id), pras.resource_list_member_id)= L_targ_ra_id_tbl(kk)

Line 7324: pa_resource_assignments pras,

7320:
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)

Line 7731: pa_resource_assignments pras

7727:
7728: decode(count(pbls.budget_line_id),1,max(pbls.PC_CUR_CONV_REJECTION_CODE),null) pc_cur_conv_rejection_code,
7729: decode(count(pbls.budget_line_id),1,max(pbls.PFC_CUR_CONV_REJECTION_CODE),null) pfc_cur_conv_rejection_code
7730: from pa_budget_lines pbls,
7731: pa_resource_assignments pras
7732: where l_ra_dml_code_tbl(kk)='INSERT'
7733: and pras.budget_version_id = l_src_ver_id_tbl(j)
7734: and pras.resource_assignment_id = pbls.resource_assignment_id
7735: and get_mapped_ra_id(get_task_id(l_targ_plan_level_code,pras.task_id), pras.resource_list_member_id)=L_targ_ra_id_tbl(kk)

Line 8137: FROM pa_resource_assignments pra,

8133: from pa_budget_lines pbls,
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

Line 8391: pa_resource_assignments prat

8387: l_bl_PC_CUR_CONV_REJ_CODE_tbl,
8388: l_bl_PFC_CUR_CONV_REJ_CODE_tbl
8389: from pa_budget_lines pbls,
8390: pa_budget_lines pblt,
8391: pa_resource_assignments prat
8392: where get_mapped_dml_code(null,null,pbls.resource_assignment_id,l_targ_plan_level_code)='UPDATE'
8393: and pbls.budget_version_id = l_src_ver_id_tbl(j)
8394: and pblt.budget_version_id(+) = p_budget_version_id
8395: and pblt.resource_assignment_id(+)=get_mapped_ra_id(null,null,pbls.resource_assignment_id,l_targ_plan_level_code)

Line 8640: pa_resource_assignments prat,

8636: l_bl_BURDEN_COST_RAT_OVRID_tbl,
8637: l_bl_PC_CUR_CONV_REJ_CODE_tbl,
8638: l_bl_PFC_CUR_CONV_REJ_CODE_tbl
8639: from pa_budget_lines pblt,
8640: pa_resource_assignments prat,
8641: (SELECT pbls.resource_assignment_id
8642: ,pbls.start_date
8643: ,pbls.last_update_date
8644: ,pbls.last_updated_by

Line 8745: FROM pa_resource_assignments pras,

8741: ,pbls.pfc_cur_conv_rejection_code
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

Line 9344: FROM pa_resource_assignments pras,

9340: ,pbls.pfc_cur_conv_rejection_code
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

Line 10002: FROM pa_resource_assignments pra,

9998: IF l_qty_adjusted_flag = 'N' THEN
9999:
10000: SELECT pra.rate_based_flag
10001: INTO l_rounded_bl_rbf
10002: FROM pa_resource_assignments pra,
10003: pa_budget_lines pbl
10004: WHERE pra.resource_assignment_id = pbl.resource_assignment_id
10005: AND pbl.budget_line_id = l_rounded_bl_id;
10006:

Line 10159: FROM pa_resource_assignments pra,

10155: l_pji_prm_task_id_tbl,
10156: l_pji_prm_rbs_elem_id_tbl,
10157: l_pji_prm_res_cls_code_tbl,
10158: l_pji_prm_rbf_tbl
10159: FROM pa_resource_assignments pra,
10160: pa_budget_lines pbl
10161: WHERE pra.resource_assignment_id = pbl.resource_assignment_id
10162: AND (pbl.budget_line_id BETWEEN l_id_before_bl_insertion AND l_id_after_bl_insertion)
10163: AND pra.budget_Version_id=p_budget_version_id;