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_ASSIGNMENT_OVERRIDES

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 2027: FROM pa_bill_rates_all b, pa_job_assignment_overrides ao

2023: b.rate_currency_code
2024: INTO l_bill_rate,l_raw_revenue,l_adjusted_rate,l_adjusted_revenue, l_amount_calculation_code,
2025: l_discount_percentage,
2026: l_rate_currency_code /*Rate added for bug 2636678 */
2027: FROM pa_bill_rates_all b, pa_job_assignment_overrides ao
2028: WHERE ao.person_id = p_person_id
2029: AND b.bill_rate_sch_id = l_job_bill_rate_schedule_id
2030: AND b.job_id = ao.job_id /*modified for bug 9257637 */
2031: -- AND b.job_id = pa_cross_business_grp.IsmappedTojob(p_resource_job_id,l_bill_job_grp_id) /* Bug 6058676 *//*commented for bug 9257637 */

Line 2074: FROM pa_bill_rates_all b, pa_job_assignment_overrides ao, pa_tasks t

2070: DECODE(l_discount_percentage,NULL,'B','O'),
2071: nvl(l_discount_percentage,l_labor_schdl_discnt)
2072: INTO l_bill_rate,l_raw_revenue,l_rate_currency_code,
2073: l_amount_calculation_code,l_discount_percentage
2074: FROM pa_bill_rates_all b, pa_job_assignment_overrides ao, pa_tasks t
2075: WHERE ao.person_id = p_person_id
2076: AND b.bill_rate_sch_id = l_job_bill_rate_schedule_id
2077: AND b.job_id = ao.job_id
2078: -- AND b.job_id = pa_cross_business_grp.IsmappedTojob(p_resource_job_id,l_bill_job_grp_id) /* Bug 6058676 *//*commented for bug 9257637 */

Line 2123: FROM pa_bill_rates_all b, pa_job_assignment_overrides ao

2119: INTO l_bill_rate,l_raw_revenue,
2120: l_rate_currency_code,
2121: l_amount_calculation_code,
2122: l_discount_percentage
2123: FROM pa_bill_rates_all b, pa_job_assignment_overrides ao
2124: WHERE ao.person_id = p_person_id
2125: AND b.bill_rate_sch_id = l_job_bill_rate_schedule_id
2126: AND b.job_id = ao.job_id
2127: AND ao.project_id = p_project_id