[Home] [Help]
186: NVL(ta.billable_flag,'Y') /* Added for ER 4376722 */
187: FROM pa_res_list_map_tmp4 tmp4,
188: pa_budget_lines sbl,
189: pa_resource_assignments ra,
190: pa_tasks ta /* Added for ER 4376722 */
191: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
192: and sbl.budget_version_id = l_source_id
193: and tmp4.txn_resource_assignment_id = ra.resource_assignment_id
194: and ra.budget_version_id = p_budget_version_id
286: NVL(ta.billable_flag,'Y') /* Added for ER 4376722 */
287: FROM pa_res_list_map_tmp4 tmp4,
288: pa_budget_lines sbl,
289: pa_resource_assignments ra,
290: pa_tasks ta /* Added for ER 4376722 */
291: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
292: and sbl.budget_version_id = l_source_id
293: and tmp4.txn_resource_assignment_id = ra.resource_assignment_id
294: and ra.budget_version_id = p_budget_version_id
357: NVL(ta.billable_flag,'Y') /* Added for ER 4376722 */
358: FROM pa_res_list_map_tmp4 tmp4,
359: pa_budget_lines sbl,
360: pa_resource_assignments ra,
361: pa_tasks ta /* Added for ER 4376722 */
362: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
363: and sbl.budget_version_id = l_source_id
364: and tmp4.txn_resource_assignment_id = ra.resource_assignment_id
365: and ra.budget_version_id = p_budget_version_id
2896: avg(sbl.txn_markup_percent) /* Added for Bug 5166047 */
2897: FROM pa_res_list_map_tmp4 tmp4,
2898: pa_budget_lines sbl,
2899: pa_resource_assignments ra,
2900: pa_tasks ta /* Added for ER 4376722 */
2901: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
2902: and sbl.budget_version_id = p_source_bv_id
2903: and tmp4.txn_resource_assignment_id = ra.resource_assignment_id
2904: and ra.budget_version_id = p_target_bv_id
2986: avg(sbl.txn_markup_percent) -- Bug #13552225
2987: FROM pa_res_list_map_tmp4 tmp4,
2988: pa_budget_lines sbl,
2989: pa_resource_assignments ra,
2990: pa_tasks ta
2991: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
2992: and sbl.budget_version_id = p_source_bv_id
2993: and tmp4.txn_resource_assignment_id = ra.resource_assignment_id
2994: and ra.budget_version_id = p_target_bv_id
3082: avg(sbl.txn_markup_percent) /* Added for Bug 5166047 */
3083: FROM pa_res_list_map_tmp4 tmp4,
3084: pa_budget_lines sbl,
3085: pa_resource_assignments ra,
3086: pa_tasks ta /* Added for ER 4376722 */
3087: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
3088: and sbl.budget_version_id = p_source_bv_id
3089: and tmp4.txn_resource_assignment_id = ra.resource_assignment_id
3090: and ra.budget_version_id = p_target_bv_id
3179: avg(sbl.txn_markup_percent) /* Added for Bug 5166047 */
3180: FROM pa_res_list_map_tmp4 tmp4,
3181: pa_budget_lines sbl,
3182: pa_resource_assignments ra,
3183: pa_tasks ta /* Added for ER 4376722 */
3184: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
3185: and sbl.budget_version_id = p_source_bv_id
3186: and tmp4.txn_resource_assignment_id = ra.resource_assignment_id
3187: and ra.budget_version_id = p_target_bv_id
3794: l_fp_cols_rec_target.x_version_type IN ('REVENUE','ALL') THEN
3795:
3796: DELETE pa_resource_asgn_curr_tmp;
3797:
3798: -- Note: An outer join on pa_tasks is not needed in the query
3799: -- below because we are only interested in updating resources
3800: -- for non-billable tasks. Project-level tasks that require an
3801: -- outer join are always billable.
3802: INSERT INTO pa_resource_asgn_curr_tmp
3813: AND rbc.txn_bill_rate_override IS NOT NULL
3814: AND EXISTS ( SELECT null
3815: FROM pa_res_list_map_tmp4 tmp4,
3816: pa_resource_assignments ra,
3817: pa_tasks ta
3818: WHERE rbc.resource_assignment_id = tmp4.txn_resource_assignment_id
3819: AND tmp4.txn_resource_assignment_id = ra.resource_assignment_id
3820: AND ra.task_id = ta.task_id
3821: AND NVL(ta.billable_flag,'Y') = 'N' );