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 1446: FROM pa_job_assignment_overrides a, pa_job_bill_rate_overrides j

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)

Line 1491: FROM pa_job_assignment_overrides a, pa_job_bill_rate_overrides j

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)

Line 1535: FROM pa_job_assignment_overrides a, pa_job_bill_rate_overrides j

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,

Line 1582: FROM pa_job_assignment_overrides a, pa_job_bill_rate_overrides j

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)

Line 2008: FROM pa_bill_rates_all b, pa_job_assignment_overrides ao

2004: b.rate_currency_code
2005: INTO l_bill_rate,l_raw_revenue,l_adjusted_rate,l_adjusted_revenue, l_amount_calculation_code,
2006: l_discount_percentage,
2007: l_rate_currency_code /*Rate added for bug 2636678 */
2008: FROM pa_bill_rates_all b, pa_job_assignment_overrides ao
2009: WHERE ao.person_id = p_person_id
2010: AND b.bill_rate_sch_id = l_job_bill_rate_schedule_id
2011: AND b.job_id = ao.job_id(+)
2012: AND b.job_id = pa_cross_business_grp.IsmappedTojob(p_resource_job_id,l_bill_job_grp_id) /* Bug 6058676 */

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

2051: DECODE(l_discount_percentage,NULL,'B','O'),
2052: nvl(l_discount_percentage,l_labor_schdl_discnt)
2053: INTO l_bill_rate,l_raw_revenue,l_rate_currency_code,
2054: l_amount_calculation_code,l_discount_percentage
2055: FROM pa_bill_rates_all b, pa_job_assignment_overrides ao, pa_tasks t
2056: WHERE ao.person_id = p_person_id
2057: AND b.bill_rate_sch_id = l_job_bill_rate_schedule_id
2058: AND b.job_id = ao.job_id(+)
2059: AND b.job_id = pa_cross_business_grp.IsmappedTojob(p_resource_job_id,l_bill_job_grp_id) /* Bug 6058676 */

Line 2104: FROM pa_bill_rates_all b, pa_job_assignment_overrides ao

2100: INTO l_bill_rate,l_raw_revenue,
2101: l_rate_currency_code,
2102: l_amount_calculation_code,
2103: l_discount_percentage
2104: FROM pa_bill_rates_all b, pa_job_assignment_overrides ao
2105: WHERE ao.person_id = p_person_id
2106: AND b.bill_rate_sch_id = l_job_bill_rate_schedule_id
2107: AND b.job_id = ao.job_id
2108: AND ao.project_id = p_project_id