[Home] [Help]
151: NVL(ta.billable_flag,'Y') /* Added for ER 4376722 */
152: FROM pa_res_list_map_tmp4 tmp4,
153: pa_budget_lines sbl,
154: pa_resource_assignments ra,
155: pa_tasks ta /* Added for ER 4376722 */
156: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
157: and sbl.budget_version_id = l_source_id
158: and tmp4.txn_resource_assignment_id = ra.resource_assignment_id
159: and ra.budget_version_id = p_budget_version_id
251: NVL(ta.billable_flag,'Y') /* Added for ER 4376722 */
252: FROM pa_res_list_map_tmp4 tmp4,
253: pa_budget_lines sbl,
254: pa_resource_assignments ra,
255: pa_tasks ta /* Added for ER 4376722 */
256: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
257: and sbl.budget_version_id = l_source_id
258: and tmp4.txn_resource_assignment_id = ra.resource_assignment_id
259: and ra.budget_version_id = p_budget_version_id
322: NVL(ta.billable_flag,'Y') /* Added for ER 4376722 */
323: FROM pa_res_list_map_tmp4 tmp4,
324: pa_budget_lines sbl,
325: pa_resource_assignments ra,
326: pa_tasks ta /* Added for ER 4376722 */
327: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
328: and sbl.budget_version_id = l_source_id
329: and tmp4.txn_resource_assignment_id = ra.resource_assignment_id
330: and ra.budget_version_id = p_budget_version_id
2819: avg(sbl.txn_markup_percent) /* Added for Bug 5166047 */
2820: FROM pa_res_list_map_tmp4 tmp4,
2821: pa_budget_lines sbl,
2822: pa_resource_assignments ra,
2823: pa_tasks ta /* Added for ER 4376722 */
2824: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
2825: and sbl.budget_version_id = p_source_bv_id
2826: and tmp4.txn_resource_assignment_id = ra.resource_assignment_id
2827: and ra.budget_version_id = p_target_bv_id
2908: NVL(ta.billable_flag,'Y')
2909: FROM pa_res_list_map_tmp4 tmp4,
2910: pa_budget_lines sbl,
2911: pa_resource_assignments ra,
2912: pa_tasks ta
2913: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
2914: and sbl.budget_version_id = p_source_bv_id
2915: and tmp4.txn_resource_assignment_id = ra.resource_assignment_id
2916: and ra.budget_version_id = p_target_bv_id
3004: avg(sbl.txn_markup_percent) /* Added for Bug 5166047 */
3005: FROM pa_res_list_map_tmp4 tmp4,
3006: pa_budget_lines sbl,
3007: pa_resource_assignments ra,
3008: pa_tasks ta /* Added for ER 4376722 */
3009: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
3010: and sbl.budget_version_id = p_source_bv_id
3011: and tmp4.txn_resource_assignment_id = ra.resource_assignment_id
3012: and ra.budget_version_id = p_target_bv_id
3101: avg(sbl.txn_markup_percent) /* Added for Bug 5166047 */
3102: FROM pa_res_list_map_tmp4 tmp4,
3103: pa_budget_lines sbl,
3104: pa_resource_assignments ra,
3105: pa_tasks ta /* Added for ER 4376722 */
3106: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
3107: and sbl.budget_version_id = p_source_bv_id
3108: and tmp4.txn_resource_assignment_id = ra.resource_assignment_id
3109: and ra.budget_version_id = p_target_bv_id
3716: l_fp_cols_rec_target.x_version_type IN ('REVENUE','ALL') THEN
3717:
3718: DELETE pa_resource_asgn_curr_tmp;
3719:
3720: -- Note: An outer join on pa_tasks is not needed in the query
3721: -- below because we are only interested in updating resources
3722: -- for non-billable tasks. Project-level tasks that require an
3723: -- outer join are always billable.
3724: INSERT INTO pa_resource_asgn_curr_tmp
3735: AND rbc.txn_bill_rate_override IS NOT NULL
3736: AND EXISTS ( SELECT null
3737: FROM pa_res_list_map_tmp4 tmp4,
3738: pa_resource_assignments ra,
3739: pa_tasks ta
3740: WHERE rbc.resource_assignment_id = tmp4.txn_resource_assignment_id
3741: AND tmp4.txn_resource_assignment_id = ra.resource_assignment_id
3742: AND ra.task_id = ta.task_id
3743: AND NVL(ta.billable_flag,'Y') = 'N' );