[Home] [Help]
2844: l_quantity :=null;
2845: else
2846: begin
2847: /* Bug 5144013 : Changed the following select queries to refer
2848: to new entity pa_resource_asgn_curr instead of pa_budget_lines.
2849: This is done as part of merging the MRUP3 changes done in 11i into R12.
2850:
2851: if p_amount = 'QUANTITY' THEN
2852: select total_display_quantity into l_quantity
2849: This is done as part of merging the MRUP3 changes done in 11i into R12.
2850:
2851: if p_amount = 'QUANTITY' THEN
2852: select total_display_quantity into l_quantity
2853: from pa_resource_asgn_curr rac,
2854: pa_resource_assignments pra
2855: where rac.budget_version_id = l_curr_bv_id
2856: and pra.budget_version_id = rac.budget_version_id
2857: and pra.task_id = p_task_id
2862:
2863: elsif p_amount ='RAW_COST' then
2864:
2865: select total_txn_raw_cost into l_quantity
2866: from pa_resource_asgn_curr rac,
2867: pa_resource_assignments pra
2868: where rac.budget_version_id = l_curr_bv_id
2869: and pra.budget_version_id = rac.budget_version_id
2870: and pra.task_id = p_task_id
2874: and rac.txn_currency_code = p_txn_curr_code;
2875:
2876: elsif p_amount = 'BURDENED_COST' then
2877: select total_txn_burdened_cost into l_quantity
2878: from pa_resource_asgn_curr rac,
2879: pa_resource_assignments pra
2880: where rac.budget_version_id = l_curr_bv_id
2881: and pra.budget_version_id = rac.budget_version_id
2882: and pra.task_id = p_task_id
2885: and pra.resource_assignment_id = rac.resource_assignment_id
2886: and rac.txn_currency_code = p_txn_curr_code;
2887: elsif p_amount = 'REVENUE' then
2888: select total_txn_revenue into l_quantity
2889: from pa_resource_asgn_curr rac,
2890: pa_resource_assignments pra
2891: where rac.budget_version_id = l_curr_bv_id
2892: and pra.budget_version_id = rac.budget_version_id
2893: and pra.task_id = p_task_id
2906: into l_quantity
2907: ,l_txn_raw_cost
2908: ,l_txn_burdened_cost
2909: ,l_txn_revenue
2910: from pa_resource_asgn_curr rac,
2911: pa_resource_assignments pra
2912: where rac.budget_version_id = l_curr_bv_id
2913: and pra.project_id = p_project_id
2914: and pra.budget_version_id = rac.budget_version_id
3063: l_quantity :=null;
3064: else
3065: begin
3066: /* Bug 5144013 : Changed the following select queries to refer
3067: to new entity pa_resource_asgn_curr instead of pa_budget_lines.
3068: This is done as part of merging the MRUP3 changes done in 11i into R12.
3069: */
3070: if p_amount = 'QUANTITY' THEN
3071: select total_display_quantity into l_quantity
3068: This is done as part of merging the MRUP3 changes done in 11i into R12.
3069: */
3070: if p_amount = 'QUANTITY' THEN
3071: select total_display_quantity into l_quantity
3072: from pa_resource_asgn_curr rac,
3073: pa_resource_assignments pra
3074: where rac.budget_version_id = l_orig_bv_id
3075: and pra.budget_version_id = rac.budget_version_id
3076: and pra.task_id = p_task_id
3081:
3082: elsif p_amount ='RAW_COST' then
3083:
3084: select total_txn_raw_cost into l_quantity
3085: from pa_resource_asgn_curr rac,
3086: pa_resource_assignments pra
3087: where rac.budget_version_id = l_orig_bv_id
3088: and pra.budget_version_id = rac.budget_version_id
3089: and pra.task_id = p_task_id
3093: and rac.txn_currency_code = p_txn_curr_code;
3094:
3095: elsif p_amount = 'BURDENED_COST' then
3096: select total_txn_burdened_cost into l_quantity
3097: from pa_resource_asgn_curr rac,
3098: pa_resource_assignments pra
3099: where rac.budget_version_id = l_orig_bv_id
3100: and pra.budget_version_id = rac.budget_version_id
3101: and pra.task_id = p_task_id
3104: and pra.resource_assignment_id = rac.resource_assignment_id
3105: and rac.txn_currency_code = p_txn_curr_code;
3106: elsif p_amount = 'REVENUE' then
3107: select total_txn_revenue into l_quantity
3108: from pa_resource_asgn_curr rac,
3109: pa_resource_assignments pra
3110: where rac.budget_version_id = l_orig_bv_id
3111: and pra.budget_version_id = rac.budget_version_id
3112: and pra.task_id = p_task_id
3203: l_quantity :=null;
3204: else
3205: begin
3206: /* Bug 5144013 : Changed the following select queries to refer
3207: to new entity pa_resource_asgn_curr instead of pa_budget_lines.
3208: This is done as part of merging the MRUP3 changes done in 11i into R12.
3209: */
3210: if p_amount = 'QUANTITY' THEN
3211: select total_display_quantity into l_quantity
3208: This is done as part of merging the MRUP3 changes done in 11i into R12.
3209: */
3210: if p_amount = 'QUANTITY' THEN
3211: select total_display_quantity into l_quantity
3212: from pa_resource_asgn_curr rac,
3213: pa_resource_assignments pra
3214: where rac.budget_version_id = l_pf_bv_id
3215: and pra.budget_version_id = rac.budget_version_id
3216: and pra.task_id = p_task_id
3221:
3222: elsif p_amount ='RAW_COST' then
3223:
3224: select total_txn_raw_cost into l_quantity
3225: from pa_resource_asgn_curr rac,
3226: pa_resource_assignments pra
3227: where rac.budget_version_id = l_pf_bv_id
3228: and pra.budget_version_id = rac.budget_version_id
3229: and pra.task_id = p_task_id
3233: and rac.txn_currency_code = p_txn_curr_code;
3234:
3235: elsif p_amount = 'BURDENED_COST' then
3236: select total_txn_burdened_cost into l_quantity
3237: from pa_resource_asgn_curr rac,
3238: pa_resource_assignments pra
3239: where rac.budget_version_id = l_pf_bv_id
3240: and pra.budget_version_id = rac.budget_version_id
3241: and pra.task_id = p_task_id
3244: and pra.resource_assignment_id = rac.resource_assignment_id
3245: and rac.txn_currency_code = p_txn_curr_code;
3246: elsif p_amount = 'REVENUE' then
3247: select total_txn_revenue into l_quantity
3248: from pa_resource_asgn_curr rac,
3249: pa_resource_assignments pra
3250: where rac.budget_version_id = l_pf_bv_id
3251: and pra.budget_version_id = rac.budget_version_id
3252: and pra.task_id = p_task_id