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 PER_ALL_ASSIGNMENTS_F

Line 1631: -- Bug 4398492 query made to refer base table per_all_assignments_f

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
1635: BETWEEN j.start_date_active

Line 1715: FROM pa_job_bill_rate_overrides j --, per_all_assignments_f a /* Bug 6058676: Removed per_assignments_f and related predicates*/

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

Line 1716: -- Bug 4398492 query made to refer base table per_all_assignments_f

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
1720: AND NVL(j.end_date_active + 0.99999,p_item_date + 0.99999)

Line 2148: , per_all_assignments_f pa

2144: l_rate_currency_code,
2145: l_amount_calculation_code,
2146: l_discount_percentage
2147: FROM pa_bill_rates_all b -- per_assignments_f pa Commented for Bug 4398492 query made to refer base table
2148: , per_all_assignments_f pa
2149: WHERE b.bill_rate_sch_id = l_job_bill_rate_schedule_id
2150: AND pa.person_id = p_person_id
2151: AND pa.primary_flag = 'Y'
2152: -- AND pa.assignment_type = 'E'