eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_REVENUE dependencies on PA_JOB_BILL_RATE_OVERRIDES

Line 447: FROM pa_job_bill_rate_overrides j

443: j.discount_percentage
444: INTO l_bill_rate,l_raw_revenue,
445: l_rate_currency_code ,-- Added for MCB2
446: l_discount_pct
447: FROM pa_job_bill_rate_overrides j
448: WHERE j.task_id = p_task_id
449: AND TO_DATE(p_item_date)
450: BETWEEN TO_DATE(j.start_date_active)
451: AND NVL(TO_DATE(j.end_date_active),

Line 532: FROM pa_job_bill_rate_overrides j

528: INTO l_bill_rate,
529: l_raw_revenue,
530: l_rate_currency_code, /* Added for MCB2 */
531: l_discount_pct /* Added for discount percentage*/
532: FROM pa_job_bill_rate_overrides j
533: WHERE j.project_id = p_project_id
534: /* 0.99999 added to the dates so that the starting clause of
535: the between condition does not have aby function on it so
536: as to better use the index */

Line 1465: FROM pa_job_assignment_overrides a, pa_job_bill_rate_overrides j

1461: INTO l_bill_rate,l_raw_revenue,
1462: l_rate_currency_code,
1463: l_amount_calculation_code,
1464: l_discount_percentage
1465: FROM pa_job_assignment_overrides a, pa_job_bill_rate_overrides j
1466: WHERE j.task_id = p_task_id
1467: AND p_item_date
1468: BETWEEN j.start_date_active
1469: AND NVL(j.end_date_active,p_item_date)

Line 1510: FROM pa_job_assignment_overrides a, pa_job_bill_rate_overrides j

1506: decode(j.discount_percentage,NULL,'O','T'),
1507: j.discount_percentage
1508: INTO l_bill_rate,l_raw_revenue,l_rate_currency_code,
1509: l_amount_calculation_code,l_discount_percentage
1510: FROM pa_job_assignment_overrides a, pa_job_bill_rate_overrides j
1511: WHERE j.project_id = p_project_id
1512: AND p_item_date
1513: BETWEEN j.start_date_active
1514: AND NVL(j.end_date_active,p_item_date)

Line 1554: FROM pa_job_assignment_overrides a, pa_job_bill_rate_overrides j

1550: decode(j.discount_percentage,NULL,'O','P'),
1551: j.discount_percentage
1552: INTO l_bill_rate,l_raw_revenue,l_rate_currency_code,
1553: l_amount_calculation_code,l_discount_percentage
1554: FROM pa_job_assignment_overrides a, pa_job_bill_rate_overrides j
1555: WHERE j.task_id = p_task_id
1556: AND p_item_date
1557: BETWEEN j.start_date_active
1558: AND NVL(j.end_date_active,

Line 1601: FROM pa_job_assignment_overrides a, pa_job_bill_rate_overrides j

1597: INTO l_bill_rate,l_raw_revenue,
1598: l_rate_currency_code,
1599: l_amount_calculation_code,
1600: l_discount_percentage
1601: FROM pa_job_assignment_overrides a, pa_job_bill_rate_overrides j
1602: WHERE j.project_id = p_project_id
1603: AND p_item_date
1604: BETWEEN j.start_date_active
1605: AND NVL(j.end_date_active,p_item_date)

Line 1649: pa_job_bill_rate_overrides j

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)
1653: AND p_item_date

Line 1692: FROM pa_job_bill_rate_overrides j

1688: j.discount_percentage
1689: INTO l_bill_rate,l_raw_revenue,l_rate_currency_code,
1690: l_amount_calculation_code,
1691: l_discount_percentage
1692: FROM pa_job_bill_rate_overrides j
1693: WHERE j.task_id = p_task_id
1694: AND j.job_id = p_resource_job_id /* Bug 6058676 */ /*bug3737994*/ /* modified for bug 9257637 */
1695: AND p_item_date
1696: BETWEEN j.start_date_active

Line 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 */

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

Line 1772: FROM pa_job_bill_rate_overrides j--, per_assignments_f a

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)