[Home] [Help]
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)
1653: AND p_item_date
1654: BETWEEN j.start_date_active
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
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
1739: AND NVL(j.end_date_active + 0.99999,p_item_date + 0.99999)
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'
2171: -- AND pa.assignment_type = 'E'