[Home] [Help]
1644: j.discount_percentage
1645: INTO l_bill_rate,l_raw_revenue,l_rate_currency_code,
1646: l_amount_calculation_code,
1647: l_discount_percentage
1648: FROM per_assignments_f a, /* Bug 6058676 : Removed per_assignments_f and related joins *//*uncommented for 9257637 */
1649: pa_job_bill_rate_overrides j
1650: -- Bug 4398492 query made to refer base table per_all_assignments_f
1651: -- (0 * a.person_id) is used to make assignments as the driving table
1652: WHERE j.task_id = p_task_id + (0 * a.person_id)
1730: INTO l_bill_rate,l_raw_revenue,
1731: l_rate_currency_code,
1732: l_amount_calculation_code,
1733: l_discount_percentage
1734: FROM pa_job_bill_rate_overrides j , per_all_assignments_f a /* Bug 6058676: Removed per_assignments_f and related predicates*//*uncommented for bug 9257637 */
1735: -- Bug 4398492 query made to refer base table per_all_assignments_f
1736: WHERE j.project_id = p_project_id + (0 * a.person_id)
1737: AND p_item_date + 0.99999
1738: BETWEEN j.start_date_active
1757: END;
1758:
1759: ELSIF ( l_raw_revenue IS NULL AND l_bill_rate IS NULL
1760: and l_discount_percentage is null and l_called_process = 1) THEN /*Bug3737994 2 to 1*/
1761: /*Bug3737994 commented the code reference to per_assignments_f and added p_resource_job_id*/
1762: BEGIN
1763: SELECT j.rate * NVL(p_bill_rate_multiplier,1),
1764: PA_CURRENCY.ROUND_CURRENCY_AMT(j.rate * NVL(p_bill_rate_multiplier,1) * p_quantity),
1765: j.rate_currency_code,
1768: INTO l_bill_rate,l_raw_revenue,
1769: l_rate_currency_code,
1770: l_amount_calculation_code,
1771: l_discount_percentage
1772: FROM pa_job_bill_rate_overrides j--, per_assignments_f a
1773: WHERE j.project_id = p_project_id --+ (0 * a.person_id)
1774: AND p_item_date + 0.99999
1775: BETWEEN j.start_date_active
1776: AND NVL(j.end_date_active + 0.99999,p_item_date + 0.99999)
2162: INTO l_bill_rate,l_raw_revenue,
2163: l_rate_currency_code,
2164: l_amount_calculation_code,
2165: l_discount_percentage
2166: FROM pa_bill_rates_all b -- per_assignments_f pa Commented for Bug 4398492 query made to refer base table
2167: , per_all_assignments_f pa
2168: WHERE b.bill_rate_sch_id = l_job_bill_rate_schedule_id
2169: AND pa.person_id = p_person_id
2170: AND pa.primary_flag = 'Y'