[Home] [Help]
434: j.discount_percentage
435: INTO l_bill_rate,l_raw_revenue,
436: l_rate_currency_code ,-- Added for MCB2
437: l_discount_pct
438: FROM pa_job_bill_rate_overrides j
439: WHERE j.task_id = p_task_id
440: AND TO_DATE(p_item_date)
441: BETWEEN TO_DATE(j.start_date_active)
442: AND NVL(TO_DATE(j.end_date_active),
519: INTO l_bill_rate,
520: l_raw_revenue,
521: l_rate_currency_code, /* Added for MCB2 */
522: l_discount_pct /* Added for discount percentage*/
523: FROM pa_job_bill_rate_overrides j
524: WHERE j.project_id = p_project_id
525: /* 0.99999 added to the dates so that the starting clause of
526: the between condition does not have aby function on it so
527: as to better use the index */
1442: INTO l_bill_rate,l_raw_revenue,
1443: l_rate_currency_code,
1444: l_amount_calculation_code,
1445: l_discount_percentage
1446: FROM pa_job_assignment_overrides a, pa_job_bill_rate_overrides j
1447: WHERE j.task_id = p_task_id
1448: AND p_item_date
1449: BETWEEN j.start_date_active
1450: AND NVL(j.end_date_active,p_item_date)
1487: decode(j.discount_percentage,NULL,'O','T'),
1488: j.discount_percentage
1489: INTO l_bill_rate,l_raw_revenue,l_rate_currency_code,
1490: l_amount_calculation_code,l_discount_percentage
1491: FROM pa_job_assignment_overrides a, pa_job_bill_rate_overrides j
1492: WHERE j.project_id = p_project_id
1493: AND p_item_date
1494: BETWEEN j.start_date_active
1495: AND NVL(j.end_date_active,p_item_date)
1531: decode(j.discount_percentage,NULL,'O','P'),
1532: j.discount_percentage
1533: INTO l_bill_rate,l_raw_revenue,l_rate_currency_code,
1534: l_amount_calculation_code,l_discount_percentage
1535: FROM pa_job_assignment_overrides a, pa_job_bill_rate_overrides j
1536: WHERE j.task_id = p_task_id
1537: AND p_item_date
1538: BETWEEN j.start_date_active
1539: AND NVL(j.end_date_active,
1578: INTO l_bill_rate,l_raw_revenue,
1579: l_rate_currency_code,
1580: l_amount_calculation_code,
1581: l_discount_percentage
1582: FROM pa_job_assignment_overrides a, pa_job_bill_rate_overrides j
1583: WHERE j.project_id = p_project_id
1584: AND p_item_date
1585: BETWEEN j.start_date_active
1586: AND NVL(j.end_date_active,p_item_date)
1626: INTO l_bill_rate,l_raw_revenue,l_rate_currency_code,
1627: l_amount_calculation_code,
1628: l_discount_percentage
1629: FROM -- per_assignments_f a, /* Bug 6058676 : Removed per_assignments_f and related joins */
1630: pa_job_bill_rate_overrides j
1631: -- Bug 4398492 query made to refer base table per_all_assignments_f
1632: -- (0 * a.person_id) is used to make assignments as the driving table
1633: WHERE j.task_id = p_task_id -- + (0 * a.person_id)
1634: AND p_item_date
1669: j.discount_percentage
1670: INTO l_bill_rate,l_raw_revenue,l_rate_currency_code,
1671: l_amount_calculation_code,
1672: l_discount_percentage
1673: FROM pa_job_bill_rate_overrides j
1674: WHERE j.task_id = p_task_id
1675: AND j.job_id = pa_cross_business_grp.IsmappedTojob(p_resource_job_id,l_bill_job_grp_id) /* Bug 6058676 */ /*bug3737994*/
1676: AND p_item_date
1677: BETWEEN j.start_date_active
1711: INTO l_bill_rate,l_raw_revenue,
1712: l_rate_currency_code,
1713: l_amount_calculation_code,
1714: l_discount_percentage
1715: FROM pa_job_bill_rate_overrides j --, per_all_assignments_f a /* Bug 6058676: Removed per_assignments_f and related predicates*/
1716: -- Bug 4398492 query made to refer base table per_all_assignments_f
1717: WHERE j.project_id = p_project_id -- + (0 * a.person_id)
1718: AND p_item_date + 0.99999
1719: BETWEEN j.start_date_active
1749: INTO l_bill_rate,l_raw_revenue,
1750: l_rate_currency_code,
1751: l_amount_calculation_code,
1752: l_discount_percentage
1753: FROM pa_job_bill_rate_overrides j--, per_assignments_f a
1754: WHERE j.project_id = p_project_id --+ (0 * a.person_id)
1755: AND p_item_date + 0.99999
1756: BETWEEN j.start_date_active
1757: AND NVL(j.end_date_active + 0.99999,p_item_date + 0.99999)